Hi there,

i have had a request from a developer...here it is:

'I am working on a project that will involve the transfer of data to and fro a Remote Server (Windows 2000), that runs SQLSERVER. For me to login to this server I am able to do it via the 'Remote Desktop Connection' on my XP Machine.

What I would really like to do is setup within 'Enterprise manager' of this remote server a new Registration/Server Group' with 'OFSSQL ITS as the database' as so I can create an overnight run to run various 'SP's' to do the various data transfers.

The big question is CAN WE DO THIS. Is there some way of setting this up given we know the variious IP address etc etc. '

has anyone got any ideas of how this can be done?? i can only seem to register a server if I have the actual server name (we have the IP address). i've never used linked servers before and not sure if that would be able to do it either...

any help is well appreciated!

Meg



**********************************************************************
We cannot accept any liability for any loss or damage
sustained as a result of software viruses. It is your
responsibility to carry out such virus checking as is necessary before opening any attachment to
this message.

The information in this email and any files transmitted with
it may be of a confidential nature and is intended solely for
the addressees. If you are not the intended addressee, any
disclosure, copying or distribution by you is prohibited and
may be unlawful.

www.ofsted.gov.uk
**********************************************************************

MS Sql Server LazyDBA home page