SQL: Insert custom value into IDENTITY column 

SET IDENTITY_INSERT clienttable ON

insert into EmployeeTable ...

SET IDENTITY_INSERT clienttable OFF

Comments

Post a Comment

Popular posts from this blog

Error 401.1 "Unauthorized: Access is denied due to invalid credentials"

Have developed a ASP.NET application, in which it will call a web service from another web application but within the same IIS server. Everything is fine until putting those into production server. The web service requires Windows authentication.  Error 401.1 "Unauthorized: Access is denied due to invalid credentials" occur even we pass the correct user name, password.  We ensure the account is not locked. After Googling, we found that it happens on Windows 2003 Server SP1, IIS6 with integrated authentication enabled. http://support.microsoft.com/kb/896861 Above KB describe the solution about the loopback issue, I am not repeating there.  The most important thing is it happens to some host name only, not all. After we do some testing, we find that if the host name is CNAME in our DNS, it works.  But if we set to A (IP address), then no luck. Example: name1.mydomain.com -> WEBSERVER01.LOCAL (CNAME) name2.mydomain.com -> 192.168...
Read more

SQL Server 2005: MUST_CHANGE is ON

I have created a SQL user, but it force me to change to password. I go to the SQL Server Management Studio and untick the Enforce password policy. However it prompt the following message: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON (Microsoft SQL Server, Error: 15128) A SQL query can solve the problem ALTER LOGIN (Username here) WITH PASSWORD = '(Password here)'
Read more