Thanks buddy, but my job already have the schedule. I only need to update it when the holiday falls. Like say change the schedule from evening to...
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
thanks for all your support. I checked all the advice and cheked the SMTP servercis to be running. did not help me at all. Finally I requested to...
SQL server 2005 is RTM version.
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...
Microsoft will not support a 32 bit SQL server to 64 bit win 2003 server. that is what I was told. Also when I try to run the SQLdiag I could not run...
Thanks for all the help I had 32 bit SQL server and is not compatible with 64 bit operating system. I am in the process of getting 64 bit version on...
I know that but does x86 means 32 bit? what it says for 64 bit?
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...
sorry for late response. we had to reset the MSDTC as we have the server in the clustered environment. Now It is working. thanks for all of your help
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...
Thanks
Thanks guys that was helpful
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...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Separate names with a comma.
