MS SQL Server Replication - Distribution Agent Error: Syntax error or access violation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Distribution Agent Error: Syntax error or access violation

Muhammad Shahzad Saleem

2006-12-13, 7:13 pm

I am getting this error in the distribution agent that I setup for
transactional replication. The last command which failed is like "CALL
sp_MSins_CompanyName
$Trans_ Sales Entry ("

The table name is lengthy and contains spaces too. I believe this is because
of the spaces in the stored procedure name which is causing the syntax
error.
The problem is, I cant rename the tables to ommit the spaces. Isnt there any
way to rename the stored procedures and relink them with the new name so
that the new renamed procedure should be called rather than system keep on
looking for the procedure with the original name?

If there any solution in SQL for this issue that would be great otherwise I
must have to do some workaround if possible.

Muhammad

Sponsored Links