Do I need to delete sp_replincrementlsn?

Hi,
maybe someone have suffered this before.
I'm able to make in the server a publication (W2K ADV. with SQL Server 2000
Standar and SP2). I can't upgrade the SP4 now.
Then I'm trying to make in my computer a suscription (WXP with SQL Server
developer and SP4) .
The error is the "14053: Can't load the DLL replincrementlsn, etc." when I
search the stored procedure sp_replincrementlsn I can find it in the master
database in the stored procedures (not in extended stored procedures) so if
I try to register the xprepl.dll I can't because the procedure already
exists.
What can I do? Can I delete a stored procedure of the master database? How?
Thank's in advance!!!
Un saludo,
Enrique Barcel
I think you need to reapply the current sp. Have you tried a reboot? I have
run into resource problems like this that were solved on reboot.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Enrique Barcel" <ebarceloSINSPAM@.EnerWeb.es> wrote in message
news:%23cpZLPyeFHA.1400@.TK2MSFTNGP15.phx.gbl...
> Hi,
> maybe someone have suffered this before.
> I'm able to make in the server a publication (W2K ADV. with SQL Server
> 2000
> Standar and SP2). I can't upgrade the SP4 now.
> Then I'm trying to make in my computer a suscription (WXP with SQL Server
> developer and SP4) .
> The error is the "14053: Can't load the DLL replincrementlsn, etc." when I
> search the stored procedure sp_replincrementlsn I can find it in the
> master
> database in the stored procedures (not in extended stored procedures) so
> if
> I try to register the xprepl.dll I can't because the procedure already
> exists.
> What can I do? Can I delete a stored procedure of the master database?
> How?
> Thank's in advance!!!
> Un saludo,
> Enrique Barcel
>
>
sql

Do a lot of linked tables cause block?

Hello, everyone:
There are a lot of Access and Excel tables linked to my SQL Server (SQL2K SP3 on W2K). The end users update those likned tables. I am wondering if there is the block problem. If yes, how to prevent that? Thanks.
ZYTNo, It should not cause any problems. How did you bring it into sql2k

DMZ Web Server and Internal SQL Server

I have a .net web application that is running on a w2k server located in our
DMZ it has a private address. The SQL server is also running on a w2k server
but it is located in our private network. I have opened port 1433 on the
firewall from the DMZ to Lan and from Lan to DMZ. Since neither server knows
the other excist I have added an entry in the local host file of the
webserver in the DMZ that points to the internal SQL server. Does an entry
also need to be placed in the host file of the SQL server? Also what would
be the proper connection string in the web.config to link these two servers
together? And would anything need to be done on the SQL server?
Thanks
You may need to specify the IP address of the firewall and 1433 to allow
the connection to succeed, since the client won't know how to resolve the
netbios or host name of the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
sql

DMZ Web Server and Internal SQL Server

I have a .net web application that is running on a w2k server located in our
DMZ it has a private address. The SQL server is also running on a w2k server
but it is located in our private network. I have opened port 1433 on the
firewall from the DMZ to Lan and from Lan to DMZ. Since neither server knows
the other excist I have added an entry in the local host file of the
webserver in the DMZ that points to the internal SQL server. Does an entry
also need to be placed in the host file of the SQL server? Also what would
be the proper connection string in the web.config to link these two servers
together? And would anything need to be done on the SQL server?
ThanksYou may need to specify the IP address of the firewall and 1433 to allow
the connection to succeed, since the client won't know how to resolve the
netbios or host name of the server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.