Viewing 8 posts - 1 through 8 (of 8 total)
What do you mean by account ? login or user database or both ?
If the question is only for login there here are 2 possibilities that I know :
1)
July 13, 2022 at 9:00 pm
Shrinking datafile(s) might create serious performance ( fragmentation, index inverted, forwaded rows ). If this occurs then you will have to rebuild indexes, rebuild tables etc.
What is the risk...
July 9, 2022 at 4:32 pm
You can follow instructions from this link https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-2017
This procedure should work for 2016 as well
July 9, 2022 at 3:21 pm
You could start with this
alter user <usename> default_schema = <SchemaName>
grant control on schema::<SchemaName>
grant view definition to <username>
grant create table to <username>
grant create view to <username>
grant create default...
July 7, 2022 at 3:34 pm
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 8 posts - 1 through 8 (of 8 total)