Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 Лог изменений в Агенте в Sql Server  [new]
Wolfys
Member

Откуда:
Сообщений: 23
Добрые утро ! Уважаемые коллеги с sql.ru !
Подскажите пожалуйста существуют ли встроенные какие-нибудь логи по изменениям в Агенте Sql Server ??
Кто-то сделал изменения требуется определить кто.
За ранние Спасибо.
С уважением, Wolfys
27 июн 14, 09:32    [16227025]     Ответить | Цитировать Сообщить модератору
 Re: Лог изменений в Агенте в Sql Server  [new]
Wolfys
Member

Откуда:
Сообщений: 23
имеется ввиду кто-то изменил код задания. Ищу лог в котором я смогу узнать кто это изменение сделал.
27 июн 14, 09:50    [16227123]     Ответить | Цитировать Сообщить модератору
 Re: Лог изменений в Агенте в Sql Server  [new]
alexeyvg
Member

Откуда: Moscow
Сообщений: 31446
Wolfys
Подскажите пожалуйста существуют ли встроенные какие-нибудь логи по изменениям в Агенте Sql Server ??
Нет
27 июн 14, 10:32    [16227379]     Ответить | Цитировать Сообщить модератору
 Re: Лог изменений в Агенте в Sql Server  [new]
Владислав Колосов
Member

Откуда:
Сообщений: 7871
Пишите DDL триггер на MSDB.
27 июн 14, 11:50    [16228040]     Ответить | Цитировать Сообщить модератору
 Re: Лог изменений в Агенте в Sql Server  [new]
Wolfys
Member

Откуда:
Сообщений: 23
Помогите пожалуйста поправить триггер почему-то не получается...
+ триггер

USE [msdb]
GO
/****** Object: Trigger [dbo].[LogChangeData_ConstsBase_update] Script Date: 27.06.2014 17:54:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--
CREATE TRIGGER [dbo].[LogChangeData_sysjobsteps_update] ON [dbo].[sysjobsteps]
FOR UPDATE AS
BEGIN

declare @id uniqueidentifier, @login nvarchar(50), @context nvarchar(max)
set @context = CONVERT(nvarchar(max), CONTEXT_INFO())
select
@id =
case
when charindex('>', @context, 0) > 0 and charindex('<', @context, 0) > 0
and IsNumeric(substring(@context, charindex('<', @context, 0) + 1, charindex('>', @context, 0) - charindex('<', @context, 0) - 1)) = 1
then
substring(@context, charindex('<', @context, 0) + 1, charindex('>', @context, 0) - charindex('<', @context, 0) - 1)
else null end,
@login =
case
when charindex('>', @context, 0) > 0 and charindex('<', @context, 0) > 0
then
substring(@context, charindex('>', @context, 0) + 1, len(@context))
else null end
INSERT INTO [aydit].[dbo].[Jurnal_AgentSQL_jobsteps]
(
[idNode]
,[idRecord]
,[TableName]
,[FieldName]
,[OldValue]
,[NewValue]
,[ChangeDate]
,[OperationType]
,[AppName]
,[HostName]
,[UserName]
,[idPhysicalPerson]
,[CountChangeRecord])
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'job_id' AS FieldName,
CAST(d.[job_id] AS NVARCHAR(50)) AS OldValue,
CAST(i.[job_id] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[job_id] != d.[job_id]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'step_id' AS FieldName,
CAST(d.[step_id] AS NVARCHAR(50)) AS OldValue,
CAST(i.[step_id] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[step_id] != d.[step_id]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'step_name' AS FieldName,
CAST(d.[step_name] AS NVARCHAR(50)) AS OldValue,
CAST(i.[step_name] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[step_name] != d.[step_name]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'subsystem' AS FieldName,
CAST(d.[subsystem] AS NVARCHAR(50)) AS OldValue,
CAST(i.[subsystem] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[subsystem] != d.[subsystem]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'command' AS FieldName,
CAST(d.[command] AS NVARCHAR(50)) AS OldValue,
CAST(i.[command] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[command] != d.[command]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'flags' AS FieldName,
CAST(d.[flags] AS NVARCHAR(50)) AS OldValue,
CAST(i.[flags] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[flags] != d.[flags]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'additional_parameters' AS FieldName,
CAST(d.[additional_parameters] AS NVARCHAR(50)) AS OldValue,
CAST(i.[additional_parameters] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[additional_parameters] != d.[additional_parameters]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'cmdexec_success_code' AS FieldName,
CAST(d.[cmdexec_success_code] AS NVARCHAR(50)) AS OldValue,
CAST(i.[cmdexec_success_code] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[cmdexec_success_code] != d.[cmdexec_success_code]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'on_success_step_id' AS FieldName,
CAST(d.[on_success_step_id] AS NVARCHAR(50)) AS OldValue,
CAST(i.[on_success_step_id] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[on_success_step_id] != d.[on_success_step_id]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'on_fail_step_id' AS FieldName,
CAST(d.[on_fail_step_id] AS NVARCHAR(50)) AS OldValue,
CAST(i.[on_fail_step_id] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[on_fail_step_id] != d.[on_fail_step_id]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'server' AS FieldName,
CAST(d.[server] AS NVARCHAR(50)) AS OldValue,
CAST(i.[server] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[server] != d.[server]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'database_name' AS FieldName,
CAST(d.[database_name] AS NVARCHAR(50)) AS OldValue,
CAST(i.[database_name] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[database_name] != d.[database_name]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'TypePlan' AS FieldName,
CAST(d.[database_user_name] AS NVARCHAR(50)) AS OldValue,
CAST(i.[database_user_name] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[database_user_name] != d.[database_user_name]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'retry_attempts' AS FieldName,
CAST(d.[retry_attempts] AS NVARCHAR(50)) AS OldValue,
CAST(i.[retry_attempts] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[retry_attempts] != d.[retry_attempts]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'retry_interval' AS FieldName,
CAST(d.[retry_interval] AS NVARCHAR(50)) AS OldValue,
CAST(i.[retry_interval] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[retry_interval] != d.[retry_interval]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'os_run_priority' AS FieldName,
CAST(d.[os_run_priority] AS NVARCHAR(50)) AS OldValue,
CAST(i.[os_run_priority] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[os_run_priority] != d.[os_run_priority]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'output_file_name' AS FieldName,
CAST(d.[output_file_name] AS NVARCHAR(50)) AS OldValue,
CAST(i.[output_file_name] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[output_file_name] != d.[output_file_name]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'last_run_outcome' AS FieldName,
CAST(d.[last_run_outcome] AS NVARCHAR(50)) AS OldValue,
CAST(i.[last_run_outcome] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[last_run_outcome] != d.[last_run_outcome]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'last_run_duration' AS FieldName,
CAST(d.[last_run_duration] AS NVARCHAR(50)) AS OldValue,
CAST(i.[last_run_duration] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[last_run_duration] != d.[last_run_duration]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'last_run_retries' AS FieldName,
CAST(d.[last_run_retries] AS NVARCHAR(50)) AS OldValue,
CAST(i.[last_run_retries] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[last_run_retries] != d.[last_run_retries]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'last_run_date' AS FieldName,
CAST(d.[last_run_date] AS NVARCHAR(50)) AS OldValue,
CAST(i.[last_run_date] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[last_run_date] != d.[last_run_date]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'last_run_time' AS FieldName,
CAST(d.[last_run_time] AS NVARCHAR(50)) AS OldValue,
CAST(i.[last_run_time] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[last_run_time] != d.[last_run_time]
UNION ALL
SELECT
CASE d.[step_uid]
WHEN 0 THEN 1
ELSE d.[step_uid]
END AS NodeID,
d.[step_uid] AS idRecord,
'sysjobsteps' AS TableName,
'proxy_id' AS FieldName,
CAST(d.[proxy_id] AS NVARCHAR(50)) AS OldValue,
CAST(i.[proxy_id] AS NVARCHAR(50)) AS NewValue,
GETDATE() AS ChangeDate,
'U' AS OperationType,
LEFT(APP_NAME(), 50) AS AppName,
LEFT(HOST_NAME(), 50) AS HostName,
IsNull(@login,LEFT(SYSTEM_USER, 50)) AS UserName,
@id AS idPhysicalPerson,
1 AS CountChangeRecord
FROM deleted AS d
INNER JOIN inserted AS i ON i.[step_uid]=d.[step_uid]
WHERE i.[proxy_id] != d.[proxy_id]

END

+ таблица для учета


CREATE TABLE [dbo].[Jurnal_AgentSQL_jobsteps](
[idSequence] [nvarchar](36) NOT NULL,
[idNode] [smallint] NOT NULL,
[idRecord] [bigint] NOT NULL,
[TableName] [nvarchar](50) NOT NULL,
[FieldName] [nvarchar](50) NOT NULL,
[OldValue] [nvarchar](255) NULL,
[NewValue] [nvarchar](255) NULL,
[ChangeDate] [datetime] NOT NULL,
[OperationType] [nvarchar](50) NOT NULL,
[AppName] [nvarchar](50) NOT NULL,
[HostName] [nvarchar](50) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[CountChangeRecord] [bigint] NOT NULL,
[verstamp] [timestamp] NOT NULL,
[idPhysicalPerson] [bigint] NULL
) ON [PRIMARY]

GO
30 июн 14, 14:32    [16238736]     Ответить | Цитировать Сообщить модератору
 Re: Лог изменений в Агенте в Sql Server  [new]
Glory
Member

Откуда:
Сообщений: 104760
Если вы про ту ошибку выполнения, которую получаете, то она про
CASE d.[step_uid] WHEN 0 THEN 1 ELSE d.[step_uid] END AS NodeID,
30 июн 14, 15:25    [16239235]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить