MS-SQL 테이블 조회

테이블 명이 tbl_로 시작하면...

SELECT distinct(table_name ) FROM INFORMATION_SCHEMA.COLUMNSwhere table_name like 'tbl_%'

MS-SQL 접근 IP조회

select c.client_net_address
,c.local_net_address , A.hostname, A.loginame, B.name, A.program_name
from master..sysprocesses A
, sys.databases B
, sys.dm_exec_connections c
where A.dbid = B.database_id
and
A.sql_handle = c.most_recent_sql_handle
and client_net_address not in('')
group by c.client_net_address
,c.local_net_address , A.hostname, A.loginame, B.name, A.program_name

tempdb 초기화

backup log tempDB with no_log
DBCC SHRINKDATABASE(N'tempdb' )

다른 디렉토리로 변경
http://www.dator.co.kr/?document_srl=65617&tags=Database