• sqlfriends (1/20/2013)


    The thing I found on a dev server, the database developer has all the rights on the box

    and when he runs the build script sometimes, it accidently goes to the master database.

    One way is in the build script to add : Use userdatabase statement, then run the script, but I want also to avoid the accidental creation to master db.

    Set default database for that login to a the user database instead of master.

    Jayanth Kurup[/url]