SQL Server Tools

Hi all My software exports the tables and views of the database catalog and tries to exclude system tables. Therefore it checks the table type. If you click on the menu "Database Diagrams - New Database Diagram" in the "SQL Server Management Studio Express", you'll be ask to create ...

Anyone have a recommendation for a good inexpensive or free utility for developing table schemas. ...

I have read at a few places that sql2k cannot claim back the text space used for data, we just moved a database created in sql2k to sql05 Enterprise Edition and it still cannot claim back the text space. At one time, the ...

Hi, we got a new SQL Server comparison tool and we're looking for people's opinions of it. our main strengths are that you can also compare databases to a past image of itself, and that our migration scripts ...

All, Is there any way to track what tables are being changed by an application. We have a third-party application that uses SQL server and for support purpose, I would like to know what tables are being updated by certain ...

Red Gate Software is doing some preliminary research around the area of database development processes, especially in relation to source control and versioning. If you are a SQL Server database developer, we would much appreciate your participation in our short survey, which ...

SqlServer 2005 => SMS => Object Explorer => Programability Filter => Filter: Contains _aaa_  shows all stored procs that include the string _aaa_,  works great. SqlServer 2005 => SMS => Object Explorer => Programability Filter => Filter: Contains _yyy_  shows all stored procs that include the string _yyy_ ...

Hello all, Is there a stored procedure or function that I can run in QA that will tell me the size of each data & log file and free space/space used for each of those files for EVERY database I have on my server? (the equivelent of Right-click DB>All Tasks>Shrink ...

I am currently in search of a query analysis tool to query SQL  Server 2005 data using a Unified Dimensional Model (UDM). The features I am looking for are similar to SAS Enterprise Guide that allows the end user to build query ...

With Query Analyser for SQL Server 2000, when I open a .SQL script and execute it, the 'Messages' tab of the Results pane contains the results of executing the script, including any errors.  How do configure QA or otherwise (e.g. by a command in the script), so that the each SQL command is ...

In SQL 2005 Server Management Studio, when you type T-SQL commands into a SQL query box, keywords are colored blue, comments are green, etc. (by default). Why is the word SERVICE colored blue like a T-SQL keyword? Thanks. ...

To reproduce the problem, run the following script in AdventureWorks. CREATE UNIQUE NONCLUSTERED INDEX [IX_ProductReview_Test] ON [Production].[ProductReview] ([ProductID] ASC, [ReviewerName] ASC) INCLUDE ( [ProductReviewID]) WITH (PAD_INDEX  = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] Script the database by right-clicking AdventureWorks, choose Tasks, Generate ...

Hi, We are in search of beta testers for our new SQL Comparison and migration tool (schema and data). Basically, you download, test it, send us bug you've found or quick feedback, and in return we give you a ...

I am assisting in the migration of databases from an SQL Server 2000 cluster to an SQL Server2005 cluster, using the Copy Database Wizard. It has been nothing but trouble with one thing or another, but it's now finally to the ...

I am trying to create a SQL server performance dashboard for a 50 SQl Server DBs boxes with one or two DBs in each box. For instance, on my winform or asp page I would have a dropdownlist of all servers in my environment; once a ...

Hi I run a reindex of a 130GB dabase on SQL 2000 and it takes almost exactly 4 hours. IF I run exactly the same command on a 2005 box against a restore of exactly the same database, it takes almost exactly 8 hours. ...

I have got sql 2005 installed and the management studio has stopped working. Now when I try and open it up, I see the splash screen for a split second and then nothing. I tried uninstalling BOL (july 2006) which some posts suggested but it still ...

...