I have created a linked server in ms sql 2005 on server machine A . It links to another database(say D1) located physically on a different server machine B. I have jsp code on Server A which accesses local database on server A. Can I access the remote database D1 using the link server in my jsp code the same way as I access other local tables??

Re: Linked Server in Ms sql 2005 80 80

If your web layer includes SQL code, yes, you can access the tables on D1 by running the queries against ServerA.

Re: Linked Server in Ms sql 2005 80 80

SQL code

my web layer is written in JSP that has java code embedded in it to connect to MS SQL Server.
Thanks a lot for clearing my doubt!!1:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.