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
Disable All Jobs Script
Generate a script to disable all active jobs on server. Returns all jobs that are not idle or suspended.
SQL Server Type: money vs smallmoney
Data type Range Storage money -922,337,203,685,477.5808 to 922,337,203,685,477.5807 (-922,337,203,685,477.58to 922,337,203,685,477.58 for Informatica. Informatica only supports two decimals, not four.) 8 bytes smallmoney – 214,748.3648 to 214,748.3647 4 bytes The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent. For Informatica, the money and smallmoney data types are accurate to a one-hundredth of the monetary units... » read more
Adding Error Handling and Transaction to Stored Procedure
Error Handling Error Handling with Transaction
Passing Table Type to Stored Procedure
User-Defined Table Types Stored Procedure Code Note: Need to make sure the type type has the right access permissions.