Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 503, 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: Today @ 2:22 PM
Points: 14,437, Visits: 37,833
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!
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: Tuesday, May 31, 2016 3:25 PM
Points: 9,297, Visits: 9,509
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: Tuesday, May 31, 2016 3:25 PM
Points: 9,297, Visits: 9,509
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: Today @ 2:22 PM
Points: 14,437, Visits: 37,833
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!
Post #1349031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse