Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    15

    Unanswered: store procedure vs system tables

    when deleting or creating a store precedure, what are the system tables or files affected?

    TIA!!

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Bit worried that anyone should ask this question.

    sysobjects
    syscomments
    syslockinfo

    maybe
    sysdepends
    syscacheobjects

    sure there are others too.


    files?
    the database files and possibly master files will be affected.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    If the Stored procedure has any parameters, you will also get entries in the syscolumns table.

    Regards,

    Hugh Scott

    Originally posted by nigelrivett
    Bit worried that anyone should ask this question.

    sysobjects
    syscomments
    syslockinfo

    maybe
    sysdepends
    syscacheobjects

    sure there are others too.


    files?
    the database files and possibly master files will be affected.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •