Post reply

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

  • November 7, 2008 at 9:36 am

    #895657

    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:

  • November 7, 2008 at 9:40 am

    #895661

    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

  • November 7, 2008 at 9:48 am

    #895669

    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:

  • November 7, 2008 at 9:59 am

    #895677

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

    Regards,Yelena Varsha

  • November 7, 2008 at 10:04 am

    #895681

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

    --
    :hehe:

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

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