Is this information not stored in any system table ? I have inherited a server and I just want to check for logins that may have been unused for a...

SORRY IT WAS A COMPATIBILITY PROBLEM. IT HELPS WHEN YOU CHECK THE CORRECT DATABASE !

checked compatibility and coth are running at 80. Any more ideas ?

The SP is doing a transaction log backup of all databases and I have supplied an output file on the 'advanced' option of the edit job step. Originally I ran...

THANKS FOR THAT sqlbill. I had already looked at BOL and it didn't mean a lot to me, hence the post. I was hoping someone may have experienced something similar...

i've just run the same query against our production server and get similar results !!!!!!!!!! I await a sensible explanation of this 'feature'. I am sure Microsoft will say upgrade...

Thanks for the response but it doesn't address my problem. I want to log the information on a daily basis between 10:00 and 12:00. The response only tells me how...

MarkusB,

I hadn't noticed that option on Job schedule.

That's exactly what I wanted.

Thanks,

Mike

Thank you Allen_Cui, that works a treat.

I have a mixture of logical and physical backup devices, so I assume sp_dropdevice will only work on logical devices. Also, I have used sp_dropdevice 'device_name','delfile' which does delete the...

I have devised and tested the following script which will rebuild master in SQL2K, I hope it helps.

REBUILD MASTER in SQL2000.

Here are the instructions required to rebuild MASTER if MASTER...