SQL Server 2008–Recompile all Stored Procedures

Just a useful script to recompile and check all Stored Procedures in a SQL Server Database, if you have done a lot of refactoring.

declare @Schema_Pattern nvarchar(776) = NULL -- Owner name Pattern for Like, Null for all 

declare @Proc_Name_Pattern nvarchar(776) = Null -- Proc Pattern for Like, Null for all

SET NOCOUNT ON 

-- First do the user databases specified in the control table DECLARE ProcCur CURSOR READ_ONLY FOR

            SELECT ROUTINE_SCHEMA

              , ROUTINE_NAME 

            FROM INFORMATION_SCHEMA.ROUTINES

            WHERE 0=OBJECTPROPERTY(object_id(ROUTINE_SCHEMA + '.' 

                                     + ROUTINE_NAME), 'IsMsShipped')

                        AND ROUTINE_TYPE = 'PROCEDURE'

                AND (@Schema_Pattern IS NULL 

                       OR ROUTINE_SCHEMA LIKE @Schema_Pattern)

              AND (@Proc_Name_Pattern IS NULL 

                       OR ROUTINE_NAME LIKE @Proc_Name_Pattern) 

DECLARE @Owner nvarchar(776)

      , @Proc  nvarchar(776)

      , @SQL   nvarchar(4000)

      , @NumP  int

      , @NumE  int

      , @myError int

      , @myRowcount int 

SELECT @NumP = 0 , @NumE = 0

OPEN ProcCur

FETCH NEXT FROM ProcCur INTO @Owner, @Proc 

WHILE (@@fetch_status <> -1) BEGIN

    IF (@@fetch_status <> -2) BEGIN

        SELECT @SQL = 'exec sp_recompile ''' + @Owner + '.' + @Proc + ''''

        PRINT 'Running: ' + @SQL

        EXEC (@SQL)

        SELECT @myError = @@Error        

        IF @myError = 0 BEGIN

              SET @NumP = @NumP + 1

            END

        ELSE BEGIN

             PRINT 'Error Marking ' + @Owner + '.' + @Proc + ':' + convert(varchar(20), @myError)

             SET @NumE = @NumE + 1

        END

    END

   FETCH NEXT FROM ProcCur INTO  @Owner, @Proc END

CLOSE ProcCur

DEALLOCATE ProcCur

Mobile Technology WP7 unter Kontrolle

 

Heute ist in der Mobile Technology in der Ausgabe 01.2011 mein neuester Windows Phone 7 Artikel erschienen.Der Artikel gibt einen Überblick über die Windows Phone 7 Controls, zeigt Unterschiede zur Handhabung gegenüber den normalen Silverlight Controls und gibt wichtige Nutzungshinweise zu deren effektiven Einsatz.

Silverlight set initial Focus / Focus popup or ChildWindow

In our current project we had the problem, that we cannot set the Focus to a Control in an initial Login-Dialog (ChildWindow). We try some things like setting the Focus after the Loaded- or PageUpdated-Event – but nothing helps.

After some time of additional research we found out, that the original problem was the missing Focus of the Silverlight Plugin after starting the Silverlight application.

So first step we do this (“HtmlPage.Plugin.Focus” is the magic):

var loginView = new LoginRegistrationView();

loginView.Show();

HtmlPage.Plugin.Focus();

After this, we can use the GotFocus-Event of our Login-Form to set the Focus to the UserName-Field of the DataForm at our Login-Form-ChildWindow.

public LoginForm()

{

    InitializeComponent();

    this.GotFocus += this.LoginFormGotFocus;

}

private void LoginFormGotFocus(object sender, System.Windows.RoutedEventArgs e)

       {

           if (this.firstCall)

           {

               var userNameTextBox = (TextBox)loginDataForm.Fields["UserName"].Content;

               userNameTextBox.Focus();

               this.firstCall = false;

           }

       }