Do you have index on orderid? If not, tablescan can try to access the same row in both transactions I think, leading to deadlock.

Piotr

sure dragos_sv, I shouldn't be so hasty with my ideas 😀

self join is much better.

select distinct A1 from test a

where

exists (select A2 from test b where a.A1 = b.A1 and A2 = 1)

and

exists (select A2 from test b where a.A1 = b.A1 and...

Wouldn't it be better to run it asynchronously?. You don't have to schedule execution, but if you create a job that executes this sproc and call msdb..sp_start_job from you client...

I can't help you with your question, but ANSI_NULLS OFF affect only comparison operators. I wouldn't bother with legacy objects (that is, if you have choice). I had the opposite...

I have an impression that there is something about certificates around Service Broker. It is possible that you have to export master certificate and import it on second machine.

Piotr

You have to use dynamic sql. Look for sp_executesql in BOL.

How many tables are involved in this process? Wouldn't it be better to create separate procedure for each table? I...

look at the PIVOT command in BOL

It is because when you recreate user account in AD, it has different SID. And it is SID that is used during authentication process. You have to drop and recreate...

as in deny everyone from executing it? this is from BOL, DENY statement.

USE AdventureWorks;

DENY EXECUTE ON OBJECT::HumanResources.uspUpdateEmployeeHireInfo

TO Recruiting11;

GO

Yes I can do it as well, but I suppose the problem is in first assignment. The variable is declared as datetime but then a string is assigned to it...

You, as programmer decide what is to be saved. If you have a grid with subjects for a class, they won't be saved unless you implement the functionality. In you...

Sorry, I don't want to be offensive, but you don't have by any chance BOL installed on your machine?

Syntax is same. I just checked.

here you go, from Books On Line:

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',

'SELECT GroupName, Name, DepartmentID

FROM AdventureWorks.HumanResources.Department

...

Perhaps you could consider logon triggers?