george sibbald (12/9/2011)

---

Kenneth, thanks for the article. couple of points: are you sure the SQL restart is necessary to get this working, and the error you will often see returned...

John.Sansom (12/9/2011)

---

Kenneth, an excellent effort at covering a challenging a topic. Good stuff!

One question I imagine other readers might have, "how would the implementation steps differ, if at all, were...

Great article. During our morning meeting my boss commented that he saw a deadlock on a high profile server that goes live Friday and couldn't find any information on...

Oh I agree 100% that you should be able to enable some type of logging to find out what happend. I was just trying to respond to that part...

I...

Is there any reason not to remove the default schema on any principals where the schema is not in use? With a few exceptions such as dbo and guest....

Great question. I debated for awhile, completely forgot the way data is stored in pages, and got the answer wrong. But I really enjoyed reading why 🙂

djackson 22568 (11/29/2011)

---

HA HA HA HA HA HA, ROFL!!!!!!!!!!!!!!!!!!

Where...

rashton (11/16/2011)

---

Admittedly, getting it right may have biased my opinion, but I have to say that this is possibly the best QotD I've tried so far so please, more like...

john.arnott (11/3/2011)

---

Thank you for this mini-lesson in dynamic SQL. And don't fret too much over the minor glitches -- I know from experience that it's a lot harder than...

Lynn Pettis (11/3/2011)

---

Tarsha Shannon (11/2/2011)

---

Thanks for the replies everyone!

SSCrazy,

I actually need to enable autogrowth for both the data and log file for each database, the maxsize would be 150MB...

Believe it or not sysaltfiles will simplify things. Here is the code with just a single loop using a join between sys.databases and sysaltfiles. Note I'm still just...

Tarsha Shannon (11/2/2011)

---

Thanks for the replies everyone!

SSCrazy,

I actually need to enable autogrowth for both the data and log file for each database, the maxsize would be 150MB for data...

I had thought of using sp_msforeachdb. But for each database you have to scan through all of the data files (and/or log files depending on what the requirements are)...

I don't know any way to alter multiple databases in once statement but you might consider creating a simple cursor on sysdatabases, then generate dynamic SQL to do the alter,...