I was moving some files around today and ran into this confusing issue. I had moved a Sitecore instance to a new folder but originally left the database in it’s old location, so I went and detached them in SQL Server Management Studio (SSMS) and then moved the files from on folder to another. After […]
Tag: sql server
Cannot insert explicit value for identity column in table ‘table_name’ when IDENTITY_INSERT is set to OFF.
I was creating some new tables and populating them when I ran into this not so straight forward error: I was confused at first, I had set the primary key to auto increment using the IDENTITY property yet it was throwing an error. I scratched my head for a few minutes before noticing my not […]
I ran into an issue while working on the road one day. Normally, whether I am working in the office or at home, I have a second monitor hooked up to my laptop. This can sometimes pose an issue when you switch to a single monitor as some windows or dialogs will not recognize that […]