The tag has no wiki summary.

learn more… | top users | synonyms

25
votes
5answers
52k views

Get a list of SQL Server Agent Jobs

I've got an extensive selection of these to add to a spreadsheet and don't want to go through by hand. What it the T-SQL command(s) to generate a list of SQL Server Agent Jobs?
2
votes
2answers
380 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
7
votes
7answers
4k views

Is there anyway to determine who dropped a table?

A table in the production database has 'mysteriously' disappeared. Does anybody know of any way to diagnose what the heck happened to it? And who did it? Edit 1: This is an internal app, with weak ...
1
vote
8answers
3k views

Need a resource that lists WMI perfmon classes

Does anyone have links to resources that list perfmon classes that are called by the WMI Query Language? I have some monitoring software that can pull data via WMI but I have to enter a query in WMI ...
0
votes
2answers
90 views

SQL server connecting issue

We recently installed SQL server 2000 Std. edition on my new windows server 2003 R2 server which is the additional domain in our existing windows 2003 server domain. Now i am unable to connect this ...
0
votes
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
0
votes
2answers
157 views

Sql 2000 and AWE

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon ...