Comments
Sort by recent activity
I think it would be very useful. / comments
I think it would be very useful.
No it didn't. I ran:
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use _dba
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use master
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use model
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use msdb
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use SQLBackpTest
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use SQLBackpTest2
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use STB
And all gave a result of '1'. / comments
No it didn't. I ran:
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use _dba
SELECT IS_SRVROLEMEMBER('sysadmin', 'CORP\sqlsrv')
SETUSER 'CORP\sqlsrv'
use master
SELECT IS_...
Excellent thought.
I did as you asked:
use _dba
use master
use model
use msdb
use SQLBackpTest
use SQLBackpTest2
use STB
Completes successfully. / comments
Excellent thought.
I did as you asked:
use _dba
use master
use model
use msdb
use SQLBackpTest
use SQLBackpTest2
use STB
Completes successfully.