• you can use xp_instance_regread to find the startup parameters on 2005 and 2008. the key path would have to chnage for named instances.

    DECLARE @startup VARCHAR(255)

    DECLARE @arg VARCHAR(10)

    DECLARE @i INT

    SET @i = 0

    SET @startup = ''

    WHILE(@startup IS NOT NULL)

    BEGIN

    SET @arg = 'SQLArg'+CAST(@i AS VARCHAR(2))

    SET @startup = NULL

    EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer\Parameters', @arg, @startup OUTPUT

    SELECT @startup

    SET @i= @i+1

    END

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