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