locked
Tracing of query in sql server 2005 RRS feed

  • Question

  • hi friends,

    Is it possible that while a query is running in sql server 2005 but cann't be possible to trace it in profiler or in activity monitor.


    Thanks in Advance
    Ravi
    Wednesday, October 6, 2010 5:03 AM

All replies

  • SQL trace would capture all queries running on an instance based on the filters that were applied


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    Wednesday, October 6, 2010 5:43 AM
  • Actually every  query you can trace, I have not tried it by my self but running encrypted stored procedure you may not see the actual query.......

     

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, October 6, 2010 6:01 AM
  • Actually every  query you can trace, I have not tried it by my self but running encrypted stored procedure you may not see the actual query.......

     

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, October 6, 2010 6:01 AM
  • Ravi,

    SQL Server Profiler trace captures data based on selected event classes, data columns, and filters.

    It is possible by two ways to trace an instance of SQL Server: you can trace with SQL Server Profiler, or you can trace using system stored procedures.

    To keep traces from becoming too large, you can filter them so that only a subset of the event data is collected.

    If a filter is not set, all events of the selected event classes are returned in the trace output.


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    Wednesday, October 6, 2010 7:14 AM
  • Actually every  query you can trace, I have not tried it by my self but running encrypted stored procedure you may not see the actual query.......

     

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    If its encrypted, i would show text as "-- Encrypted text" but you would see SP:Starting for the procedure.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, October 6, 2010 7:57 AM
  • Another possibility of such issue would be that you are running client side trace on heavily loaded server. Profiler may drop few events.
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, October 6, 2010 8:22 AM
  • Thanks to every one,

    But my question  was :

                               can we have any possible  sql configuration setting so that query running on a partcular client can not be traced at all other than  by defining encrypted stored procedure.

     

     

    Thanks to all

    Ravi

     

    Saturday, October 9, 2010 8:23 AM
  • I am not aware of such configurations


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 11, 2010 6:20 AM
  • Thanks to every one,
    But my question  was :
                               can we have any possible  sql configuration setting so that query running on a partcular client can not be traced at all other than  by defining encrypted stored procedure.
    Thanks to all
    Ravi 

    What is the reason of providing such "feature" ? This means that you are providing "licence to kill" to client without any trace behind. :)
    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, October 11, 2010 6:36 AM
  • hi  friends,

                               Sorry  for responding so late.

     

    Any way thank u all  very very much.

    Monday, October 25, 2010 12:26 PM