There's no point in sending a backup to NULL. It doesn't clear the log, doesn't help space or anything else.

Roust_m is correct. Named instances cannot be renamed.

detach dbs, uninstall, reinstall, attach dbs.

Green Beer!!

are we free associating now?

Steve Dassin,

I haven't complained about the advertising of your product because it's free, and because you've only mentioned it in places where you appear to believe it fits the conversation....

My brother-in-law got out of IT back in 2000 or 2001. He was sure that sysadmins would be eliminated by automation in the next 5-10 years.

We're not even close to...

darryl.hasieber (3/17/2009)

---

No offence but thank the good lord not everyone thinks like that or we would have stopped development with DOS on a ZX spectrum and we would travel to...

I'd go with GSquared's advice. Use a good naming convention to order things together.

There's no good way to "hide" jobs from users.

And here I thought they were just being slipped into his food without him...

I have edited the question to show that this is a bad idea and include a warning to newbies.

I think it's worth pointing this out, not so someone will go...

I changed the wrong answer to "S". Didn't notice that one before 🙂

http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

Sorry, need to add SP1.

Amusement parks?

THE THREAD goes on and on. And once again, a day off, and I'm lost.

I'm a little torn on some of this stuff. Employers over the last two decades have not respected personal time from me in most cases. They have a definition of...

Here's an old one: http://www.sqlservercentral.com/articles/Miscellaneous/overviewof64bitsql/1166/

http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/Adv64BitEnv.doc

http://download.microsoft.com/download/9/b/c/9bc6f196-f17b-49d9-af55-946f279951ce/Consolidation64_16.doc

This isn't a database level issue, it's a server permissions issue to create a db. The context doesn't, AFAIK, need to be master. I suppose you could restore these from...