I can't reach that URL.  IE keeps complaining about a bad gateway.

Is there a KB # or a search term I could use to find it?

FYI: The Query menu option only works for the window you're currently working in.  If you want a more permanent solution that sticks with every window, go to Tools ->...

You shouldn't need all the fancy substring stuff to convert properly, assuming you have good data in your fields.  Try:

Convert

(datetime, <mydate>, 103)

That's what I'm hoping. @=)  My test is scheduled in a week & 1/2, so we'll see.

My main problem is the technologies that 2k5 has but that we aren't using...

I honestly don't know that the Bully Boss laws are necessary.  Why?  Well, because there is such a thing as "Hostile Workplace Environment" which a lot of people overlook.  Usually it's...

I can't find the specific report on CNN.com (searched on "Bully Boss" and "Bully Boss Legislation").  I got a lot of hits, but not the specific report that I happened...

This is a test of the quote box system...

Aha... " 'I see,' said the blind man to his...

Your best bet is to drop the index and rebuild it if you're not sure it's created correctly.  There is no way, that I know of, to check and verify...

Just an FYI, you cannot restore transaction logs after a different full backup than the particular full backup you are using for your restore. 

The reason is because of the...

Actually, the reason I tested TableSample without the Percent was to see if it did rows and it definitely does not.  I don't even think it converts to a percentage...

But that doesn't put the quote into the little Quote window, does it?

At least, I haven't been able to make it work. 

Here's what I'm doing.  I go to someone's post,...

mforbes, I know that.  That was my second comment.  My first comment or question is this:

Veritas can backup everything on the Server.  So, it backs up the OS, the folder structure...

Or, horror of horrors, the team is re-imaging the entire server which would "convienently restore" SQL Server to the state everything was in at the time Veritas took its snapshot...

AHA!  Now that's an argument I can use. 

Thanks, Steve. @=)

Darnit... Can't get the quote thing to quote the line I wanted to quote...  Meant to quote "Also, what about...

Ahhh.  Good one, Rudy.

Forget dynamic SQL.  Use Rudy's suggestion.  It'll save you having to change even the linked server connection / alias if the hardware changes.