Forum Replies Created

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

  • RE: SUSPECT database

    HI nishantha,

    you run the this screep IN Query Analyzer ,

    USE Master

    GO

    -- Determine the original database status

    SELECT [Name], DBID, Status

    FROM master.dbo.sysdatabases

    GO

    -- Enable system changes

    sp_configure 'allow updates',1

    GO

    RECONFIGURE WITH OVERRIDE

    GO

    -- Update the database...

  • RE: Jobs fail after changing "sa" password

    first we can change the password the then ran the jobs in sql server 2000.

    folowing this staps

    open the notepad

    copy

    then save the text file at changespassord.bat in c drive

    then...

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