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

Question

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

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

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

Slick84 SSCertifiable Points: 5602 More actions · Answer 1

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:

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 2

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

Slick84 SSCertifiable Points: 5602 More actions · Answer 3

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:

Yelena Varshal SSC-Dedicated Points: 34286 More actions · Answer 4

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

Regards,Yelena Varsha

Slick84 SSCertifiable Points: 5602 More actions · Answer 5

Slick84

SSCertifiable

Points: 5602

November 7, 2008 at 10:04 am

#895681

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

--
:hehe:

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

Cookies on SQLServerCentral