Re: On sysprocplan being locked

if the modified temp tables are used by stored procedures and they have
been altered after the procedure was optimised then yes the procedure
will need re optimised

if the version number any table used by the stored procedure is
different from when the procedure was last optimised then the
procedure will decide it needs to be re optimised

dropping and recreating a table will change the version number (and the
tabid amongst other things)

adding and droping indexes will change the version number of the table

as will changing user permisions on the table

this is not a comprehensive list

.

Relevant Pages

  • Stored Procedure
    ... Are stored procedures are precompiled in SQL Server. ... John. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • How do I change a field name from vb code?
    ... I have a database with many tables which have field names including the ... MSSQL and this kind of field name is not accepted in stored procedures. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Getting native database type
    ... create stored procedures for modifying the table. ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Determining native database data type?
    ... create stored procedures for modifying the table. ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VIEWING A TABLES STRUCTURE AND INDEXES
    ... >and indexes using SQL Query Analyzer or using stored procedures. ... Best, Hugo ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)