Access table from other server

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Integration Services?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Priya004 Ten Centuries Points: 1368 More actions · Answer 2

Ten Centuries

Points: 1368

September 9, 2014 at 1:45 am

No ,From SSMS stored procedures

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

If you have SQL Server 2012 you can start an SSIS package from a stored procedure 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Priya004 Ten Centuries Points: 1368 More actions · Answer 4

Ten Centuries

Points: 1368

September 9, 2014 at 2:08 am

🙁

nooo

Priya004 Ten Centuries Points: 1368 More actions · Answer 5

Seems like it is not possible apart from the above 3

quackhandle1975 SSChampion Points: 11055 More actions · Answer 6

If you can't use the methods you listed then possibly you may have to export/import the data you need onto the SQL Instance you work from.

qh

[font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]