Monday, March 26, 2012

Problem replicating with mssql server 2000

Hi, i have been trying to replicate one of my server i have created the
ditributor and published the data base. I also have pushed a
subscription but when it is creating the snapshot i get this error:
Invalid object Name dbo.fn_dlxGet_fmt
But in the articles that i'm publishing there is no dbo.fn_dlxGet_fmt.
And the Agent give this error:
Cannot use DROP VIEW on DLXTABLE Because DLXTable is a table, and i not
publishing any views.
I'm using transactional replication, and i'm letting the replication
process to create the snapshot on the client, i have not created any
table, view or functions. In the replication client.
Darth,
Could the function be used in a constraint definition in one of your tables?
HTH
Jerry
"darth timeus" <darth.timeus@.gmail.com> wrote in message
news:1129142934.774404.87880@.g44g2000cwa.googlegro ups.com...
> Hi, i have been trying to replicate one of my server i have created the
> ditributor and published the data base. I also have pushed a
> subscription but when it is creating the snapshot i get this error:
> Invalid object Name dbo.fn_dlxGet_fmt
> But in the articles that i'm publishing there is no dbo.fn_dlxGet_fmt.
> And the Agent give this error:
> Cannot use DROP VIEW on DLXTABLE Because DLXTable is a table, and i not
> publishing any views.
> I'm using transactional replication, and i'm letting the replication
> process to create the snapshot on the client, i have not created any
> table, view or functions. In the replication client.
>
|||The table DLXVOIPUSER, uses this function as a formula:
([dbo].[fn_dlxGet_dtmf]([dlxlast_name]))
what can i do i'm a newbie in this.
Jesus
sql

No comments:

Post a Comment