Well, I can't take...

You don't need the dynamic sql in the cursor solution if you change the the table from sys.sysfiles to sys.sysaltfiles.

But I'd look at the code I provided above.

Give this code a try:

select

db.name as DBName,

mf.name as DBFileName,

mf.growth as Growth

from

sys.databases db

...

Change this:

set @DbGrowth =(select top 1 cast((growth) as varchar(30)) from sys.sysfiles)

to this:

set @DbGrowth =(select top 1 cast((growth) as varchar(30)) from sys.sysfiles where name = @DbName)

Please note, this is untested. ...

Matt,

Nice explanation. I'm not too familiar with the XML features, but when I took a closer look at the the data I could see that the reason book2 was...

Jack, I know what that is like. Your family will be in our prayers.

sqlservercentral.w.micmurphys (10/23/2009)

---

join is shorthand for inner join, there are other kinds of joins though: LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, so if you wanted to be explicit, you'd...

I do find that quite sexist. I happen to work with a group of female developers and they work quite while and do their research. I have also...

Betty and I bought Proud Mom and Dad sweat jackets Thursday and were wearing them today coming back from the grocery store. We were coming up in the elevator...

One of her fellow soldiers was sitting next a lady who at the end of the flight handed her (not Kassondra) a note that said "thanks for serving" along with...

Well, the graduation ceremony was great. We got to spend quite a bit of time with Kassondra Thursday and Friday, but it was a bit difficult saying goodbye again...

If you aren't having disk space issues and the LDF file is maintaining the same size, I'd leave everything alone. If you shrink the log file it will just...

Typical military, hurry up and wait. We are here on Fort Jackson waiting to get into the stadium for the ceremony. But hey, the line is finally moving.

Bob Hovious 24601 (10/14/2009)

---

What next?

"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put extra batteries...

Looks like you all are doing fine without me so far, haven't seen a cry for a Saint yet. We are about a half hour outside of Columbia SC....