PeteEngineer
asked on
nsure that there is enough disk space available, and that the account under which the Snapshot Agent runs has permissions to write to the snapshot folder and its subdirectories.
Getting the following error when i execute the script :
IF ( SELECT OBJECT_ID('tableABC') ) IS NOT NULL
BEGIN
ALTER TABLE tableABC
ADD flag_column nchar NOT NULL DEFAULT 'n'
END
Its giving Msg 21331, Level 16, State 1, Procedure sp_MSreplcopyscriptfile, Line 49
Cannot copy user script file to the snapshot folder at the Distributor (copy "IF ( SELECT OBJECT_ID('tableABC') ) IS NOT NULL
BEGIN
ALTER TABLE tableABC
ADD flag_column nchar NOT NULL DEFAULT 'n'
END" "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplD ata\201102 2133011641 897"). Ensure that there is enough disk space available, and that the account under which the Snapshot Agent runs has permissions to write to the snapshot folder and its subdirectories.
Msg 3609, Level 16, State 2, Line 1
The transaction ended in the trigger. The batch has been aborted.
error for me.
IF ( SELECT OBJECT_ID('tableABC') ) IS NOT NULL
BEGIN
ALTER TABLE tableABC
ADD flag_column nchar NOT NULL DEFAULT 'n'
END
Its giving Msg 21331, Level 16, State 1, Procedure sp_MSreplcopyscriptfile, Line 49
Cannot copy user script file to the snapshot folder at the Distributor (copy "IF ( SELECT OBJECT_ID('tableABC') ) IS NOT NULL
BEGIN
ALTER TABLE tableABC
ADD flag_column nchar NOT NULL DEFAULT 'n'
END" "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ReplD
Msg 3609, Level 16, State 2, Line 1
The transaction ended in the trigger. The batch has been aborted.
error for me.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.