Post reply

Alter Proc

  • June 23, 2008 at 10:30 am

    #188401

    Hi,

    I know that using With Recompile in a stored procedure will lead to performance issues, but would Alter Proc do the same? I've found some stored procedures that I presume are used by the application for data acccess/modification, but they all have Alter Proc.

    Many thanks,

  • June 23, 2008 at 10:52 am

    #832907

    You cannot have an ALTER PROC within a stored procedure (except perhaps with dynamic SQL). Are you looking at the definition of the procedures by right-clicking on them in Management Studio and choosing Edit? If so, this generates an ALTER script for the procedure and you are seeing the ALTER that it uses rather than CREATE so you do not have to re-create permissions.

  • June 23, 2008 at 1:06 pm

    #832988

    Aha, thanks! I guess I haven't opened a stored procedure since SQL2000....

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

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