Need a "Test" or Dummy XP Dll

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » General » Need a "Test" or Dummy XP Dll

Need a "Test" or Dummy XP Dll

Rate Topic

Display Mode

Topic Options

Author

Message

RBYoung

Posted Tuesday, August 21, 2012 3:04 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:33 PM
Points: 504, Visits: 107

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.

Post #1348104

Lowell

Posted Tuesday, August 21, 2012 3:12 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 11,791, Visits: 28,075

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1348107

RBarryYoung

Posted Tuesday, August 21, 2012 7:13 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Thanks, Lowell. I'll give it a try.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #1348152

RBarryYoung

Posted Wednesday, August 22, 2012 3:56 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

That worked perfectly, it was exactly what I needed. Thank Lowell! Smile

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #1348787

Lowell

Posted Thursday, August 23, 2012 5:23 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 11,791, Visits: 28,075

RBarryYoung (8/22/2012)

That worked perfectly, it was exactly what I needed. Thank Lowell! Smile

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1349031

« Prev Topic | Next Topic »

Permissions