Archive for the 'mssql' Category

26 Dec 2019

mssql – custom start value for identity column

20:55 | mssql | 17 views

You can give an initial value for the identity column when you are creating the new table. If you want an identity column which one is starts from zero If the table already created you can override the identity column startValue with the following command: where the tableName is the target table name startValue is […]

23 Nov 2014

missing tempdb.dbo.ASPStateTempApplications table

13:23 | mssql | 550 views

Goal: to solve the missing tempdb.dbo.ASPStateTempApplications table problem Just recreate this temp object with the following code snippet:

#sidebar a { color:#fff; } #sidebar ul ul li { color: #DEF585; } #sidebar h2 { color: #fff; } #sidebar ul p, #sidebar ul select { color: #BEDDBE; } #backfly { background: url(images/golfBallWallPaper.jpg) left bottom fixed repeat-x #65a51d; }