Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding column(s) to linked server in sqlserver 2005 Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 7:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 88, Visits: 1,067
Hi all,

WE HAVE ESTABLISHED LINKS SERVER BETWEEN TWO SQL SERVERS 2005

IS IT POSSIBLE TO ADD COLUMN OR FIELDS IN LINKED SERVER

PLEASE REPLY
Post #1360180
Posted Monday, September 17, 2012 7:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 13,085, Visits: 12,549
jamessdba (9/17/2012)
Hi all,

WE HAVE ESTABLISHED LINKS SERVER BETWEEN TWO SQL SERVERS 2005

IS IT POSSIBLE TO ADD COLUMN OR FIELDS IN LINKED SERVER

PLEASE REPLY


Can you turn down the volume a little?

I am not sure I understand your question. A link server is the mechanism that allows you have communication between two servers. It is not limited to any columns (assuming the user for the link server has sufficient permissions).

You read up on them here. http://msdn.microsoft.com/en-us/library/ms188279.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1360215
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse