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 |
|
nirakar_mal
Starting Member
1 Post |
 Posted - 2009-04-22 : 01:28:20
|
hi,
i m working in SQL notification.
i ve executed some statements to peroform sql notifications like...
--alter database login set enable_broker;
--create queue ContactChangeMessages;
--create service ContactChangeNotification on Queue ContactChangeMessages ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]);
--grant subscribe query notifications to database_principal
1st 3 statements are executing successfully, but while executing last statement error is showing "Cannot find the user 'database_principal', because it does not exist or you do not have permission.".
pls help me how to solve this problem.
Nirakar. |
|
|
|
|
|
Cannot find the user 'database_principal'