Krasavita (1/5/2010)

---

Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)

[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.

this is what I...

Nice article and good info.

rustman (1/5/2010)

---

CirquedeSQLeil (1/5/2010)

---

rustman (1/5/2010)

---

My SQL2008 system seems to have trouble with the 'quotename' which encloses the tablename in []. Remove that with the dbo in front of the table name...

What happens if you change the

IF @PAID_THRU < GETDATE() AND NOT EXISTS

to

IF @PAID_THRU <= GETDATE() AND NOT EXISTS

Also, have you thrown any print statements into it to see what...

Dynamic

You will need to change the Employees table in the variable to a valid table in...

rustman (1/5/2010)

---

My SQL2008 system seems to have trouble with the 'quotename' which encloses the tablename in []. Remove that with the dbo in front of the table name and Option...

I agree with Lynn,Mark and Bitbucket. The idea is to test the code against your system using your knowledge. If that means changing a variable - then change...

I would tend to lean toward the results of sys.dm_db_physical_index.

Are the tables in question heaps or do they have clustered indexes on them?

Thanks for the question.

What is the utility that you are using to see this deadlock graph?

What are the queries that you suspect are causing the deadlocks?

Tell me about it, Jimbu took me there last summer. Somewhere between Alexanders and Houttuynia.

Grant Fritchey (1/4/2010)

---

sudhakara (1/4/2010)

---

Jack Corbett (1/4/2010)

---

Sorry to say that you are basically screwed since you have no backups. Your only option is to run DBCC CHECKDB or CHECKTABLE with...

GilaMonster (1/4/2010)

---

But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data...

Thanks for posting back with the solution.