August 21, 2012 at 3:04 pm
I am working with a customer of mine to implement Audit alerts (from a C2 trace file) when/if someone adds an Extended Procedure to one of their SQL Servers.
Now, I think that I have figured out how to do this, but the problem is, I do not have any way to test it, because I don't have any extended procedure DLLs that I can use. I don't know how to make one either, and to be frank, I really do not want to invest the time to learn how to make one, nor to learn how to use VC++ well enough to do it compile one either.
So. What I am hoping, is that some nice person here already has (or knows of) a test or dummy extended procedure DLL that I can use for testing adding and removing an extended procedure.
Any help appreciated.
August 21, 2012 at 3:12 pm
grab the old SQL 2000 DBA Toolkit Part from this SSC Article:
http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/
that's the one that added regular expressions encryption and more to SQL 2000 via extended procs.
when you got o register them, you'll be able to trigger the test you wanted, i think.
Lowell
August 21, 2012 at 7:13 pm
Thanks, Lowell. I'll give it a try.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 22, 2012 at 3:56 pm
That worked perfectly, it was exactly what I needed. Thank Lowell! 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 23, 2012 at 5:23 am
RBarryYoung (8/22/2012)
That worked perfectly, it was exactly what I needed. Thank Lowell! 🙂
Sweet! glad that worked! I know I had installed it once on both a 2005 32 bit, and a 64 bit 2008 as part of some upgrades for existing databases and functionalities, but it has been a while.
Lowell
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply