Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: When is the log truncated?

    I have a script for you.

        DECLARE @LogicalFileName sysname,

                @MaxTime         tinyint,

                @MaxMinutes      tinyint,

                @NewSize         int,

                -- Setup / initialize

                @OriginalSize    int,

                -- Wrap log and truncate it.

                @Counter         int,

                @StartTime      ...

  • RE: Login Failed 18456

    Try this in Query Analyzer

    DECLARE @LinkedServer nvarchar(30),

            @IP_Id        nvarchar(15),

            @LoginId      nvarchar(30),

            @Password     nvarchar(30)

    SET @LinkedServer = N'SERVER'

    SET @IP_Id        = N'999.999.999.999'

    SET @LoginId      = N'UserLogin'

    SET @Password     = N'Password'

    IF EXISTS (SELECT * FROM sysservers...

Viewing 2 posts - 1 through 2 (of 2 total)