That's an interesting article (I edited the link to make it hot) and thanks for posting it.

There are lots of "geeks" among the women I know in IT, but those...

That's the trick I've used. The annoyance, however, is likely worth the chance to work at home 😛

I guess opinions can change, but I'd think that you would have a definite opinion right off about someone being worthy of the hall. That's why I'd like to see...

The dates for the objects should remain the same across a restore. It does on my test instance.

You can use a temp table to insert the data insert of selecting...

Two things, when you restore in SSMS

- Change the target db name

- Change the file names/locations.

As George mentioned the WITH MOVE clause does this in T-SQL. In SSMS, you need...

There will always be abuses. I don't think we ought to aim for a 100% correct solution. Mostly because I'm not sure what that would be.

However I think we ought...

I think lots do a good job. But there's no open-ness, or guidelines published. Each writer I hear talk about this on the radio uses a different set of rules....

I don't know how we fix this. You can have people report things to HR, but that often has repercussions. So many men overreact the other way when there is...

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....