Post reply

Resroration of database from one server to another

  • July 24, 2008 at 11:27 am

    #194337

    Hi,

    i restrored a database from one server to another server.what shd i do to check whether all the user accounts are properly working?

    Thx

  • July 24, 2008 at 1:01 pm

    #848039

    First I'd run EXEC sp_change_users_login 'Report'. "Lists the users and corresponding security identifiers (SID) in the current database that are not linked to any login." - straight from BOL

    -- You can't be late until you show up.

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

You must be logged in to reply to this topic. Login to reply