is this even possible?

[Guest]

hey all,

i was wondering if you can write code against a linked server in SQL Server?
If so, are there any resources (e.g. articles, forums, etc.) I can view?

thanks,
rodchar

 

[Mark Rae]

i was wondering if you can write code against a linked server in SQL
Server?

Absolutely. I do it all the time, specifically with ADSI.

If so, are there any resources (e.g. articles, forums, etc.) I can view?

Loads - tell us in a bit more detail what you're trying to do...

 

[Guest]

I'm just trying to come up with a sample application in asp.net that will
read, insert/update/delete to a linked server.

by the way, what are some major reasons for linked servers?

thanks,
rodchar

 

[WJ]

I'm just trying to come up with a sample application in asp.net that will
read, insert/update/delete to a linked server.

by the way, what are some major reasons for linked servers?

The primary reason to link to a SQL server is to access data from that
server. And or replication of data between linked-servers. Example: My
server is a publisher. My application processes the data, then pushes the
data out to each linked-server at night.

John

 

[Guest]

does anyone know where i can find examples of coding against linked servers
in asp.net?

 

[WJ]

does anyone know where i can find examples of coding against linked
servers
in asp.net?

The access method should be transparent to you as developer.

For examples:

1. To access a table within your own SQL server box , you just code "select
* from [dbo].[myTable]".
2. To access a table within a linked-SQL/server, you would code: "select *
from [linkedServerName].[CatalogName].[dbo].[SomeTableOverThere]"

The above example is typical day-to-day job of an Asp.Net application. Since
you did not tell what kind of operation from your application, its kind of
hard to guess.

John