Main stream support for SQL 2000 ended April 2008. Extended support, which can be very expensive, is until 2013.

http://msdn.microsoft.com/en-us/library/ms144245(SQL.90).aspx

Yes you can view the data, if you have the appropriate access.

We have only one local drive i.e C drive and the rest are shared drives. So if we have any other local drive other than C drive, we can select...

try this code...

select * from openquery

(ADSI,'SELECT cn, mail, co, distinguishedName, displayName

FROM ''LDAP://mydomain''

where objectClass = ''User'' '

)

replaced the " (double quotes) with two ' (single quotes) and of course substitute with...

I've used robocopy in the past and its worked for, though from...

This is good reference material

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

I would base a solution on the type of data (confidentiality) that's being delivered and how it is going to be consumed.

Sending database backups or reports when the company needs...

See if this helps you

http://msdn.microsoft.com/en-us/library/aa337361.aspx

Even though syscomments is available, it is not recommended to use it since it is there for backward compatibility only and will be removed from a future version.

In fact you...

You should be able to backup locally and then use xcopy or robocopy in a batch script to move the database backup over to the external device.

There maybe third party tools which may allow you to do that, but SQL Server doesn't let you directly restore an Oracle database back up.

You could restore the database on...

Have you tried from a different machine? It could be something on your machine. Since you tried ODBC and it worked I don't believe it would be a DNS issue,...

Yes

Possibly

The next question should be "Is it recommended?"

No

Copy this pipe | for your queries :hehe:

Please be a little more clear on what you're looking for.