Viewing 4 posts - 1 through 4 (of 4 total)
For each database do ( including msdb - will allow view jobs )
GRANT VIEW DEFINITION TO [<USERNAME>]
And
USE [msdb]
GO
ALTER ROLE [SQLAgentReaderRole] ADD MEMBER [<username>]
GO
USE [msdb]
GO
ALTER ROLE [SQLAgentUserRole] ADD MEMBER [<u8sername>]
GO
June 8, 2022 at 5:38 pm
I'm not able to reproduce your situation with sqlserver 2019.
I restored a database backup to a db with a different name ( example backup of T1 database is restored to...
June 7, 2022 at 2:47 pm
It depends.
If your query does a full scan of those tables because it needs all data from those tables then index are useless.
If the optimizer determines that full table scan...
June 7, 2022 at 2:24 pm
Viewing 4 posts - 1 through 4 (of 4 total)