Developer Newsgroups: SQL Server Tools

It's party time!

Martijn Tonies - 24 Feb 2006 6:16 PM - 1 message

And we're handing out the presents... A 5-year celebration of our developer tool Database Workbench. The SQL Server module was added recently, so are the Oracle MySQL modules. From this Monday until next Friday, it's a 75% discount! ...

SQL Server 2000 Uber Monitoring Tools - a request for info

quackhandle1975 - 23 Feb 2006 4:07 PM - 3 messages

Hi, I am looking to evaluate SQL Server 2000 monitoring tools for the SQL Server setup we have here. I have been looking at various tools however I was wondering if anyone out there knows of any tools that will ...

SQL 2005 generate multiple script files

John F. - 23 Feb 2006 2:49 PM - 2 messages

Does anyone know how to generate multiple script files like was possible in SQL2000? The only option I can find is to gen one huge long file, or to clipboard or query window (still one file) - the doc says its possible but I ...

Process to create db copy on another server

Ben - 23 Feb 2006 2:15 PM - 2 messages

Hello (duplicated post in sqlserver.replication) I have a production database that i would like to have mirrored on another server. I have never worked with database replication, but from what I understand, changes made to any of the replicated DBs get reflected in all ...

maintenance plans

Mcol - 23 Feb 2006 12:38 PM - 2 messages

hi, we've just upgraded from SQL 7 to 2005 standard edition, but when I try and execute a maintenance plan to backup the databases I get the error "the package could not be loaded. The step failed." Any ideas anyone? ...

Index Tuning Wizard - Overindexing

g - 22 Feb 2006 5:39 PM - 3 messages

is there a guildeline to what constitutes over indexing? 5, 10, 15, + indexes on a table? ...

Exporting directly to an ftp site

q4norm - 22 Feb 2006 4:40 PM - 1 message

Hi, I'm not sure if this is the best place to post this, but i think it is. I would like to know the best way to import a group of tables from a database to an ftp server (as a text file, .bak file, or what have you) What ...

Best Practices Analyzer

Clint Colefax - 22 Feb 2006 12:17 AM - 2 messages

Anyone know if there is a BPA coming for SQL 2005? Thank you ...

GUI ISQL for MSSQL2005

mason - 21 Feb 2006 11:07 PM - 3 messages

I am new to MS SQL Server 2005. Besides SQLCMD.EXE, is there a standalone GUI ISQL executable in the package? Also, Oracle10g has a web-based ISQL interface, does MSSQL2005 have a similar web front? I thought the reporting ...

Problems using Reporting Services.

MariaGuzman - 21 Feb 2006 6:44 PM - 2 messages

Hi, we are using reporting services 2000. Everything works fine with integrated security (windows user). But we change all the reports that didn´t use it. At this moment, the integrated security (windows user) doesn´t work. Reports this error: ...

Database documentation is important!

frederik - 20 Feb 2006 10:22 PM - 1 message

Fact: Documenting databases is not the most pleasant job , it’s a boring job and you loose a lot of time (Do you recognize this feeling?). But: database documentation is important and necessary if you want to grow, adapt it easily in the future etc. ...

DB Manual - Database documentation is important

frederik - 20 Feb 2006 10:05 PM - 1 message

SQL Server 2005 has been added to the DB Manual software. Fact: Documenting databases is not the most pleasant job , it's a boring job and you loose a lot of time (Do you recognize this feeling?). But: database documentation is important and necessary if you want to ...

SQL 2005 Quiery Analyzer (Studio)

childothe1980s - 20 Feb 2006 9:09 PM - 1 message

Hello: For some reason, even though I have the correct database highlighted on the left-hand pane, Query Analyzer (2005 Studio) wants to run (by default) my queries against the Master database. Literally, SQL strips my query off of ...