February 7, 2013 at 7:00 am
fluffydeadangel (2/6/2013)
I don't know if you can restrict activity monitor to a single database...
To my knowledge you cannot. See my previous comments about how SQL Server does not neatly segment and expose the shared resources used by each database.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 7, 2013 at 7:28 am
Thank you all for your input.
February 7, 2013 at 7:47 am
@@
MCSE SQL Server 2012\2014\2016
February 7, 2013 at 9:24 am
February 7, 2013 at 9:25 am
db_owner role
February 7, 2013 at 9:33 am
@@
MCSE SQL Server 2012\2014\2016
February 7, 2013 at 9:36 am
@@
MCSE SQL Server 2012\2014\2016
February 7, 2013 at 9:44 am
worker bee (2/7/2013)
worker bee (2/7/2013)
opc.three (2/7/2013)
worker bee (2/7/2013)
dbo (database role) gives them access to that one and only one database.dbo is not a Database Role it is a Database User:
Forgive the verbage....but I think you understand it's for the DB. ah
Some of us get the idea but in the spirit of making proper technical distinctions wherever possible it's best not to shortcut the terminology in a way that creates an ambiguity.
A link to the Books Online article about database roles would have been sufficient by the way.
Database-Level Roles - SQL Server 2008 R2
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 7, 2013 at 10:24 am
@@
MCSE SQL Server 2012\2014\2016
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply