Корректировка таблицы sysprocesses [MSSQL2000]
panov © (2004-09-15 15:59:00)
Возможно ли каким-либо образом корректировать системную
таблицу sysprocesses?
Установки параметра
allow updatesв 1 не помогает
(
EXEC sp_configure 'allow updates', '1'
RECONFIGURE WITH OVERRIDE
)
Нужно изменять поле
application_name.
panov (2004-09-15 16:03:00) [1]
Похоже, что все-таки нельзя...
SUMMARY
The sysprocesses table in SQL Server is a virtual table
containing information about active server process IDs (SPIDs). The
lastwaittype field is new in SQL Server 7.0 and is a string
representation of the waittype field (which is a reserved internal
binary column). It indicates the last or current waittype of a
SPID. If the waittype is 0x0000, the SPID is not currently waiting
on anything and the lastwaittype value indicates the last waittype
the SPID experienced. If the waittype is non-zero, the lastwaittype
and waittype will be equivalent and indicate the current waitstate
for the SPID.
Наверх 
ЧАТ |
Орешник |
|
