I want to track the jobs that are running for more than one hour. Any job
which is executing from last one hour needs to send me an alert.
Please tell me how it can be done in SQL Server 2000.
Thanks in advance,

I have a maintenance plan for several DB, I have noticed that one of the DB
started giving an error in integrity check.
I think that is because i have some connections to that database.
is there any problem in kill all the connections?

Under SQL 2000 the proper syntax for adding a user to a database role was:
EXEC sp_addrolemember db_datareader, IamAUser;
According to BOL it seems that new syntax is now the proper way using:
GRANT permission [ ,...n ]  

I have a SQL Report that I have created a Custom function for, it uses
the coalesce function. This function  grabs values from multiple rows
and concatenates them into one cell. I was wondering if anyone knows
of a way that I could compare the values returned and not display it

I've configured my Server to use PAE, but the system does not seem to
be able to allocate for the memory.  I've done this work before under
a different system, but with only 4GB or ram available.  At this point
I don't mind if I can only allocate at least 3GBs.  Any IDEAS?

I need to install the SQL Server 2005 Management Studio.  I have uninstalled
SQL Server 2005 Express Edition.  But, when I insert the SQL 2005 CD#2 to
install the tools, I get that wonderfull ADD_LOCAL error that I see in the
Google groups but no solution offered.

I just setup one way trans replication.  (SQL 2000 on W2K3)
Server1 to server2 and server3
Server1 is read/write
Server2 and server3 are only used for reading

I'm having trouble backing up SQL data using Microsoft SQL Server Management
Studio Express. When I try backing up to the destination I get the error
message: "Property backupdirectory is not availabe for Settings
'Microsoft.SQLServer.Management.Smo.Settings' This property may ...

hi all, misters
I have this sql script to create tables and store procedure thats return a
resultset,the result of a select.
This resultset, I want insert it in temp table

I run a machine with sql2000 and have a lot of sites on it, with windows
2000 server.
The server run well for several months/years.
Yesterday we installed Mcafee viruscan 8.5.0i and problems started.

When I see the graphical output for the execution plan, I am able to see
whether it is an Eager spool or a Lazy spool for a Table spool node.
However, when I switch to the text-view of the execution plan (using SET
SHOWPLAN_TEXT ON or SET SHOWPLAN_ALL ON), I just see a Table ...

Gurus,
Running SQL Server 2005 SP2.  I am attempting to determine which type of
customer data is taking up the most amount of space inside their SQL
database and I know you can determine this by doing the following:  in SQL

When trying to copy a SQL 2005DB i get the following error. Any help is much
appreciated.
Performing operation...
- Add log for package (Success)

Is there a way to attach an MDF file without a Log file?
We were sent one that we just can't seem to attach.  We get the message:
File activation failure. The physical file name "F:\PDSA_log.ldf" may be
incorrect.

I would like to monitor query timeouts on my SQL Server 2005
Enterprise Edition Server.
When a query times out, I would like to get SQL Agent Alert email or
be able to have access to a report that can show me the actual SQL