Post reply

Profile name capacity for sp_db_sendmail

  • June 10, 2009 at 8:00 pm

    #131745

    Could some one please let me know whether there is any limitation in creating profile names for sp_db_sendmail? or how many profile names that sql server 2005 maximum support?

    Thanks a lot in advance

  • June 11, 2009 at 6:30 am

    #1007958

    manus4u (6/10/2009)

    Could some one please let me know whether there is any limitation in creating profile names for sp_db_sendmail? or how many profile names that sql server 2005 maximum support?

    Thanks a lot in advance

    Database mail profiles are stored in a couple of tables in msdb like sysmail_profile, sysmail_profileaccount etc.

    So without being totally sure I would think that the limit would be the maximum number a table can hold or in this case the maximum value for integer, because the datatype int is used for the ID column.

    But my question would be why do you think you need a lot of different profiles? I never used more than one or two profiles per database.

    [font="Verdana"]Markus Bohse[/font]

  • June 11, 2009 at 10:56 am

    #1008154

    Thanks a lot Markus...

    This question came as per the requirement from the AD team...so i guess, they need to create a number of profiles as per the app requirement...

    Thanks again!

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

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