How to reseed SQL Server identity coloumn
dbcc checkident ('TableName', reseed, 100)
Office 365 service comparison
http://technet.microsoft.com/en-us/office/dn788955
Popular posts from this blog
Error while joining a domain network: "The specified network name is no longer available"
You may experience the following error message when joining a domain network: "The specified network name is no longer available" One of the possible reason is the the NETLOGON service is not turned on. You may follow the steps: Start > Run Type services.msc , hit Enter key Start NETLOGON service and make sure to set it to Start Automatically Restart your computer and try again
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)'
Comments