Friday 30 December 2011

SANCHAY POST DCL QUERY

1. Run Query Analyzer
    Select POST database and Exceute the following command

    Select sid from sysusers where name = 'DCL'

    Eg. The result like this 0xB7165F12378..........
   
Copy this value

2. Execute these commands one by one
   
    sp_configure 'allow updates', 1    Highlight the query Press Ctrl E
   
    reconfigure with override     Press Ctrl E

3.    Select Master databse and excute the following statements:

    Update sysxlogins set sid = <Paste previous copied value  eg. 0xB7165F12378.........>
    where name = 'DCL'

4. Execute these commands one by one
   
    sp_configure 'allow updates', 0    Highlight the query Press Ctrl E
   
    reconfigure with override     Press Ctrl E

0 comments:

Post a Comment