Viewing 15 posts - 1 through 15 (of 48 total)
Hi Johan.
Thanks a lot for the prompt response.
I will try to tweak it to match the requirement of taking a list of server names as a parameter(~100) & check if...
July 27, 2023 at 7:47 am
From msdn :
Any user can create temporary objects in tempdb. Users can access only their own objects, unless they receive additional permissions. It's possible to revoke the connect permission to tempdb to prevent...
July 26, 2023 at 5:04 am
Are you looking for the Database Diagram mentioned in the below article?
https://www.mssqltips.com/sqlservertip/6269/sql-server-database-diagram-tool-in-management-studio/
August 10, 2021 at 10:49 am
Please have a look : https://www.ryanjadams.com/2017/06/sync-sql-logins/
March 16, 2021 at 6:47 pm
Thanks Steve.I will test this. How about the logins & permissions? I couldn't use sp_help_revlogin to extract logins with the same password on RDS
February 18, 2021 at 6:18 pm
Have you checked the status of the Cluster service & Quoram? It looks like you may have to force quorum to bring WSFC online on the node which is up.
February 16, 2021 at 5:49 pm
Any suggestions?
May 2, 2019 at 10:40 am
Thanks.So we cannot overwrite a DB which already exists in target with same name?
April 30, 2019 at 1:49 pm
New version of DMA can migrate on-premises SQL Server instance to a modern SQL Server instance hosted on-premises or on an Azure Virtual Machine. DMA can be called from cmd...
April 29, 2019 at 4:49 pm
It works with all HA/DR solutions including AlwaysOn. Log blocks are not copied to secondary replicas until it is flushed on primary replica(even in synchronous configuration).So there is a risk...
July 20, 2018 at 8:19 am
Jobs which are running during the server/service restart will be cancelled and won't start automatically.Hope below link helps :
https://www.codeproject.com/Tips/797252/Restart-a-SQL-server-scheduled-job-if-hanged
July 20, 2018 at 7:45 am
Please have a look at the Migration checklist. Hope this helps
https://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/
November 1, 2017 at 7:56 am
Are you using latest version of management tools? Can you provide screenshot?
October 31, 2017 at 10:53 am
Trying to push just ssms on user Desktops. Don't want to install performance or configuration tools, as it is not needed on the client computer
October 31, 2017 at 6:49 am
From SSMS , I am able to add a new connection(under Manage Connection),but unable to Remove existing connection to old server. Hope this limitation will be there in BIDS also. Will try...
July 10, 2017 at 8:17 am
Viewing 15 posts - 1 through 15 (of 48 total)