Link to home
Start Free TrialLog in
Avatar of PeteEngineer
PeteEngineerFlag for India

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\ReplData\2011022133011641897"). 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.

ASKER CERTIFIED SOLUTION
Avatar of Rajeev
Rajeev
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial