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.googlegroups.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

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

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.googlegroups.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

Problem replicating from Std Edition to Developer Edition

Trying to replicate,

from: Win 2K Server, SQL Std Edition 8.00.818 SP3
to: Win XP Pro, SQL Developer Edition 8.00.2039 SP4

XP has Firewall 'Off', and I added sqlservr.exe and port 1433 to the exceptions list.

Subscription on Win 2K Server gets error that it cannot connect to the subscriber system: SQL Server does not exist or access denied.

Ping from the Win2K to the WinXP box works fine.

The WinXP SQL login works when I connect from my desktop to the XP box using both SQL Ent Mgr and Query Analyzer.

Any ideas?

Looking at the merge agent properties, how does it connect to the publisher, sql login or windows login? If sql login, see if the login has access, and if the password is set correctly. If windows login, it's using the credentials that started the sql server agent service. Find out what login starts the sql server agent service and see if it has access to your publisher machine.