Bulk Insert from File
Insert the content of files into a database table.
Copy Database Login User Account After Database Restore
Note: Run the following on the source server and run the output on the destination server. Run after database has been restored. Apply to restored databases from PROD backup. Apply to AlwaysOn databases.
Moving Large Number of Records between Databases Involved in AlwaysOn.
Moving data from Transaction database to Archive/Reporting database. After the records has been moved, delete the records to avoid duplicates. Note: If your database is involved in AlwaysOn or in Full Recovery mode, make sure you backup the database and log file to clear out the log files on the database before preceding. After you... » read more
Create New SQL Server Job Category
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
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