Can you post the entire trigger script, exactly as it comes out of the scripter?

Thanks.

Yeah, but it's only a SQL Injection target if the tablename string is somehow coming from a user and the sProc is not executing under that user's domain account. ...

And lest we forget, we would be remiss if we did not point out that if your routine is going to be receiving the table name parameter from client code,...

She Through Whom All Data Flows (6/10/2009)

---

...

So my take on this is that I can only pass where-clause-type variables as parameters via sp_executeSQL; the remained of the query (table names...

Numeric is a fixed-point format. When converting a floating-point format to a fixed-point format, it is always possible...

usman.tanveer (6/10/2009)

---

Using the deploy option in visual studio, selected the required sql server 2005 database connection and 'Unsafe' permission level.

I have the sysmtem.dll in the reference also I have included...

How are...

Grant Fritchey (6/10/2009)

---

RBarryYoung (6/10/2009)

---

Oh my, no. At StackOverflow the correct answer is to psychically determine what the OP meant and what their actual situation is and what their goals...

Grant Fritchey (6/10/2009)

---

Ok , that was odd. Again. The Thread is getting...

Jeff Moden (6/10/2009)

---

If you strip away all the small stuff that won't impact the result much when the numbers get really big, you end up with O(N²/2). That's much...

Heh. Hey, I'm not the one who asked the question, I'm just trying to answer them.

You can use Profiler to capture the queries being executed by the application.

jcrawf02 (6/9/2009)

---

Let the record state officially that I have never observed RBarryYoung to in any way condone inappropriate behavior of this sort, and that my post relating to his unfortunate...

Right. the problem is...

The thing is that this is a public forum and people can Google me just as easily as I Google them. A typo I can disclaim, but willing participating...