pretty bad as well.

4. Everytime i open a solution, I get a message about solution vs project binding. While this is less important, it reminds me everytime i...

I have found the following significant irritations when using Managmenent studio source control:

1. It creates 'connection objects' in the project, these can be very confusing and dangerous as they can...

Hm, I can't make SQL accept that syntax. MERGE INTO is not in BOL (local or on line), so UPSERT/MERGE INTO seems to have been quietly dropped from the...

Cool! Thanks for that. It doesnt really solve the problem I have but nevermind. I am also not clear as to the benefit of EXCEPT/INTERSECT as opposed...

Haha! What you do in your spare time is up to you!!

I'll go back to duplicating logic with dire warnings in the...

Thanks but the reason why I wanted to use UPSERT is to avoid duplication of logic in both INSERT & UPDATE statements....

Bah! With the "The red house is in the middle" (house, here I assume means office!), my solution is now wrong. Unfortunately, my colleagues is now the correct...

I have deduced, only by using a powerful new feature in SQL 2005, Message Queue, that there are 2 solutions (at least) because sue can only drink beer or mountain...

Thanks very much

Have you got a script you could post for your 'DebugSP' proc? I am doing something now where this would be extremely useful? =)

Except of course this won't work if your code rolls back a transaction because your message records will be rolled back aswell

Thanks! Thats what I was thinking. What kind of latency could we expect? If it is consistantly in the 0-3 sec range I think this might be...

Is there any way of determining why an NT login has been authenticated to SQL Server? For example given this scenario

1. A user logins in to SQL using NT...

Can't post execution plan - too big!

NB: I can't do anything to this SQL because it is 3rd party.  I believe the slow running proc to be proc_NavStructAddNewNodeByUrl which is called multiple...

...Big post somehow lost by Internet Explorer where I answered all the questions...

Anway, the long and the short of it is what I am hoping to get out of this...