Why don't you set up a job to call your T-SQL code and schedule it for every morning? will save you work when youare in aswell.

Lloyd

thats the one,

thanks phil

hey susan,

i think sqlbill's on the right track. we had a similar problem within a multistep job where the first step of the job was to back up the database...

jeff,

have you (or anyone else) recently changed the name of your sql server?

@@servername refers to the network name of the sql server, where as the servername property of SERVERPROPERTY...

have you tried running the particular query the application is falling over on directly within query analyser (against the target database) to see if you replicate the issue or get the...

can i just add one thing, although sp_attach_db is a very useful stored proc, it should never be relied upon to successfully attach database files to a server unless those...

may i just raise my concerns that three of Steve's most recent QOD's have seemed to cause a number of areas of confusion within the group.  i am in no way doubting...

Jerome,

Sounds like a sensible solution, but have you thought of using SQL Server Log Shipping to maintain a warm backup server of your most critical database(s) / server(s) (you mention...

Thanx guys, much appreciated fhanlon you hit the nail on the head there, thats pretty much what i've come up with aswell, cheers...

I think you've hit the nail on the head there Michelle, at present I am trying to persuade the "decision makers" in our buisness to make available more resources &...