Manual failover without data loss Use this method when the primary replica is available, but you need to temporarily or permanently change which instance hosts the primary replica. To avoid potential data loss, before you issue the manual failover, ensure that the target secondary replica is up to date. To manually fail over without data... » read more
2 Server Setup Server Role Availability Mode Failover Mode Connections in Primary Role Readable Secondary Seeding Mode Session Timeout Endpoint URL DB01 Primary Synchronous commit Automatic Allow all connections No Manual 180 TCP://<servername>:5022 DB02 Secondary Synchronous commit Automatic Allow all connections No Manual 180 TCP://<servername>:5022 3 Server Setup Server Role Availability Mode Failover Mode Connections... » read more
If we want to provide view object definition rights to a specific user with the public role on all databases, execute the following query If we want to provide view object definition rights to a specific user with a public role on a specific database, execute the following query To grant View Definition rights to... » read more
Log inserts and deletes of a table to a log table.
Note: Need to enable email and setup mail profile first. Example 1 Example 2 uspConvertTableToHtml Stored Procedure Code that calls uspConvertTableToHtml Stored Procedure
SQL Server Integration Services provides certain fixed database-level roles to help secure access to packages that are stored in SQL Server. The available roles are different depending on whether you’re saving packages in the SSIS Catalog database (SSISDB) or in the msdb database. Roles in the SSIS Catalog database (SSISDB) The SSIS Catalog database (SSISDB)... » read more
SQL Server – Displaying line numbers in Query Editor – SSMS Step1: Go to Tools > Options. Step2: In the Options dialog box navigate to Text Editor > Transact-SQL > General. Step 3: Check “Line Numbers” and click on “OK” Now, when a query window is opened Line Numbers will be displayed.
Error: Getting the following error when trying to create linked servers (from an old script) on SQL Server 2019. The requested OLE DB provider SQLNCLI10.1 is not registered. Fix: In the linked server script, replace @provider=N’SQLNCLI10‘ with @provider=N’SQLNCLI‘
Error: While trying to setup a couple of SQL Enterprise servers in an Availability Group I kept getting the message “The local node is not part of quorum and is therefore unable to process this operation” Fix: I had done things in the wrong order. I had ticked “Enable AlwaysoOn Availability Groups” in SQL Server Configuration Manager... » read more