Venugopal Saride

Amazon RDS SQL Server - Drop Database with Mirroring

Dropping database in RDS follows different method than dropping the database in local SQL Server. Below is the command to DROP the database in Amazon RDS EXECUTE msdb.dbo.rds_drop_database N'demodb' GO However when the SQL Server is configured with Multi-zone mirroring, then you need to set the partner to OFF and drop all active connections and […]

5 (1)

2020-01-17

119 reads

Blogs

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Reading a SharePoint List with Azure Logic App

By

Sometimes in life you have to do things you really don’t like to do....

T-SQL Tuesday #125 – Unit testing databases – we need to do this!!

By

Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

Read the latest Blogs

Forums

Common schema in different Databases

By lfernigrini

Hi, I need to include a very simple schema in all of my database...

Permissions to Run CLR Assembly

By hawg

This is my first time dealing with CLR assemblies and we have setup some...

Convert date value

By pwalter83

Hi, I have a requirement to convert a date value like '7th March 2020' ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers