We have some SQL Server 2000 jobs set up to run under the SQL Server Agent each weekday at 7 pm & I was wondering whether it's possible to configure...
is there a database level trigger in SQL server. I just want to send an email if the server is rebooted. how do I do it. any help is appreciated
I have set up the DBMail on SQL server 2005 and it was fine until two days earlier. the DBmail throw an exception and all the mail is queued. here is...
Hi all I have windows 2003 R2 64 bit version of operating system. I have SQL server 2005. How do I check if the SQL server I have is 32 bit version...
I have SQL server 2005 on windows 2003 server( enterprise edition) with 64 bit. there are two exact server. One of the server is missing all the SQL...
I am getting an eror while executing the SP on the remote server as linked server. I can do a simple select statement no problem but execution of SP...
How to determine the size of the row in a table.
when I try to set up the sp_dbmail... in SQL serve 2005 it says that i need to enable the service broker. i am working on the prod and wanted to know...
I am getting this error in the event viewer. not sure what it is. I am using sql 2005 on win server 2003 sp 1. i am getting on both sql server 2005...
Hi all, I need to use this code EXEC sp_spaceused. I need to write a code that emails me the out put value from the above SP. I have SQL server 2005...
Hi everyone I am looking for the scripts that will check the drive space on my server for all the drive and if it is 80% fill I would like it to...
Hi I have two data file in two datafile group. One in primary and one in xxx. these data files are in two different drive. the one with the file in...
I have this error in SQL server log<br />**<br /><br />Message<br />SQL Server has encountered 33 occurrence(s) of I/O requests taking longer than 15...
I have the text file updated from the out put of some job scripts every hour and i need to write the scripts that will send the email to my...
Separate names with a comma.
