We really need your input in this questionnaire
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
IF ((SELECT uses_ansi_nulls FROM sys.tables WHERE object_id = object_id('netxms.event_log')) = 0)
BEGIN TRY
BEGIN TRANSACTION;
USE netxms_db;
/*Create new table with identical structure but option on*/
SET ANSI_NULLS ON;
SET ANSI_PADDING OFF;
CREATE TABLE netxms.event_log_new
(
event_id bigint not null,
event_code integer not null,
event_timestamp integer not null,
event_source integer not null,
event_severity integer not null,
event_message varchar(255) not null,
root_event_id bigint not null,
user_tag varchar(63) not null,
PRIMARY KEY(event_id)
) ;
CREATE INDEX idx_event_log_event_timestamp ON netxms.event_log_new(event_timestamp);
/*Metadata only switch*/
ALTER TABLE netxms.event_log SWITCH TO netxms.event_log_new;
DROP TABLE netxms.event_log;
EXECUTE sp_rename N'netxms.event_log_new', N'event_log','OBJECT';
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
IF XACT_STATE() <> 0
ROLLBACK TRANSACTION;
PRINT ERROR_MESSAGE();
END CATCH;
ELSE
PRINT 'ANSI_NULLS ALREADY ON'
Quote from: Akira on January 16, 2013, 07:42:53 AM
С базой теперь ОК.
Теперь при старте консоли
Cannot load MIB file from server: Bad MIB file data