Very cool trick, didn't know about this. Thanks for sharing!

CURSES! Foiled again! *shakes fist*

We've got you covered 🙂

http://www.apress.com/book/view/9781430229100

Tom.Thomson (2/12/2010)

---

A very useful question. I've learned something new. Policy-based management begins to look more useful.

But I guess MS must have changed their mind at some point but forgot...

Thank you very much! I just submitted a couple of...

Nice question! Good thing our (Ken Simmons, Colin Stasiuk, myself) book on Policy Based Management (link here) is coming out soon 😉 </shameless plug>

GRE-452109 (5/27/2009)

---

don_goodman (5/27/2009)

---

It is a terrible practice to detach a database from a production server. If you had any corruption in any database file or in the server itself, you...

For ease of...

Jack Corbett (10/9/2009)

---

Melton (10/9/2009)

---

Jack Corbett (10/9/2009)

---

There is also a new concept out there is SQL Blog land started by Jorge Segarra aka SQLChicken called SQL University where some pretty well-known...

First have you ran a checkdb against the database to make sure there is no corruption? If you're going to do an upgrade, and are confident you have a good...

Jonathan Kehayias (5/27/2009)

---

jboc (5/27/2009)

---

On occasion a log file will fill up to the problem point and we could use detach/attach to delete the old log and start over. Not something...

I took the beta exam 71-450 and my experience was the same as yours. Multiple freezes, computer changes, etc. It took me the full 4 hours only because the exam...

My main production 2005 SQL Server is a physical box but recently I have deployed a new track of SQL Servers on VMWare and they have been running fine thus...

Dan Owen (1/10/2008)

---

Personally I have scheduled job on each server I administer which records daily statics for database & tables (stats, fragmentation, size, etc). I can then report on these...

use [dbname]

select * from sys.all_objects