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