We have a product that compares databases and generates the scripts to
synchronize them. Need to be able to compare encrypted Stored Procedures - is
there an official route for obtaining the information we need?

Which is the best tool to use for editing SQL , and debugging SPs?
Must have features are auto-complete of column members and SP parameters and
good query plan/server trace outputs.
Thanks.

I have an application which is running on 40 active workstations.  I am
encountering lock outs many times a day.  When I run the stored procedure
"sp_who2" I can see the spids that are blocked and by which other spid.
If I "kill xx" where xx is the head of the blocking chain the ...

I think this started happening post SP4.
I have an nvarchar(4000) field.  If I query the table in Enterprise Manager,
the data for the field only displays in rows where the value is 900 chars or
less.  Otherwise, the field looks empty, but when I click in it and type, I

What support will there be for running the Profiler against SQL 2000 dbs?  To
what extent can I work with trace info from a SQL 2000 DB?  Example: Deadlock
Graph?  Import Perf counters?

Does anyone know of a way to list out all the UDF's in database in a way
similar to what sp_tables, or sp_databases does?

I recently installed & ran the best practice analyzer on all of our
production SQL Servers.  The only report we ended up being compliant with was
the full-text which we don't use.  There are so many different standards that
this tool is looking for.  Are there any that are more ...

A customer asked me at a recent TechNet Briefing:
"Are there “process throttling” capabilities?  [Other database products]  
have a way to watch for processes that run out-of-control…taking up too many
resource (CPU, Memory) from the rest of the system.  I don’t see a way to do

Has any body had a problem whereby when you try and load the Server Network
Utility you get the error "The specified module could not be found". I have
SQL Server 2000 developer installed on my machine and 3 instances of MSDE and
2 of wMSDE. I have reinstalled sql server sp4, ...

I'm trying to move large quantities of data between disconnected SQL
servers.
I tried BCP, but it failed because the column order in the source and
destination tables was different.

Hi, We have a SQL server and I have installed a new instance for some
specific application database.
The installation go sucessfully coped all files and I can see the 2
instances on my Program Files folder and the 2 services running.

I have a .vbs file located on my server the path to which is:
C:\Inetpub\wwwroot\NewSites\intranet_to_internet.vbs
how can I run this file from a stored procedure within msSQL?
I have tried using

The problem that I'm having is that I cannot launch SQL Profiler by
double-clicking the .TRC file type on any maching running Windows XP with
SP2.  When I try, I get the "Open With" dialog, but Profiler isn't in the
list and can't be added.

Could anyone help to capture perfmon counters including SQL Server related to
a table on fly. I'm aware of DBCC PERFMON but it doesn't give all the
counters that are related to SQL SErver.
Thanks in advance.

Is Enterprise Manager and Query Analyzer available as separate licenses? or
downloads?