Mangal Pardeshi (3/4/2009)

---

I think you are taking conversation to different direction. Just relax.

I also asks those extra questions while helping someone. I could have actually posted those linkes...

And he is supposedly a Senior Software Engineer with a Masters in Computer Application and wants to pursue a Phd?

karthikeyan (3/4/2009)

---

Michael Valentine Jones (3/3/2009)

---

karthikeyan (3/3/2009)

---

The below query will give the current week's first date and lastdate.

Declare @InputDate Datetime

select @InputDate = '28/feb/2009'

select case when upper(datename(dw,@InputDate)) = 'MONDAY' then @InputDate

...

karthikeyan (3/4/2009)

---

Chris Morris (3/3/2009)

---

Can you demonstrate please, Karthik? I'd be...

Sleep, yes good it would be.

And then you have this. I don't think the desert is big enough to hide in anymore.

And, am I still Saint?

Edit: The original post linked here has been...

Mangal Pardeshi (3/4/2009)

---

Sooner the better.

The rating thing, hard to know. I think if you consistently answer poorly,...

Jeff Moden (3/3/2009)

---

nwinningham (2/17/2009)

---

I have just spoken with the person who created this function. He said that he runs this report at night. So, since he runs this...

Here is some code you may want to try in a test environment. You will need to finish the code as the BACKUP LOG statement is incomplete.

declare @RowsDeleted int,

...

Jeff Moden (3/3/2009)

---

Lynn Pettis (3/3/2009)

---

Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to demonstrate his...

Oh, wow. Looks like I may have beat Jeff. But of course, he is probably setting up a million row example to demonstrate his code, where I just...

Samuel Vella (2/26/2009)

---

mh, your solution is fine but when you test it with a lot of data against a cursor, the cursor is orders of magnitude faster

I adapted your query...

The simple answer, no. You can't tell SQL Server which processor to use when a stored procedure is run.

Slightly...

I have to agree with both of you, little bit demanding. I'd say that Jeff is also correct in that the OP wants to audit all INSERT/UPDATE/DELETE activity on...