Viewing 11 posts - 16 through 26 (of 26 total)
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...
October 5, 2004 at 1:08 pm
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...
October 5, 2004 at 12:56 pm
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...
October 1, 2004 at 10:34 am
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...
October 1, 2004 at 10:26 am
Hi
Can you send more details , such as errorlog , to verify the problem ?
Tks
September 14, 2004 at 11:48 am
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...
September 14, 2004 at 11:36 am
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
September 14, 2004 at 11:30 am
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...
July 29, 2003 at 10:59 am
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
July 29, 2003 at 10:55 am
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...
July 29, 2003 at 10:50 am
Viewing 11 posts - 16 through 26 (of 26 total)