Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005

  • I'm running SSMS , SQL Server 2005. Was running this query on a DB which has a backend on SQL Server 2000. Could that be it?

    --
    :hehe:

  • Yes it is.

    Management Studio is just a client tool. Your queries are going towards the actual server which in your case is of version 2000

    Regards,Yelena Varsha

  • Cool.. so then.. how can I pull of this same trick while having SQL Server 2000 as the backend DB ? I know sys.objects does not exist...but can't think of a work-around..hmm..

    --
    :hehe:

  • In 2000 all objects are in sysobjects and the definitions are in syscomments in the text column

    Regards,Yelena Varsha

  • Great, Thanks! Will try it out..:D

    --
    :hehe:

Viewing 5 posts - 31 through 35 (of 35 total)

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