Thanks, Jaroslaw, for the compliment and for the code. I will incorporate that into the next version.

PS. Regarding the Linked Server name: yes, it is best in brackets...

Matt Miller (5/13/2008)

---

All right - let me wipe the egg off my face for a second. You're right - I overlooked the SQLChars as an output parameter for Functions....

developmentalmadness (5/13/2008)

---

This is true for...

Tom Garth (5/13/2008)

---

Pardon the redundacy, but does anyone have knowledge of, or better yet experience, porting 32 bit CLR functions to a 64 bit SQL Server.

I'm pretty sure that the...

JohnG (5/13/2008)

---

That's a real bad limitation! ...

Hey again, Gary. Now, some events simply do not offer that much info, unfortunately. However, I...

KB (11/8/2007)

---

But when I try to implement the trigger provided by Solomon on table IndexCapture ( I changed the table name in the trigger), the trigger gets created successfully but...

Hello Gary. I don't think I mentioned this in my article, but one requirement of the...

Jonathon Prosper (10/21/2007)

---

On another note I do appreciate you sticking your head out and writing the article on what is a common database design issue. I'd hate to think that...

I haven't used Oracle since 8i (if I remember correctly) but here are two things that I loved about Oracle and really miss in SQL Server:

1) BEFORE triggers: SQL Server...

Hello Noel and thanks.  While I do agree that triggers 99% of the time should be coded to handle batches, I felt it was a good assumption here that since...

Please see discussion at:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=375196

 

Please see discussion at:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=375196

 

(sorry this is so long but "the devil is in the details"  )

Hello.  I am a DBA facing pretty much the same issue...

As someone who had the same problem and was excited to find this thread and was then disappointed to not see the answer, I felt I would share...