Snapshot Replication of MOM database

When configuring snapshot replication of the OnePoint database used by MOM i am having the following error being reported in SQL Replication Monitor:

Command attempted:

CREATE TABLE "dbo"."Computer"(
"idComputer" "uniqueidentifier" ROWGUIDCOL NOT NULL,
"Name" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
"Description" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"CustomData1" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"CustomData2" "nvarchar"(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"Domain" "nvarchar"(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
"DNSName" "nvarchar"(512) COLLATE SQL_Latin1_General_CP1
(Transaction sequence number: 0x000004670002E32300BF00000002, Command ID: 375)

Error messages:

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_ComputerHeartbeat", or the name is ambiguous. (Source: MSSQLServer, Error number: 4121)
Get help: http://help/4121

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_ComputerHeartbeat", or the name is ambiguous. (Source: MSSQLServer, Error number: 4121)
Get help: http://help/4121

Unfortunately I can't find much help with this error.

Any suggestions?

[1578 byte] By [MichaelBolland] at [2007-12-22]
# 1

For the first error:

CREATE TABLE "dbo"."Computer"(

You have double quotes around 'dbo' and 'computer' which makes the object dbo.computer be seen as two literal words with a period in between.

Loose the quotes and try... ( I now see that it′s the same with columns and datatypes..)

CREATE TABLE dbo.Computer (
idComputer uniqueidentifier ROWGUIDCOL NOT NULL, etc...

/Kenneth

KeWin at 2007-8-30 > top of Msdn Tech,SQL Server,Getting started with SQL Server...
# 2

Thanks KeWin, that's rather strange as it was a query generated by the management studio! I'll give it a go now.

Thanks again

Mike

MichaelBolland at 2007-8-30 > top of Msdn Tech,SQL Server,Getting started with SQL Server...

SQL Server

Site Classified