Perry Whittle - Wednesday, February 28, 2018 7:58 AM
Thanks, Perry. I based my comment on needing either sysadmin or dbo privs based on the "Permissions" or "Security" sections of the following.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-detach-db-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/databases/detach-a-database
With the idea of "teach a man to fish" and that my Google-fu apparently is lacking for this particular search, how do you find out where someone can alter a database to detach it without having sysadmin or dbo privs on the given database? For example, how do you find where it is documented that ALTER ANY DATABASE will allow you to detach a database?
--Jeff Moden
Change is inevitable... Change for the better is not.