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

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