Is that the query or is it mailto:jeff.moden@supersqlguy.com?

Two weeks is US standard. I actually have a contract specifying more.

Did your previous employer set their own policy? Is that legal in NZ?

I removed language that was offensive from the posts. It was not intended to show Crazyroc in a bad light, but to remove offensive language. Adding it back doesn't prove...

You don't need a set, just restore it.

I don't think so. I think the diff backup is when it ends.

You could just offset your logs slightly. It will also tell you if you're out of sequence with...

I'd agree with Gail here. You might cause issues with the TOP 1 if you have multiple rows updated

I'd argue his real problem appears to be a lack of communication. He doesn't appear to understand how to frame a problem or question.

I'd also check and be sure the server is running.

I have edited a number of posts here as there's no place for calling names in the forums. If you don't receive the answer you like, please ask, or ignore...

Moving to 2005

That message is usually when you have striped the backup to multiple files.

Do you have the backup command, and the restore command?

The thing is, if you need one unique ID, why get 25? That seems like a waste of resources.

It seems as though you've described a portion of your problem, not...

I have a Kindle

http://www.sqlservercentral.com/blogs/steve_jones/archive/tags/Kindle/default.aspx

Well said, Ross.

I'm with you, they can make more, but not at a ratio out of line with workers. If employees don't get bonuses, neither do execs.

I think synonyms are always per object.

But if you call

Select * from Div1.POTable

in the Div 1 DB and then from Div 2

select * from Div2.POTable

You can make a synonym that...