|
|
| Definitions More Info. | | Definition ID | 591 | | Title | SQL | | Category | NOTES | | Definition | Maintanence icin sp_who2 sonucunu tabloya yazdirma | | Definition Description | create table spWhoStatistics ( [spWhoStatisticsID] int not null identity, [SPID] varchar(10), [Status] varchar(100), [Login] varchar(50), [HostName] varchar(100), [BlkBy] varchar(10), [DBName] varchar(100), [Command]varchar(255), [CPUTime]varchar(10), [DiskIO]varchar(10), [LastBatch] varchar(20), [ProgramName] varchar(200), [SPID2] varchar(10), [REQUESTID] varchar(10), [RecordDate] datetime constraint RecordDate_DF default (getdate()) )
insert into spWhoStatistics (SPID, Status, Login, HostName, BlkBy, DBName, Command, CPUTime, DiskIO, LastBatch, ProgramName,SPID2,REQUESTID)
exec sp_who2
select * from dbo.spWhoStatistics | | RecordBy | cunay | | Record Date | 13-10-2014 16:57:29 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|