John,

I think the issue is that, if you started with the Standard Template, the TextData column is NOT selected for the RPC:Completed event. If you go in and modify...

Christian Buettner (4/16/2009)

---

Jack Corbett (4/16/2009)

---

Just a side note. If case is that important to the application then, in my opinion, the application should be upper-casing the string in the...

john.w.walker (4/16/2009)

---

I have been doing SQL Server development for 8 years and have never gone far enough with profiler to run a trace. I read through the article and...

GSquared (4/16/2009)

---

The Thread has (as I write this) 28 posts in the last five hours. This makes 29. Of course, judging by the last page or so, it...

I don't think so if you really have a many to many relationship. Adding supplier id to brand table would make a 1 to many relationship or cause duplication...

GSquared (4/16/2009)

---

219 posts on Barry's...

Because you are not on a domain you should probably use SQL Authentication for your application.

Just a quick note to mention that this thread is an off-shoot of this thread

Just so everyone following this thread knows, ruchicka has opened a new thread about the behavior of sp_reset_connection.

Just a side note. If case is that important to the application then, in my opinion, the application should be upper-casing the string in the first place. Yeah...

Florian Reischl (4/15/2009)

---

Hi

I also don't really understand the requirement. Do you mean that you want to append the filtered result with the unfiltered one? (What I still wouldn't understand ;-)...

Check out this link.

Oh and if you get the answer from your post on SQLTeam please post it here as well.

Thanks,

I'd be interested in knowing why you are using an INSTEAD OF trigger. I have not seen many instances where an INSTEAD OF trigger was necessary. You might...

Hey Barry, I can't keep up with the comments on your article anymore. If it keeps up is might catch "The Thread".

I believe that sp_reset_connection is only available via ODBC/ADO/ADO.NET to manage connection pooling.