February 26, 2009 at 2:00 am
hey all....
before i ask my question i want to say that i'm a novice in sql server...i worked with sql server express for web development purposes only..
i have a database placed on a database server for my company...the database contains tables and stored procedure....i want the resultant grid to be linked to a database found on my pc(which later i will upload to the same server) and add some columns which are updatable without affecting the original data....i though about copying it and creating a job that will constantly copy updates but i was advised to create a linked server to avoid data duplication...i created one after installing sql server 2005(full version)....and i just don't know if it is working and how can i utilize it if it is working(by utilize i mean execute the stored procedure that i need)...thanks in advance....
February 26, 2009 at 2:22 am
You should be able to reach the data by calling tables from that server by this format:
server.database.user.tablename
While you can use database..tablename normally, referring to a linked server should be fully specified. Is this enough answer for you?
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply