Post reply

Maximum no. of Trigger & Stored Procedures

  • August 31, 2004 at 5:47 am

    #86359

    What is the maximum number of triggers and stored procedure that can exist in a database?

  • September 1, 2004 at 11:45 am

    #521398

    It doesn't directly answers your question, still good to keep in mind:

    It could be the maximum number of:

    -32,767 databases per Server;

    -2 bln objects (tables) per database;

    -1024 columns per table

    -8060 bytes per row

    I didn't find anything else related to your question, so I could say it may be limited, based on the above, to your business need/common sense and physical space.

Viewing 2 posts - 1 through 2 (of 2 total)

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