ms-sql2000 db 접속 시 기본적으로 날리는 쿼리들

ms-sql2000 db 접속 시 기본적으로 날리는 쿼리들

Query Analyzer
Enterprise Manager

원격에서 위의 접속툴로 디비 접속 시 날리는 쿼리문들입니다. 즉, 단순히 접속만해도 디비  속에서는 저런 작업들이 이루어진다고 볼 수 있겠네요.




Query Analyzer



select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset'))
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
select @@spid
select @@spid
select IS_SRVROLEMEMBER ('sysadmin')
select IS_SRVROLEMEMBER ('sysadmin')
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset'))
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set
quoted_identifier off
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set
quoted_identifier off
select @@microsoftversion
select @@microsoftversion
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set
quoted_identifier off
select @@microsoftversion
select @@microsoftversion
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set
quoted_identifier off





 


Enterprise Manager



select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set quoted_identifier off
select ServerProperty(N'IsFulltextInstalled')
select ServerProperty(N'IsFulltextInstalled')
select platform()
select platform()
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
select @@microsoftversion
select @@microsoftversion
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set quoted_identifier off
select @@trancount
select @@trancount
select convert(int, serverproperty(N'isclustered'))
select platform()
select platform()
select convert(int, serverproperty(N'isclustered'))
select @@microsoftversion
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set quoted_identifier off
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set quoted_identifier off
select @@microsoftversion
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())
SELECT ISNULL(SUSER_SNAME(), SUSER_NAME())