SQL Server Tools

I'm having an issue with a SQL 2000 cluster.  On each node, there always seems to be only one instance of perfmon SQL objects available at a time.  There are 3 instances of SQL installed on the cluster, default, PROD0 and ...

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 ...

Hello, 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 ...

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 ...

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 ...

On our machine, running SQL Server 7, we don't get any problems. However, on a client's SQL Server 7 machine, we get the error message: SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQLServer Driver]Attempt to read unknown ...

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 ...

Hi, 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 ...