Deploying SSIS Packages from SSMS
There are 2 ways to deploy SSIS packages. #1 Directly from Visual Studio #2 From SQL Server Management Studio SQL Server Management Studio Create specific folders under SSISDB. To deploy a project deployment file that you created by building a project in the development environment, select Project deployment file and enter the path to the .ispac... » read more
Database Clustering, Mirroring, Log Shipping, and Replication for SQL Server 2008
Prior to SQL Server 2012 Availability Group, SQL Server 2008 uses Mirroring and Log Shipping. Database Mirroring Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. A copy of the database is created... » read more
SSMS Registered Servers Window
Registering a server in SQL Server Management Studio allows you to store the server connection information for future connections.There are three ways to register a server in SQL Server Management Studio. Local instances of SQL Server are automatically registered during the first launch of Management Studio after its installation. You can also initiate the automatic... » read more
Determine Active Node in SQL Failover Cluster
Displays the active server node: Whether the server is clustered:
Database Cluster
Microsoft Windows Failover Clustering is a high-availability option designed to increase the uptime of SQL Server instances. A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and the other is a passive... » read more
Set IDENTITY_INSERT On and Off
Cannot insert explicit value for identity column in table ‘sometableWithIdentity’ when IDENTITY_INSERT is set to OFF
Sql Grant Permission
Grants permissions on a table, view, table-valued function, stored procedure, extended stored procedure, scalar function, aggregate function, service queue, or synonym. Syntax Object permission Implied by object permission Implied by schema permission ALTER CONTROL ALTER CONTROL CONTROL CONTROL DELETE CONTROL DELETE EXECUTE CONTROL EXECUTE INSERT CONTROL INSERT RECEIVE CONTROL CONTROL REFERENCES CONTROL REFERENCES SELECT RECEIVE... » read more
SQL Server Compatibility Level
Sets Transact-SQL and query processing behaviors to be compatible with the specified version of the SQL Server Database Engine. Product Database Engine Version Default Compatibility Level Designation Supported Compatibility Level Values SQL Server 2019 preview 15 150 150, 140, 130, 120, 110, 100 SQL Server 2017 (14.x) 14 140 140, 130, 120, 110, 100 Azure... » read more