• what want do to enable 'sa' account and add privilege to user ?

    I think the 'sa' account is due to be deprecated in future versions of SQL Server but has the same privileges as sysadmin so you'd be better off using sysadmin but as Perry has said - if you're not the DBA for the server/DB then you'd need to contact them first rather than granting yourself access and then incurring the wrath of a scorned DBA!! :crazy:


    MCITP
    MCTS - E-Business Card
    Twitter: WWDMark

    Try not! Do or do not, there is no try

    email: info@weekendwebdesign.co.uk
    Personal Website: http://markallen.co.uk/
    Business Website: https://www.weekendwebdesign.co.uk