How to moniter the sql 2005 database using ServiceBroker

See more:

SQL-Server-2005

SQL-Server

Dear All,

This is am interrupt at database. Now i wanna to monitor the sql database using service. I havs syntax of that code below

USE YourDatabaseName;

CREATE QUEUE NameChangeQueue;

CREATE SERVICE NameChangeService ON QUEUE NameChangeQueue ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]);

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO YourUserName;

ALTER DATABASE YourDatabaseName SET ENABLE_BROKER;

In the above code i dont know what is YourUserName. Any one have idea about this one please post your valuable commands. All Replies are Welcome.....

Thanks & Regards

Dhinesh Kumar.V