DBILITY

set FOREIGN_KEY_CHECKS = 0;truncate table [table_name];set FOREIGN_KEY_CHECKS = 1;

USE MASTERGOCREATE DATABASE [DB명]GOCREATE LOGIN [LOGIN명] WITH PASSWORD='비밀번호'GOALTER LOGIN [LOGIN명] EnableGOUSE [DB명]GOCREATE USER [USER명] FOR LOGIN [LOGIN명] WITH DEFAULT_SCHEMA = dboGOEXEC sp_addrolemember db_owner, [USER명]GO--GRANT ALL TO [USER명]--GO기억은 못하겠고 적어 두자.

DELETE FROM T_SU_POLL_REQUEST_ITEMDELETE FROM T_SU_POLL_REQUESTDBCC CHECKIDENT (T_SU_POLL_REQUEST_ITEM, RESEED, 0)DBCC CHECKIDENT (T_SU_POLL_REQUEST, RESEED, 0)FK가 존재하는 경우 TRUNCATE이 되지 않는다.모두 삭제 후 IDENTITY의 시작 값을 0으로 RESET하면 된다.

SELECT T1.[NAME] AS USER_NM , T3.[NAME] AS OBJECT_NM , T3.[TYPE_DESC] , T2.[PERMISSION_NAME] , T2.STATE_DESCFROM sys.DATABASE_PRINCIPALS AS T1 WITH (NOLOCK) INNER JOIN sys.DATABASE_PERMISSIONS AS T2 WITH (NOLOCK) ON T2.GRANTEE_PRINCIPAL_ID = T1.PRINCIPAL_ID INNER JOIN sys.OBJECTS AS T3 WITH (NOLOCK) ON T3.[OBJECT_ID] = T2.MAJO..

sa만 접속이 된다. 사용자계정으론 안된다.