What you've done with sp_getapplock is completely lock down all the resources used by all the transactions within a given connection. It's a very harsh method for eliminating deadlocks. I...

Whoops. Assumptions will get you. Sorry.

BOL = Books Online. The documentation that comes with SQL Server.

If you can't modify the code directly, but you're getting this error, you may want...

Well, see, I'm right!

😀

It's basically telling you that the procedure had a high enough cost that it thought parallel execution would help. When executing in parallel, it caused a deadlock. First one I've...

SriSun (12/11/2007)

---

I am sorry for giving you very little information.

Actual process: I check for @geolevel (doesn't exist), call another procedure (proc1 which takes couple of parameters along with @geolevel) and...

You only want to put that stuff in as a last resort, usually because of some sort of design error, bad index, or something else that you can't spend time...

What Jason said.

But remember, it's going to force the optimizer to make other choices. Every so often those other choices might work better, but then it's because the HASH join...

Connect with a user that has more restricted rights to the file.

You wanted four rows instead of three, right? Try this:

select typeId, trypename, typeInfoDesc

from types t left join typeinfo ti

on t.typeId = ti.typeInfoId

AND typeinfoId2 = @infoNr

In a case like this, use the tool above or, if you want to roll your own, SMO (SQL Management Objects) allows you generate SQL scripts by object or for...

But if you're using the GUI and you still need to change the schema, display the properties page from the table creation screen. You can change the schema there. Same...

It can be useful if you're returning a large amount of data and you don't want to wait for all the rows to process prior to the data returning. You...

If you're getting primary key violations, something else is up. You may also need to post the structure of the table you're inserting into.

Is that the complete procedure? Is there...

We use just 1204. I'm wondering though if we shouldn't switch it over to 1222. The XML output looks easier to read. Anyone using that?

Not stupid, you just needed a nudge.

I've been going around telling all & sundry that the bit data type wouldn't take a null. Then Gail just simply tells me I...