SQL Server Tools

I'm having a very wierd problem with Management studio. Until today everything was working fine - I could connect to SQL Servers from my WinXP box running management studio without any trouble. Today, when I try to log in the "connect to server" box just hangs. ...

I have a DB that is growing in size, and I would like to see the amount of disk space taken up by each table. Enterprise Manager used to have a screen that displayed the total space used for each table in a given database. ...

Hi, Background: I'm working on a project with a very large number of stored procedures. Thanks to naming conventions and the filter feature of the object browser in SQL 2005 Management Studio I can filter out the ones I don't need to use. ...

While in SQL Server Management Studio I right clicked and selected Design Query in Editor ... I am able to design a query in Query Designer, but I cannot Execute SQL, it is ghosted out and I can't select it. ...

Are there any issues using the 2005 Database Tuning Advisor on 2000 servers? ...

Hello all, I'm one of those people that have to have every window inside each program maximized and all of my programs maximized (defeats the purpose of having windows ;-) ).  Every time I open QA, the Query window is not maximized. ...

I am using the SQL 2005 management studio to import a table from an access database to a SQl Server 2000. It's giving an error on an access column that is a memo field type and can't convert the memo to a varchar on sql 2000 and ...

Can someone please tell me the pros and cons of using SQL Enterprise Manager 2000 to do my backups of databases? then to use a third party program like Veritas backup exec. Looking forward to your response... Thank you in advance. ...

I am trying to script creating of a Profiler trace, and would like it to log to a table. Is there a way to do this. ?   It seems sp_trace_create procedure allows you to log only to file.  ...

myLittleAdmin for SQL Server 2005 v3.1 upgrade is now available. This new release offers several enhancements including: + Permission management + Extended properties management + Backup/Restore wizards for webhosting companies + etc... Free Lite Edition has also been updated. myLittleAdmin for SQL Server 2005 is the web-based administration tool ...

Hi Grp     I have a SQL Server 2005, on which I want to do the following     1. Audit execute permissions on all the system stored procedure.     2. Audit select, insert, update and delete on all the system tables. ...

Hi,     I was profiling the Audit Schema Object Access Event in SQL Server 2005, and when I executed the system stored procedure "sys.xp_msver" I found that the database id of the this procedure is shown as "32767" which doesn't ...

I have installed  Enterprise Manager ver 8.0 (SQL 2000) and installed SP4. Using Enterprise Manager I manually typed in the Query (Action >  Open Table > Query) select * from syscomments where text like '%COA%' Currently  this gives me three records with the field [text]  shown as empty ...

Dear ladies and gentlemen, Upscene Productions is happy to announce a new version of the database developer tool: "Advanced Data Generator" (version 1.7.0) A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, ...

When trying to import an Access DB through the Management Studio I receive an erro that my PK column is read only an the import fails. How do I change the properties of the field to allow an import? Christo ...