Displaying posts published in

August 2014

Cannot insert explicit value for identity column in table ‘tablename’ when IDENTITY_INSERT is set to OFF

Error messages: Cannot insert explicit value for identity column in table ‘TableName’ when IDENTITY_INSERT is set to OFF. (Source: MSSQLServer, Error number: 544) Get help: http://help/544 Solution : You will get this type of error when you try to insert identity column in replication. You need to update column with not for replication. This option [...]

Backup and Restore FileGroup

Step1. Create a db with two file groups Step2. Create two tables, one on each FG Step3. Insert a row into each table Step4. Backup FG 1 Step5. Restore as a new DB Step6. One table should be accessible. Other should be down