|
SQL ERRORS |
| Top 4 Resources | |
| Resource | |
| Resource | |
| Resource | |
| Resource | |
| Quick Reference | |
| Errors | |
| Cannot insert explicit value for
identity column IDENTITY_INSERT is set to off
|
Add one line
of code to your sql statement.
Alter Procedure spCONVERT_Assets @EquipmentID as integer, @AssetID NVARChar(15) as SET IDENTITY_INSERT tblAssets ON INSERT INTO tblAssets (EquipmentID, AssetID) VALUES (@EquipmentID, @AssetID) |
| Intermittent SQL Server does not exist or access denied. | Yes
the connection profile is your main suspect!!! However there is a lot of
coverage of this on the internet. But there is very little detail paid
to the Microsoft Visual Studio .NET 2003 .If you are using an web.config
file we may have your answer for you. This file can become corrupted.
Make sure you have a cleanly generated one that works on a local host and then update the one on your web. I spent many hours hunting down this problem. It is not the predominant answer to this error. However, it can apply and be very frustrating and hard to pin point. A good indicator is the fact you can access the db from local host and not from the web! |
| Server does not exist or access denied. | |