I recently installed the SQL Server 2005 Management Studio on my workstation
and the install of this new tool removed the old SQL Server 2000 Enterprise
Manager.
Since 99% of my installed server base is still SQL Server 2000, here’s my

i am trying to to store some performance monitor counters into a SQl Server
Database (SQL 2005 Std, on a W2K3 cluster environment).
It seems to be working, using an ODBC Datasource with the SQLServer driver
(th native client is not compatible with an odbc feature according to a

We are calling BCP from a batch file but cannot figure out how to detect
whether it was successful or if it failed. With osql we use EXIT() with a
value to indicate success or failure. Is there a way to do this with BCP? Or
does it report success or failure to the calling process ...

I have numerous SQL scripts that run as jobs under SQL Server Agent.
I've been playing with the alert system and got it working using a
test script.
However, it seems that it's not possible to create a single alert and

When I write a script in SSMS (I'm using SQL Server 2005), generally the
database that pops up in the pulldown window on the menu, and which the
script runs against (unless/until I change the pulldown selection), is the
master database.  I'm working with only one database I've ...

I'm looknig for a way to implement a particular filter on a SQL trace nad
haven't been able to find a method - perhaps someone here has been
successful...
I'd like to filter out particular DDL statements from my trace. I want to

Hi MVPs,
I have a situation where I have a DB server that is in a VLAN that is only
accessable from a server in the DMZ, and I have a site operated by a service
provider that will be offering a DR facility. I want to switch on log

I have a datafile, Bendill.dat, from a SQL6.5 database I used to run some
time ago.  The machine on which this used to run is not operational any more.
I have set up SQL Server 6.5 on a virtual machine, and want to import my old
data from Bendill.dat into this SQL6.5.

Hello...
Where can I find the SSIS Designer? I need to create a DTS...
Thanks..!

I am in a SQL2k environment, and am working on a machine with maybe 500 MB of
free space on its C:\ drive, where the SQL2k binaries are installed.
I have some profiler files I generated on another box, some up to 2.5 GB in
size.

I know where BOL 2005 favorites can be found but I can't seem to figure out
or find any information about where BOL 2000 favorites are stored. Could
someone be kind enough to tell me?
I've found several references to the location for BOL 2000 favorites but

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?

When I log in and log out, I get a dialog prompting me to create a
subscription to synch Sql Server data.  I have tried to google the
issue to find out how to eliminate the dialog, without finding
anything useful.  Can someone point me to a resource?

Profiler (this is SQL Server 2005 SP2 with rollups) is reporting some
interesting duration values for stored procedure execution:
StartTime: 2007-11-01 10:17:58.180.
EndTime: 2007-11-01 10:17:58.180.

I have a SQL Server that is causing some issues when devleopers attempt to
load SQL profiler. I am an admin on the server and have no problems at all.
I have read many articles about granting permission to "Alter Trace" but I
have done that with no joy. I am wondering if this is ...