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
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
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
Thank you Khtan
they are in a different servers
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
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