Ok, I gather SSQL Agent terminates on errors over severity 10.  So I have stuck the command in a cmdshell call to osql.

Seems to...

And how do I then transform that lsn value into the same format as the lsn in a backup set?

Seriously tho, use the kill command to check how far through the rollback you are. (Check BOL if you don't know how).  Very rarely I have found a hard reset...

Go to the pub.

hi

Perhaps I am barking up the wrong tree here - but do you mean spids which sp_who2 suggest are blocking themselves?  If so, this is just a change in the...

queries suddenly getting real slow for no good reason is a bit late I guess...

The crystal application should be able to modify the collation on the fly (depending on how you are doing it).  At a last ditch you could create a set of...

stats are pretty fundamentally vital.  They tell the optimiser what the distribution of data for a given column is. This allows it to decide more effectively what indexes and join...

I second (third) the trauma of different collations in tempd and operational databases.  Its a right pain in the jacksy.

Backup your logins, and rebuild away.

Just remember there is a good...

The collation breaks down into several discrete chunks.  The Character set, case sensitivity, accent sensitivity, and kana sensitivity.  For perfomance I gather a binary collation is quickest.

I would suggest if...

usually I find that when a linked query fails silently it is often something simple - like the table or column on the target server not existing ... or equally...

Just leave the server on gmt... the accounts department love interesting reports like 'bob withdrew $1000 at 01:10 but he had never deposited money until 01:30'... or audited records where...

araldite in the usb ports does the trick...

Ah, table variables.  Yes I see what you mean.  However, I should point out that they DO take up space in tempdb, and have a few other side effects.  eg...