SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DB Audit (Case-Sensitive SQL Server)

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
DB Audit (Case-Sensitive SQL Server)
Author Message
Robert



Joined: 07 Feb 2002
Posts: 30

Post DB Audit (Case-Sensitive SQL Server) Reply with quote

Hi
Using a case-sensitive SQL Server (BIN) I get an
error during enable system audit: could not find stored procedure
'sp_AddExtendedProc'.
If I check the stored proc I see sp_addextendedproc.
Any suggestions?


Tue Jun 28, 2005 12:22 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: DB Audit (Case-Sensitive SQL Server) Reply with quote

sp_AddExtendedProc is the standard case-sensitive name. Maybe your database has been rebuild by some tools that changed the standard procedure name...

Anyway I can suggest 2 workarounds for this issue:

OPTION 1: (recommended) You can either rename the procedure to sp_AddExtendedProc and also change sp_dropextendedproc to sp_DropExtendedProc and then rerun DB Audit enable-system-audit processing step.

OR

OPTION 2: Run the following commands manually using SQL Analyzer

-- 1. Add the required extended procedure
EXEC sp_addextendedproc '[dbo].[xp_audit_init]', 'xp_dbaudit.dll'

-- 2. If you don't use trusted connections run the following 3 lines
EXEC sp_addextendedproc 'dbo.xp_audit_setlogin', 'xp_dbaudit.dll'
EXEC dbo.xp_audit_setlogin 'your password here'
EXEC sp_dropextendedproc 'dbo.xp_audit_setlogin'

-- 3. Rerun the DB Audit DB enable-system-audit processing step.

-- 4. Ensure sp_db_audit_startup automatically starts on SQL Server startup
EXEC sp_procoption N'sp_db_audit_startup', N'startup', N'true'

: Hi
: Using a case-sensitive SQL Server (BIN) I get an
: error during enable system audit: could not find stored procedure
: 'sp_AddExtendedProc'.
: If I check the stored proc I see sp_addextendedproc.
: Any suggestions?

Tue Jun 28, 2005 12:49 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.