Home Forums SQL Server 2012 SQL 2012 - General Altering the DB Role? RE: Altering the DB Role?
Chowdary's
SSCrazy
Points: 2978
More actions
September 21, 2014 at 10:54 pm
#1746937
SELECTSUSER_SNAME(owner_sid)AS DatabaseOwner, name AS DatabaseNameFROM sys.databasesWHERE name = 'yourdb' code]
SELECTSUSER_SNAME(owner_sid)AS DatabaseOwner, name AS DatabaseName
FROM sys.databases
WHERE name = 'yourdb' code]
Hi Perry Whittle..
Here Login Name is :Restricted,
Db Name is :Maintain
PFA....
RegardsChowdary...