Question
-
Topic
-
SQL Error 9724
LockedHi,
I have been receiving the following error from my SQL Database Server, and upon veiwing the event log it seems that this error is generated around 6 per minute.
SQL: MSSQL 2005
Microsoft SQL Server Management Studio: 9.00.3042.00The following is the error:
—————————————————————-
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 9724
Date: 2/17/2009
Time: 12:24:07 PM
User: N/A
Computer: FJHRB000
Description:
The activated proc [dbo].[SqlQueryNotificationStoredProcedure-9742e284-1a83-4ca9-90eb-7546be9fce97] running on queue HRnet.dbo.SqlQueryNotificationService-9742e284-1a83-4ca9-90eb-7546be9fce97 output the following: ‘Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.’For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 000025fc 0000000a 00000009 004a0046
0010: 00520048 00300042 00300030 00060000
0020: 00480000 006e0052 00740065 0000——————————————————————
Can you please help me find out cause of it and how to resolve this.
Thanks,
Jaishiv Singh
jaishiv_singh@hotmail.com