Post reply

Historical Sql Login information

  • November 27, 2008 at 8:55 am

    #128320

    Yesterday someone in our office meddled with the default language on most of our sql logins.

    I really need to know what language these logins were set to use prior to yesterday. I do have backups of all databases in the instance. Any help would be appreciated.

    Paul.

  • November 27, 2008 at 2:32 pm

    #904487

    If you have backup of yesterdays master database then restore it on test server(with new name and like normal database) and check this under the restored database:

    select * from sys.server_principals

    select * from syslogins

    Manu

  • November 27, 2008 at 10:20 pm

    #904558

    Dear manu

    On executing the queries I m getting message 23 rows affected.

    Please explain the means...

    Actually the problem I m not understanding....

    Thanx

    Thanks

  • November 28, 2008 at 3:24 am

    #904650

    Thanks for your replies.

    Unfortunately when I try to restore the Master DB to the test server under a different name I get the following error:

    "System.Data.SqlClient.SqlError: There is already an object named 'sysnsobjs' in the database. (Microsoft.SqlServer.Smo)"

    Anyone know what to do to get around this?

    Thanks.

  • November 28, 2008 at 9:03 am

    #904860

    Bad suggestion from me. I forgot tht in 2005 mssqlsystemresource governs everything. Would be fine if you restore over the existing master database in any fresh test instalation.

    Experts,

    Please comment. I am out of options here.

    MJ

Viewing 5 posts - 1 through 4 (of 4 total)

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