• try taking the single quotes away from around your parameters

    CREATE Procedure [dbo].[SetDefaultDatabase]

    @LoginString NVARCHAR(50),

    @DatabaseString NVARCHAR(50)

    As

    Begin

    Set NoCount On

    Exec sp_defaultdb @loginame=@LoginString, @defdb=@DatabaseString

    End

    GO

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]