Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need a "Test" or Dummy XP Dll Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 3:04 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 16, 2013 1:59 PM
Points: 505, Visits: 117
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
Posted Tuesday, August 21, 2012 3:12 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 12,744, Visits: 31,080
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
Posted Tuesday, August 21, 2012 7:13 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
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
Posted Wednesday, August 22, 2012 3:56 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
That worked perfectly, it was exactly what I needed. Thank Lowell!



-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1348787
Posted Thursday, August 23, 2012 5:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 12,744, Visits: 31,080
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

--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 »

Add to briefcase

Permissions Expand / Collapse