DEFINITIONS

Definitions More Info.
Definition ID256
TitleSQL
CategorySCRIPT
DefinitionCHECKDB den user bilgileri cekme sorgusu
Definition Description--Bu sorgu CHECKDB den kimlerin hangi serverdan geldigini gosteren sorgu /****** Script for SelectTopNRows command from SSMS ******/ SELECT DISTINCT TOP 1000 [LogDate] ,[DBname] ,[host_name] ,[login_name] ,[client_net_address] ,[login_time] ,[connect_time] ,[text] ,[program_name] ,[status] ,[last_read] ,[last_write] FROM [CHECKDB].[dbo].[userlogs] --WHERE TEXT LIKE '%905364903942%' GROUP BY LogDate ,[DBname] ,[host_name] ,[login_name] ,[client_net_address] ,[login_time] ,[connect_time] ,[text] ,[program_name] ,[status] ,[last_read] ,[last_write] Order by LogDate Desc
RecordBycunay
Record Date28-09-2012 11:36:21
Düzenle
Kopyala
Sil