Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rastatoon
Starting Member
1 Post |
 Posted - 2008-08-04 : 04:01:08
|
| Could not find stored procedure SqlQueryNotificationStoredProcedure....hi,I have this error message on SqlDependency.Start(connectionString) method in ASP.NET.I create all the permissions below for my role under SQL Server 2005GRANT CREATE PROCEDURE to AbacusGRANT CREATE QUEUE to AbacusGRANT CREATE SERVICE to AbacusGRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] to AbacusGRANT VIEW DEFINITION TO AbacusGRANT SELECT to AbacusGRANT SUBSCRIBE QUERY NOTIFICATIONS TO AbacusGRANT RECEIVE ON QueryNotificationErrorsQueue TO AbacusGRANT REFERENCES on CONTRACT::[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification] to AbacusI don't find the problem ....thanks for your answers !! |
|
|
|
|
|
Could not find stored procedure SqlQueryNotific ..