Two things. First, what have you written so far to solve this problem. Second, based on the data in your original post, what whould be the expected output.

A...

Looks like you should be able to accomplish this task. Right click on the server in the Object Explorer, go to the Advanced Page. You should be able...

Now this is doable. We do...

. (7/22/2009)

---

If you're going to tell them they're not posting right then it would be a good idea if you could give them the link to the information about the...

No, and No. The x64 version needs the x64 verions of the OS, which requires that it be installed on x64 hardware.

Is it me or do I just not have enough caffine in my system yet?

?? Okay, did you have a problem you wanted help with, or did you just want to know what type of lock the code represented?

I'd like to see the solution also. I'd also like the OP to post the code he has tried writing to solve his problem as well, though, before you...

peter.nguyen (7/22/2009)

---

Sorry.

Attachments for more sample data. ignore the first sample data I sent earlier.

Here is a pic of the output that is required:

Thanks again so much for wanting to help...

Your data still doesn't match your ariginal picture. Is there a query that is run against this data that produces the data as seen in your original post?

Nevermind, STILL...

Hint:

declare @value int;

update sometable set

somecolumn = somevalue;

set @value = @@rowcount;

insert into sometable

select * from someothertable;

set @value = @value + @@rowcount;

exec dbo.InsertRowCounts 26,'Description',@value;

How's that for a hint?

Looks good to me. Test it in a test environment first just to be sure.

Care to explain the problem? LCK_M_IX is an Intent-Exclusive lock.

Have you bothered to read BOL (Books Online, the SQL Server Help System that can be accessed from SSMS by simply pressing the {f1} function key)?

You aren't holding your tongue in the right position. :w00t:

Really, you ask a question expecting an answer and don't even bother to show us anyhting?? Please read the first...