Alter the job to write the error to a file and see if it gives you any more details. You can also check the windows event log to see...

The only reason I have found to restore a system database was for a mass restore. If you a complete failure of you old system and you are moving...

There are jobs in SSIS that can be used to transfer logins, jobs, etc from one instance to another. I have never done them personally, but I do know...

Glad to help danerstein

Well can't give you the code exactly, but here is what my .NET programmer gave me. Said anyone who knows something about SMO should be able to adjust correctly to...

Anam Verma (1/26/2010)

---

Fraggle-805517 (1/26/2010)

---

I could be wrong on this, but the issue might not be the indexes, but the statistics. If you statistics start to get out of date,...

Gail,

Thank you very much. That is what I needed to know.

Fraggle

Will have to get back with you on that once I talk with the programmer as I personally know more about women than I do SMO.

Fraggle

A job is the easiest way to do it, but not the only way. You could setup a service broker queue to run the proc every night at the...

You are correct there.

However, I am still curious to know the answer to the question. I would rather have the 15 GB database on the server and...

It can be done easily through SMO. We actually have an in house process that will go through and encrypt or decrypt and entire database of procs,triggers, and functions....

Definite Congratz to that man. His book on executions plans made me look like a hero at work for take a query down from 3 hours to 15 minutes....

I could be wrong on this, but the issue might not be the indexes, but the statistics. If you statistics start to get out of date, then it is...

Any reason you don't use say

declare @MaxRecieveDate datetime

select @maxRecievedDate = max(recieveDate)

from table

where col1 = 123

By doing this you set the maxRecieveDate to the variable @MaxRecieveDate. Now you can...

I will give that a shot this weekend...