Be careful with IsNumeric. It returns true for some values that cannot be converted to int.

SELECT

ISNUMERIC('1,234.00'),

Stupid questions, I know, but have you checked to make sure that

1) The table is there

2) The name is spelt correctly

3) It's in the dbo schema

4) If your db is...

Your trigger is assuming there's only one row inserted. If there's more than one, the not exists could return true (for 1 of the records) but on another there's a conflict.

Try...

I'm not a network expert either. You might have to do a DNS lookup from the command prompt, using xp_cmdshell, then parse the results of that.

You could try ping....

What you can try, as a last resort, is to add WITH (ROWLOCK) to the update statement. I don't normally suggest hints as SQL usually does a good enough job...

A case statement in SQL can only be used within a select/update statement. It can't be used for control flow in the procedure. For the latter, use IF statements.

The form...

The lock requests are on a RID. That's not possible if there's a clustered index on the table in question. RIDs (Row Identifiers) only exist in heaps.

Can you post the...

See if you can get traceflag 1204 switched on. That outputs the details of the deadlock to the error log, including both nodes and what resource they were deadlocked on.

If...

SELECT @@Servername and SELECT serverproperty('MachineName') will get you what SQL thinks the machine name is. Typically, this is the name the machine had when it was installed, though it can be...

Ah, so it's an auto-generated query.

A transaction is not considered one statement, and you're right, the CTE would be gone by the second select. Since this is auto generated, try...

Perhaps insert the subquery portion into a temp table (or use a CTE), then you can use that in the outer query and again to get the rowcount.

You might be able to use ROW_NUMBER().

In your subquery, include another field ROW_NUMBER() OVER (Order BY ....) AS RowNo and give it any of the fields. Then if you can get...

I used the following book as partial prep for the 70-441 exam (Database solutions design) and I would highly recomend that others do NOT do the same.

http://www.amazon.com/MCITP-Developer-Microsoft-Database-Solutions/dp/0470040521/ref=sr_1_1/105-4139392-2116416?ie=UTF8&s=books&qid=1183538693&sr=1-1

The book is...

look up sp_executesql

declare

@stuff int , @sql nvarchar(1000)

EXEC