You could use a cursor, which is what I might recommend. You could get a list of dbs.

declare mycursor Cursor

FOR

SELECT NAME

FROM sys.databases

...

good point, Christian. I've added in the column to the question.

sys.objects for a system table in each database? So something like:

SELECT create_date

FROM sys.objects

WHERE name = 'sysrowsets'

Run for each db?

Lynn Pettis (1/7/2010)

---

cmcc (1/7/2010)

---

Why does it just have to be the women that do this? As an IT professional (and a male) I probably should be out there doing...

I'd agree w/ Icedread that this can be a double edged sword. Without a doubt if you help someone they'll come back to you. that's good and bad. You're building...

You are absolutely correct, and at the same...

I see both sides in this argument. BOL is inconsistent and I have added feedback to that note to various links to have this clarified at the source we use....

It might be a numbers issue, and it's hard to get statistics that are widespread, and good to point to because this is a hot point. Do we have statistics...

It's a little silly, and petty, by the writers. Is Alomar more deserving next year? I'm not sure the people voting are really doing a good job.

Alomar doesn't get in. Not sure that makes sense. I dislike a little that we somehow decide the HOF after a few years. If you don't think they belong in...

First, get more disk space. Don't talk to your manager about how much free space you have. You need a decent amount of free space in the data files, so...

Just a note that I used to manage a team of 10 DBAs. I was the next to lowest paid person in the group. This was at a large 10,000+...

good editorial, and nice reminder, Grant.

When I'm with Scouts, if we're out in the woods and something breaks, you need to have things to respond to that emergency. same thing...

It's amazing to see some of the responses here.

Men and women can both work in IT, and both excel. I doubt there is any real difference in their physical...

I see The Thread is alive and well. Happy 2010 to everyone.