Microsoft SQL Server 2008 R2 Unleashed- P98:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 914 CHAPTER 28 Creating and Managing Stored Procedures 2009-06-15 19 39 spid30s Loading cache 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading cache 2009-06-15 19 39 spid30s Loading into data cache 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading data cache 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading data cache 2009-06-15 19 39 spid30s Loading cache 2009-06-15 19 39 spid30s Loading cache 2009-06-15 19 39 spid30s Loading 2009-06-15 19 39 spid30s Loading cache into data into data cache into data cache into data cache into data into data cache into into data cache into data cache into data cache into data cache into into data into data into data cache into data If you want to disable the automatic execution of all startup procedures you can use sp_configure to disable the scan for startup procs configuration option. Setting this option to 0 disables the running of startup procedures on subsequent SQL Server restarts. If SQL Server is not currently running and you want to skip running the startup procedures you can specify Trace Flag 4022 as a startup parameter. You can set the trace flag for a SQL Server instance by using the SQL Server Configuration Manager. In SQL Server Configuration Manager perform the following steps 1. Click on SQL Server 2008 Services. 2. In
