Hi

Try using native Oracle OLEDB provider.

We had the same problem here and tried many solution like Microsoft driver and ado connections.

The best way was use the native oracle OLEDB provider.

But...

Hi

HI

The best way to not use local login in connection through linked server using the login are configure to impersonate.

Be sure , that advanced options had been setup on dynamic...

Yes Greg. Its´s true.

But , for answer the best and more simple way, I use a backup and copy database.

If you´ll have a server in different domains , you can...

OK. Let´s me explain what I do here.

Create procedure in master server.

Create linked server for each server of my sql farm.

Execute an procedure fromn master server passing parameters for output.

In...

Hi

Can you send more details , such as errorlog , to verify the problem ?

Tks

DTS packages always had a problem.

Try a simple backup database for all database ( using maintenance wizards )

and restore it in the second server.

You can transfer logins using DTS...

Hi

Try using sp_attach_single_file_db.

Here is a example from Books Online.

EXEC sp_detach_db @dbname = 'pubs'EXEC sp_attach_single_file_db @dbname = 'pubs',    @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

Hildevan 

I think this is not a best pratice to do this.

Try to concentrate all procedures in one server and create linked servers for call this procedures and retrieve youe results...

The backup operation and backup log together are a good approach to do it.

Sametimes, you cannot stop the prodction server to proccess attach/dettach database.

Hildevan O Bezerra

Hi ,

The error appears that you have any user login into database.

Try tomodification the job to verify is exists users login in own database.

If exists and it´s possible to kill...