Need Query

• Charmer

  SSChampion

  Points: 14903

  More actions

  November 10, 2011 at 12:44 am

  #390822

  Hi Friends,

  How can i get all the user defined stored procedures, views, and indexes..?

  what would be the query i must use to get that?

  Thanks,
  Charmer

• danielfountain

  SSCarpal Tunnel

  Points: 4229

  More actions

  November 10, 2011 at 1:17 am

  #1405560

  have a look here

  http://msdn.microsoft.com/en-us/library/ms190324.aspx