New answers tagged


Create a regular account that goes in a group that has sysadmin on the database. Then restart your SQL Server management studio and log on using windows authentication. You can start SSMS using the "Run-as" to log on with a different account than you used to log onto your desktop This gives you Separation of responsibilities between domain admins and ...

Top 50 recent answers are included