Well here's a nice April Sat morning in Denver:

http://lh3.ggpht.com/_8hTidvPiTuU/SgCqmUxlXLI/AAAAAAAAAiI/pxf8WYs9zH0/s512/Apr_snow_a.jpg

And here's lunchtime:

http://lh5.ggpht.com/_8hTidvPiTuU/SgCqmB_QA8I/AAAAAAAAAiA/VMCiDCZDEa0/apr_snow3.jpg

And here's late afternoon:

http://lh3.ggpht.com/_8hTidvPiTuU/SgCqlzeT1vI/AAAAAAAAAh4/XmnjzlFDV0w/apr_snow2.jpg

It was gone by Monday.

Yep, it's usually me too!

😀

I think someone assumed all data on the same drive, which is likely for many installations.

You could do that, but what if something else happened there? I'll admit it's not a bad solution, an it's not likely something will happen, but I prefer things like...

Well because you could come to Denver, of course. We could slide you down a mountain on a piece of plastic 🙂

I would just run the backup, as Gus noted, but I'd log it somewhere as well, maybe for review the next day. Good to know these things are happening, and...

good to hear. I did the tech edit on that one.

:blush:

Thanks, and I appreciate the kind words.

Gail,

How about you go to the UK instead of me, be my agent at Red Gate, and then come here for a vacation 🙂

Well, without more info, my advice would be to delete some stuff you don't need.

anyone out there played the game of Life? Know what a degree gets you there? It gives you a better start in your career at the beginning (although you're delayed...

Not sure about that. After 10 years, most schools start removing credits. It's a business to them!...

Apologies, Lynn!

Actually you'd need to be careful with my method either way. Since you don't know which table would necessarily get updated first, you'd need your triggers to check for matching...

You would issue a GRANT EXECUTE ON XP_CMDSHELL to the user.

However I'd recommend that you create a role and then assign the rights to that, allow the user to then...