Set IDENTITY_INSERT ON is not working

by

You might be just missing the column list, as the message says

SET IDENTITY_INSERT [MyDB].[dbo].[Equipment] ON

INSERT INTO [MyDB].[dbo].[Equipment]
            (COL1,
             COL2)
SELECT COL1,
       COL2
FROM   [MyDBQA].[dbo].[Equipment]

SET IDENTITY_INSERT [MyDB].[dbo].[Equipment] OFF

Related Contents:

  1. How to check if a column exists in a SQL Server table
  2. How to set a default value for an existing column
  3. How do I find a stored procedure containing ?
  4. How do I move a table into a schema in T-SQL
  5. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  6. How to wait for 2 seconds?
  7. Alter column, add default constraint
  8. INSERT INTO vs SELECT INTO
  9. SQL Server: Maximum character length of object names
  10. Generate MD5 hash string with T-SQL
  11. Using RegEx in SQL Server
  12. How do I use the CONCAT function in SQL Server 2008 R2?
  13. Current executing procedure name
  14. Confused about UPDLOCK, HOLDLOCK
  15. Get first day of week in SQL Server
  16. Listing information about all database files in SQL Server
  17. MS SQL compare dates?
  18. TSQL: How to convert local time to UTC? (SQL Server 2008)
  19. Understanding PIVOT function in T-SQL
  20. Comma separated results in SQL
  21. SQL Server 2008 Empty String vs. Space
  22. Can you explain the use of sys.sp_addextendedproperty in the following code?
  23. SQL Server: combining multiple rows into one row
  24. Pros & Cons of TRUNCATE vs DELETE FROM
  25. Compare dates using SQL Server
  26. T-SQL How to grant role to user
  27. SQL Server: check whether a Trigger is Enabled or Disabled?
  28. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  29. Elegant way to delete rows which are not referenced by other table
  30. Counting no of rows returned by a select query
  31. Get size of all tables in database
  32. How can I remove duplicate rows?
  33. Check if a row exists, otherwise insert
  34. SQL Server Regular expressions in T-SQL
  35. What is the Oracle equivalent of SQL Server’s IsNull() function?
  36. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  37. Multiple INSERT statements vs. single INSERT with multiple VALUES
  38. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  39. What is the maximum number of characters that nvarchar(MAX) will hold?
  40. Simple DateTime sql query
  41. Microsoft SQL Server Management Studio 2008 deleting multiple user tables
  42. Determine SQL Server Database Size
  43. How to add a new schema to sql server 2008?
  44. Convert varchar into datetime in SQL Server
  45. Using IF ELSE statement based on Count to execute different Insert statements
  46. Remote Procedure call failed with sql server 2008 R2
  47. What do these Copy Only Backup options mean?
  48. Is there an “IF EXISTS” test for a linked server?
  49. SQL Server, How to set auto increment after creating a table without data loss?
  50. An attempt to login using SQL authentication failed

Leave a Comment