Deletetion of an old Remote Server

I am trying to set up a publisher and I get an Error 18482: Could not
connect to server 'servername' because 'WEB1' is not defined as a remote
server. I went to the Remote Servers where WEB1' is listed, although this
server is no longer on our network. When I try to delete the listing, I get
the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to show
available servers. I do this and it is not listed of course. How do I
remove this server with a query?
Thank you.Do you mean linked server?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> I am trying to set up a publisher and I get an Error 18482: Could not
> connect to server 'servername' because 'WEB1' is not defined as a remote
> server. I went to the Remote Servers where WEB1' is listed, although this
> server is no longer on our network. When I try to delete the listing, I
get
> the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to
show
> available servers. I do this and it is not listed of course. How do I
> remove this server with a query?
> Thank you.|||No, it is listed under Remote Servers, not under Linked Servers.
"Jack Vamvas" wrote:
> Do you mean linked server?
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> > I am trying to set up a publisher and I get an Error 18482: Could not
> > connect to server 'servername' because 'WEB1' is not defined as a remote
> > server. I went to the Remote Servers where WEB1' is listed, although this
> > server is no longer on our network. When I try to delete the listing, I
> get
> > the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to
> show
> > available servers. I do this and it is not listed of course. How do I
> > remove this server with a query?
> >
> > Thank you.
>
>

Deletetion of an old Remote Server

I am trying to set up a publisher and I get an Error 18482: Could not
connect to server 'servername' because 'WEB1' is not defined as a remote
server. I went to the Remote Servers where WEB1' is listed, although this
server is no longer on our network. When I try to delete the listing, I get
the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to sho
w
available servers. I do this and it is not listed of course. How do I
remove this server with a query?
Thank you.Do you mean linked server?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> I am trying to set up a publisher and I get an Error 18482: Could not
> connect to server 'servername' because 'WEB1' is not defined as a remote
> server. I went to the Remote Servers where WEB1' is listed, although this
> server is no longer on our network. When I try to delete the listing, I
get
> the Error 15010: The server 'WEB1' does not exist. Use sp_helpserver to
show
> available servers. I do this and it is not listed of course. How do I
> remove this server with a query?
> Thank you.|||No, it is listed under Remote Servers, not under Linked Servers.
"Jack Vamvas" wrote:

> Do you mean linked server?
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:CFBDDA35-61A5-4CF0-9899-D15B8AC63D32@.microsoft.com...
> get
> show
>
>

Delete replication

I defined replication in my SQL Server 2000. I have deleted everything except
a remote server. I try to delete this and I get the following error:
Microsoft SQL_DMO (ODBC SQLState:42000) Error 15190: There are still remote
logins for the server "Name of the server".
Where can I find these remote logins? I had a look at the remote server and
I can not see any login.
Thanks
This is probably the distributor_admin account. I would not touch this
account even if you don't require replication anymore.
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
"Laura Pradre" <LauraPradre@.discussions.microsoft.com> wrote in message
news:0F20D434-1D9F-43C2-A53B-3710B6439C75@.microsoft.com...
>I defined replication in my SQL Server 2000. I have deleted everything
>except
> a remote server. I try to delete this and I get the following error:
> Microsoft SQL_DMO (ODBC SQLState:42000) Error 15190: There are still
> remote
> logins for the server "Name of the server".
> Where can I find these remote logins? I had a look at the remote server
> and
> I can not see any login.
> Thanks

Delete remote files !!! PLEASE HELP !!!

I wish to delete remote files on an FTP server after I download them. I want to download files daily and delete them daily after I finish downloading. I am trying to use the FTP task to do this but I get an error when it tries to delete files from specified location. It says:

"Unable to delete files using FTP Connection Manager" The FTP connection manager contains the FTP connection string and password. I have unchecked the passive mode box. Can someone help me with this error,

Thanks

Annie

Any help on this will be appreicated. I need to set up a task so that after I complete downloading the files each day, the existing file on the remote site is deleted.|||

i am also getting the same problem....i tried uncheck the passive mode at connection manager....it works

|||

-Annie

you will get this error when you have no write access permisiion on the files......so give the write permission at FTPsite....then it works fine

Delete remote files

I wish to delete remote files on an FTP server after I download them. I want to download files daily and delete them daily after I finish downloading. I am trying to use the FTP task to do this but I get an error when it tries to delete files from specified location. It says:

"Unable to delete files using FTP Connection Manager" The FTP connection manager contains the FTP connection string and password. I have unchecked the passive mode box. Can someone help me with this error,

Thanks

Annie

Any help on this will be appreicated. I need to set up a task so that after I complete downloading the files each day, the existing file on the remote site is deleted.|||

i am also getting the same problem....i tried uncheck the passive mode at connection manager....it works

|||

-Annie

you will get this error when you have no write access permisiion on the files......so give the write permission at FTPsite....then it works fine

Delete remote files

I wish to delete remote files on an FTP server after I download them. I want to download files daily and delete them daily after I finish downloading. I am trying to use the FTP task to do this but I get an error when it tries to delete files from specified location. It says:

"Unable to delete files using FTP Connection Manager" The FTP connection manager contains the FTP connection string and password. I have unchecked the passive mode box. Can someone help me with this error,

Thanks

Annie

Any help on this will be appreicated. I need to set up a task so that after I complete downloading the files each day, the existing file on the remote site is deleted.|||

i am also getting the same problem....i tried uncheck the passive mode at connection manager....it works

|||

-Annie

you will get this error when you have no write access permisiion on the files......so give the write permission at FTPsite....then it works fine

Delete records from subscriber only

I have on distributed enviornment in which data is collected by remote clients and send to the central publisher using merge publication and filters. I need to purge old data from the subsriber and not in the server. How do I do this?
Thanks
Anand,
what if some of the old data is modified on the publisher in future, or
perhaps this is not possible? If it is then you'll have a problem. You could
leave all the data as it is on the subscriber and use views to effectively
remove it for the front-end application. If you need the name to be the same
on the subscriber as the publisher, you could replicate to a different
tablename on the subscriber and use a view name equal to the tablename on
the publisher. Of course this would require reinitializing though. Finally,
you could drop the subscription, add a filter then reinitialize.
HTH,
Paul Ibison
|||The data at the server won't change for those records, if it did and it is replicated to the subscriber occasionaly it won't be a problem. I was trying to find out whether there is a way not to replicate deletes in merge publication (Easily) without dropi
ing the subscription.
Thanks for input
Anand
|||Anand,
there is another solution - you could modify the merge replication triggers
so as to not register your deletes in MSmerge_tombstone, although this would
lead to an unsupported solution.
HTH,
Paul Ibison
|||the cleanest way to do this is using transactional replication with custom
stored procedures. Do you require tranasactions that require on the
subscriber to be replicated to the publisher?
"Anand" <anonymous@.discussions.microsoft.com> wrote in message
news:4FB33D2F-1310-4125-86A0-21EDB56E6388@.microsoft.com...
> I have on distributed enviornment in which data is collected by remote
clients and send to the central publisher using merge publication and
filters. I need to purge old data from the subsriber and not in the server.
How do I do this?
> Thanks
|||Yes. I have already setup a merge replication with 30 odd disconnected clients replicating to a central server. Most of the transactions actually happen at the clients. It is not possible for me change the replication model now. Is there a way to script a
nd tell the clients not to replicate deletes to the publisher.
Anand
|||Can we use alter table to disable all triggers on a table and delete the records and enable triggers. Will this work?
Thanks
Anand
|||Well I tried disabling the triggers, but you can not alter the tables which are replicated. I stoped the SQL server agent and deleted the msmerge_tombstone records after the delete on the subscriber and restarted the SQL server agent. It seems to work the
way I want it. Any caveats?
Thanks
Anand