To the best of my knowledge there is no row limit on EXCEPT and I wouldn't think that there would be. Are you including the same column list in...

You aren't using nolock or SET ISOLATION LEVEL READ UNCOMMITTED are you?

ta.bu.shi.da.yu (8/17/2009)

---

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier (how do...

I think this is what you need.

"insert into MyTable(column1) values (QuoteName(" + REPLACE((DT_STR, 25, 1252) @[User::XMLTestVar1], "", "") + ", ''''))"

You may have to tweak it a little to make...

Take a look at this article, Introduction to SQL Server Profiler.

If you are more comfortable learning using videos you can check out the Mastering SQL Server Profiler Video Series[/url].

There...

Thanks Peso, but that Connect Issue is a different issue. Mine is that Profiler and Statistics IO report a different # of READS when looking at the same query....

Using OLEDB the parameter character is a ?. So your query should look like this:

Select

*

From

vpb110.pmt_app_ts >= ?

and...

You need to escape the single-quote/apostrophe in the name. This should work:

"insert into MyTable(column1) values ('" + QuoteName(REPLACE((DT_STR, 25, 1252) @[User::XMLTestVar1], "", ""), '''') + "')"

You can run this...

It definitely seems like this could be it. That begs the question, which one do you use for performance tuning? I mean the difference between the queries in...

C'mon Gail, you could have left your username and password in there. I might need internet access if I ever get to South Africa!:-P

hi_abhay78 (8/14/2009)

---

A much easier way is to create a WMI alert on it and insert the values in a table .

Let me know if you need me to type in...

Feel free to use to DM with the code as an attachment. I prefer not to give out my email address on the forums.

hi_abhay78 (8/14/2009)

---

A much easier way is to create a WMI alert on it and insert the values in a table .

Let me know if you need me to type in...

There are a few you could use:

SYSTEM_USER,

SUSER_NAME(),

SUSER_SNAME(),

USER_NAME()

I'd probably go with SYSTEM_USER.

Believe it or not your problem actually has a simple solution once you know the answer. You have defined the @item parameter as CHAR(5), yet you are only inserting...