Welcome to Sign in | Help

Re: Creeare/atasare baza de date

  •  03-07-2008, 5:44 AM

    Re: Creeare/atasare baza de date

    1. Daca tu ii instalezi SQL Server Express, ai putea modifica DB-ul model -sa semene cu ce vrei tu.
    2. Poti pune permisiuni pe un alt user ca sa faca Create DAtabase
    "CREATE DATABASE permission defaults to members of the sysadmin and dbcreator fixed server roles. Members of the sysadmin and securityadmin fixed server roles can grant CREATE DATABASE permissions to other logins. Members of the sysadmin and dbcreator fixed server role can add other logins to the dbcreator role. The CREATE DATABASE permission must be explicitly granted; it is not granted by the GRANT ALL statement."
    Vezi
    http://msdn2.microsoft.com/en-us/library/aa258257(SQL.80).aspx

    Ignat Andrei
    http://serviciipeweb.ro/iafblog
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems