SQL Notification Service on System Tables

Hot Topic

user defined function in a select
server name PROBLEM....
ROM on SQL 2005 replication
Restore a single table
Managed index in Fuzzy Lookup Error
Sql Server Begin Transaccion-Commit Transaccion problem
MSDE -> Express Upgrade problem.
Custom task database connection
Query Results Truncated in SSMS
Seperate SQL 2K Publisher, SQL2K Distributor, SQL2K Subscriber

SQL Server

Lookup - full caching vs partial caching vs no caching
How to 'attach' an existing .MDF file to the local SQL Server
Mixed Mode
Error: 'table that is required for a join cannot be reached'
How to use FlatFileSourceErrorOutputColumn
SMO and Thesaurus
Doubt in Select query
SQL Server 2005 Installation does not install sqldmo.dll
Help with Report Filter on bit field
UNION with the second set ordered

SQL Notification Service on System Tables

Hello,

Can I monitor SQL Server system tables like sys.objects or sysobjects using SQL Notification Services or any other method I need to get a notification into my component when there is a chance to sysobjects.

Also, is there a SQL Server plugin to log all SQL Traces

Thanks for your help.

~Senthamlarai




Answer this question

SQL Notification Service on System Tables

  • shamrock17

    Do you really mean Notification Services, or are you thinking of the new Query Notification functionality in SQL Server 2005 If you mean NS, there is another forum that is probably a better place for your question: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=97&SiteID=1. I would move this thread there, but I'm not sure if that's really what you want.

    If you mean Query Notifications, no, you can't monitor system tables. The restrictions on the queries you can monitor are listed here:

    Special Considerations When Using Query Notifications
    http://msdn2.microsoft.com/en-us/library/aewzkxxh(d=ide).aspx

    One of the restrictions is this:

    • The statement must not reference system tables or views, including catalog views and dynamic management views.

    Query notifications are the only notification functionality in ADO.NET. If you are looking for something different that the server might be able to provide, you will probably have better luck posting in one of the SQL Server forums, like http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=93&SiteID=1. The ".NET Framework Data Access and Storage" forum is primary geared towards ADO.NET development.

    Thanks,
    Sarah



  • SQL Notification Service on System Tables
Answer this question