Re: Dramatical performance degradation after removing / adding indexes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bojidar Alexandrov (bojo_do_not_spam_at_kodar.net)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 15:43:46 +0300

Just recompile your stored procedures and views - generate script for
drop/create and run it.

Bojidar Alexandrov

Relevant Pages

  • Re: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)
  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... Puget Sound Oracle Users Groupwww.psoug.org ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: convert to stored procedure + NDS
    ... Is there a clever way or an existing script I ... can use to find/replace multiple DDL statements in each sql script ... statements into stored procedures so I don't have to manually do so. ...
    (comp.databases.oracle.tools)
  • Re: Transfer SQL Server Objects Task not working with Stored Procedures
    ... SQL Server Objects Task is broken. ... Change the MaximumErrorCount or fix the errors. ... My preferred way of transferring stored procedures is to open SSMS/ ... 'script as Create.' ...
    (microsoft.public.sqlserver.dts)
  • Re: SET BEGIN TRANSACTION
    ... Later you can script out each stored procedure to a file ... query like to find SET BEGIN TRANSACTION and replace with BEGI TRANSACTION ... all SET BEGIN TRAN, SET COMMIT TRAN, SET ROLLBACK TRAN to BEGIN TRAN, ... the stored procedures I am using SET BEGIN TRANSACTION but SQL Server ...
    (microsoft.public.sqlserver.clients)