Activity overview
Latest activity by Fred Banville
Switching server license
Hi,
I'm currently reviewing SQL Monitor to see if it's a tool we could be purchasing.
My question is : Could I use a license to monitor a server while we are making tests on it and then switch the ...
Our legacy systems use 10 different databases for each environment. I would like to compare each environment (multiple databases) instead of each database after another. Very time consuming.
Also, I'd like to compare server role security and stuff like :
EXEC sp_addsrvrolemember @loginame = 'server_principal', @rolename = 'sysadmin'
GRANT VIEW ANY DEFINITION TO 'server_principal'
GRANT VIEW ANY DATABASE TO 'server_principal'
GRANT VIEW SERVER STATE TO 'server_principal'
GRANT ALTER ANY LOGIN TO 'server_principal'
Thanks! / comments
Our legacy systems use 10 different databases for each environment. I would like to compare each environment (multiple databases) instead of each database after another. Very time consuming.
Also, ...