Need a "Test" or Dummy XP Dll

Question

Post reply

Need a "Test" or Dummy XP Dll

RBYoung

Right there with Babe

Points: 742
More actions
August 21, 2012 at 3:04 pm

#392997

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

RBarryYoung SSC Guru Points: 143329 More actions · Answer 2

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]

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

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]

Lowell SSC Guru Points: 323504 More actions · Answer 4

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!