Which master db extended stored procedures used in app. db

• Madhuri-359157

  Newbie

  Points: 1

  More actions

  August 18, 2006 at 3:09 am

  #115099

  Sub: Which master db extended stored procedures used in app. db

  Hi All

  Recently we got a recommendation from the auditor that the public role master database in sql server 2000, should not have the execution permissions on extended stored procedure.

  After removing the above permissions, we encounter some of the applications are not working.

  Application users donot know which extended stored procedure they are using in the application.

  So Is there any way to findout from the database that which are the users using what master database extended stored procedures in their application.

  Please advise

  thanks in advance

  Best Regards

  Anju

   

• Ken McKelvey

  SSCoach

  Points: 18842

  More actions

  August 18, 2006 at 3:38 am

  #655592

  Run the profiler on the bits of the application which do not work and see what is called just before they fail.

   

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  August 18, 2006 at 3:41 am

  #655594

  Yes, use SQL profiler and log all TSQL/SP queries.

  ---

  N 56°04'39.16"
  E 12°55'05.25"