To create a job category In Object Explorer, click the plus sign to expand the server where you want to create a job category. Click the plus sign to expand SQL Server Agent. Right-click the Jobs folder and select Manage Job Categories. In the Manage Job Categoriesserver_name dialog box, click Add.
NOT FOR REPLICATION indicates that when a record is replicated to this table, any value that is inserted into the identity column via the replication agent keeps it’s original value from the source system, but any records added locally still increment the identity value. All about “Not for Replication” “Not for Replication” is a property... » read more
Specifies whether SQL Server automatically rolls back the current transaction when a Transact-SQL statement raises a run-time error. The THROW statement honors SET XACT_ABORT. RAISERROR does not. New applications should use THROW instead of RAISERROR. When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled... » read more
Transactions are intended to run completely or not at all. The only way to complete a transaction is to commit, any other way will result in a rollback. Therefore, if you begin and then not commit, it will be rolled back on connection close (as the transaction was broken off without marking as complete). As... » read more
Drop existing FK constraint and create a new constraint. In the new constraint, use a function check. Function Constraint
PROD DB -> Localhost DB -> DEV DB Create database on Localhost On Localhost, create Linked Server to PROD DB Copy data from PROD DB to Localhost DB Once the data is in Localhost, create a SQL backup of the Localhost database Copy the backup file to DEV DB and restore the database to DEV... » read more
Note: By default XP_CMDSHELL is turned off, to enable XP_CMDSHELL run the following on the database server…
Sources: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-ver15
Are you trying to connect to a SQL Server instance and ending up with the error: The certificate chain was issued by an authority that is not trusted You aren’t alone. SQL Server 2005 introduced authentication encryption (by default) in the SQL Native Access Client (SNAC). SQL Server will self-generate a certificate that’s then used... » read more