Post reply

SQL 2000 question

  • December 13, 2010 at 8:55 am

    #232457

    I don't see any forum for SQL 2000, so I am posting it here.

    What is the equivalent of sys.sql_modules and sys.Procedures in SQL 2000?

    Thanks.

  • December 13, 2010 at 9:11 am

    #1261779

    I believe the limited information for these is sysobjects in SQL 2000. There were many fewer system views in SQL 2000.

    Moved to SQL 2000

  • December 13, 2010 at 9:13 am

    #1261781

    syscomments

    Alex S

  • December 13, 2010 at 9:20 am

    #1261786

    This is what I am running on SQL 2005 which displays each database name, stored proc name and stored proc definition for each database on the server: How do I do this in SQL 2000.

    sp_msforeachdb '

    select

    ''?'' AS DBName,

    object_name(s.object_id) AS SPName,

    s.*, p.*

    from ?.sys.sql_modules s

    inner join ?.sys.procedures p

    on s.object_id = p.object_id

    order by DBName, SPName'

    Thanks.

  • December 13, 2010 at 10:19 am

    #1261833

    I have resolved my own question and here it is:

    sp_msforeachdb 'select ''?'' AS DBName,Routine_name, routine_definition from ?.information_schema.routines

    order by routine_name'

Viewing 5 posts - 1 through 4 (of 4 total)

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