Post reply

Query

  • January 19, 2012 at 9:39 am

    #255199

    How do i query to check if anyone is using the XML data that exists in a table?

  • January 19, 2012 at 9:55 am

    #1436019

    Are your queries via stored proc to the table that holds this data or are they all ad-hoc?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 19, 2012 at 9:55 am

    #1436020

    if "using" means SELECT FROM that table, only way is by adding a trace so you can see who's selecting stuff from it;

    for INSERt/UPDATE/DELETE, you could add a trigger which either directly audits to a table or emails the details, or calls a notification service to audit or email or whatever you need to do asynchronously.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 19, 2012 at 10:48 am

    #1436062

    Sorry..Let me rephrase my question...

    There are 370 tables in the database. I'd like to check how many tables have XML in them.

    After I get the list of tables, I'll run a trace on it to verify who's running queries against these tables.

  • January 19, 2012 at 11:00 am

    #1436070

    There is a query on this page that should help with that.

    http://blog.sqlauthority.com/2007/08/09/sql-server-2005-list-all-the-column-with-specific-data-types/

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply