SQL Server Snapshot Replication - Error on Publication

I have 2 databases sitting on the same 2008 R2 Sql Server and I am trying to replicate from one to another.  I have selected 2 tables and it is failing.  I keep getting: "Script failed for Table 'dbo.Agent Master'.

Can someone please help.  This seems like the simplest of tasks and I am not sure what I am doing wrong.

I attempted initially to use a domain user that have owner ship rights on both tables.  That created another error, so I went and used "Run under the SQL Server Agent server account", even though it is not recommended.  That got me to the above error.  The previous error was an authority issue.

Thanks in Advance, John
michdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

michdAuthor Commented:
Here is a troubleshooting snapshop...

C:\Users\user>"c:\Program Files\Microsoft SQL Server\100\COM\snapshot.exe" -P
ublisher [XXXX-YYYYY] -PublisherDB [DBName] -Distributor [XXXX-YYYYY] -Publ
ication [Test] -DistributorSecurityMode 1
2013-10-07 17:15:38.28
2013-10-07 17:15:38.28 Microsoft (R) SQL Server Snapshot Agent
2013-10-07 17:15:38.28 [Assembly Version = 10.0.0.0, File Version = 10.50.1600.1 ((KJ_RTM).100402-1539 )]
2013-10-07 17:15:38.28 Copyright (c) 2008 Microsoft Corporation.
2013-10-07 17:15:38.28 The timestamps prepended to the output lines are expressed in terms of UTC time.
2013-10-07 17:15:38.28 User-specified agent parameter values:
2013-10-07 17:15:38.28 --------------------------------------
2013-10-07 17:15:38.28 -Publisher XXXX-YYYYY
2013-10-07 17:15:38.28 -PublisherDB DBName
2013-10-07 17:15:38.28 -Publication Test
2013-10-07 17:15:38.28 -Distributor XXXX-YYYYY
2013-10-07 17:15:38.28 -DistributorSecurityMode 1
2013-10-07 17:15:38.28 --------------------------------------
2013-10-07 17:15:38.28 Connecting to Distributor 'XXXX-YYYYY'
2013-10-07 17:15:38.33 Parameter values obtained from agent profile:
2013-10-07 17:15:38.33 ---------------------------------------------
2013-10-07 17:15:38.33 -BcpBatchSize 100000
2013-10-07 17:15:38.33 -HistoryVerboseLevel 2
2013-10-07 17:15:38.33 -LoginTimeout 15
2013-10-07 17:15:38.33 -QueryTimeout 1800
2013-10-07 17:15:38.33 ---------------------------------------------
2013-10-07 17:15:38.34 Connecting to Publisher 'XXXX-YYYYY'
2013-10-07 17:15:38.35 Publisher database compatibility level is set to 90.
2013-10-07 17:15:38.35 Retrieving publication and article information from the publisher database 'XXXX-YYYYY.DBName'
2013-10-07 17:15:38.36 [0%] Locking published tables while generating the snapshot
2013-10-07 17:15:38.40 [0%] Bulk copying snapshot data for article 'Agent Master'
2013-10-07 17:15:38.40 [0%] Bulk copied snapshot data for article 'Agent Master' (78 rows).
2013-10-07 17:15:38.40 [21%] Bulk copying snapshot data for article 'AgentMaster'
2013-10-07 17:15:38.41 [21%] Bulk copied snapshot data for article 'AgentMaster' (94 rows).
2013-10-07 17:15:38.57 [46%] Sorting article objects in the proper creation order
2013-10-07 17:15:38.57 [46%] Customizing object for scripting based on article 'Agent Master'
2013-10-07 17:15:38.63 [46%] Customizing object for scripting based on article 'AgentMaster'
2013-10-07 17:15:38.76 [46%] Resolving duplicate object names among replicated objects
2013-10-07 17:15:38.76 [46%] Analyzing foreign key references among article objects in the publication
2013-10-07 17:15:38.76 [46%] Analyzing external references of all replicated check and default constraints
2013-10-07 17:15:38.76 [46%] Analyzing dependencies on non-article objects
2013-10-07 17:15:38.76 [46%] Generating schema scripts for article 'Agent Master'
2013-10-07 17:15:38.78 [46%] The replication agent had encountered an exception.
2013-10-07 17:15:38.78 Source: Unknown
2013-10-07 17:15:38.78 Exception Type: Microsoft.SqlServer.Management.Smo.FailedOperationException
2013-10-07 17:15:38.78 Exception Message: Script failed for Table 'dbo.Agent Master'.
2013-10-07 17:15:38.78 Message Code: Not Applicable
2013-10-07 17:15:38.78

C:\Users\user>
0
michdAuthor Commented:
I even tried it with a brand new empty file.  Fails.
0
David ToddSenior DBACommented:
Hi

table dbo.[agent master] appears to be the culprit. How about dropping that from the publication and concentrating on dbo.agentmaster.

I'm a bit suspicious of the apparent name clash between these two tables (and their publications) Strongly recommend to rename the table and publication to remove the space in the name. Suggest replacing it with an underscore.

Regards
  David
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

michdAuthor Commented:
Seems to happen for both tables.
0
michdAuthor Commented:
Feel free to cancel.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
michdAuthor Commented:
Issue was resolved internally.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.