SQLTeam.com | Weblogs | Forums

Use two tables in different database without link server


#1

Hi
how can I save a single record into a table in another database using stored procedure, and without using linked server because i don't have enough permission to do that
please advise
Mohamed


#2

if both database reside on the same SQL Server instance, you can just reference it like
[database name] . [schema] . [table name]

example

INSERT INTO  [db2].[dbo].[table2] (  . . . )

if the database are not in the same SQL Server, you are out of luck. You will need to use Linked Server


#3

Hi

You could .. get the results of the SP into a file on disk

Then use that data with insert script to insert into destination
database


#4

Thank you Khtan

they are in a different servers


#5

thank you hhrr

do you mean to export the records i would like to update into file, then use the file to update the second database?

do you have a sample of code?
do you have a sample of code on how can I export SQL server table into Access database table
thanks


#6

do you mean to export the records i would like to update into file, then use the file to update the second database?

yes thats what i mean .. there are ways

Google ....
you should find plenty of stuff