[결론]DBCC CHECKIDENT('CHECKIDENT', RESEED, 초기값); -- 초기값은 현재 Identity 값의 최대값으로 설정한다.DBCC CHECKIDENT('CHECKIDENT', RESEED, 8); ---- LAB ----- use tdgo CREATE TABLE [dbo].[CHECKIDENT]( [ID] [int] NOT NULL PRIMARY KEY identity(1,1) , [FName] [nchar](10) NULL, [Lname] [nchar](10) NULL,)GO INSERT INTO DBO.CHECKIDENT SELECT 'KIM','SW'go 10 SELECT * FROM dbo.CHECKIDENT; DELETE FROM dbo.CHECKIDENT WHERE I..
SQL 2016으로 업그레이드 및 마이그레이션을 할 경우 현재 사용중인 SQL 버전에 따라 다르게 할 수 있다. 아래 문서를 참고하면 된다. Supported Version and Edition Upgradeshttps://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades 결론 : In-Place 업그레이드는 2008 SP4 이상 가능하고, 디비 이전은 2005도 가능하다.Upgrades from Earlier Versions to SQL Server 2016SQL Server 2016 supports upgrade from the following versions of SQL..
http://www.vsysad.com/2013/10/testing-smtp-server-from-the-command-line/ Method 1 – TelnetI am going to assume that your server is Windows Server 2008 R2, although these steps will work on Server 2003 also. Another assumption is that you have the telnet client installed. If you don’t have it installed follow the steps in this post and then follow these instructions:1. Fire up the command prompt ..
- Total
- Today
- Yesterday