Yes it can be done, but it's risky and this is not really the place to do loops like this. I would advise you build this sort of process into...

After changing the password, write it down and put it in a safe or save it in an electronic password safe. Then don't use it except for emmergencies. In 17...

It would be good if you posted the error message when the restore fails. Also look in the logs and see what happened 3 weeks ago when it started failing.

In...

MB-400824 (1/25/2011)

---

Craig,

sp_calculations does not make any subcalls. The way I have the proc is that I create the T-SQL on the fly. I try to minimized code maintanence, so, I...

Do you actually get...

Having the table definitions would help, but some of your logic seems a bit odd.

Based on the way your query is set up, this WHERE Clause is always true: ((@RTSelection...

By the way this is an issue on SQL 2005. If you detach a file and copy/move it to a new location you lose permission on the file. For this...

ramadesai108 (1/13/2011)

---

Thanks for the articles. So there is no way of knowing whether the object is cached or not. But what I can look for is consistency whether the same...

Here are two articles, unfortunately both a bit old that expand on this....

I know, and so is trying to work out what exactly Profiler is...

We are busy testing it or our clients. I'll let you know when we give it a thumbs up if you want.

Leo

Reducing READS tends to be...

You may also want to run this: select * from sysjobhistory

Leo

Have you run: SELECT name, job_id from msdb.dbo.sysjobs where name = 'Backup_WebReq_Log' ?

Possibly check all your SQL Servers

Leo

Do you possibly have another server that is running the job?

Leo