linked server object - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

linked server object

Author

Topic

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2003-07-16 : 05:17:53

dear all,

how to create a linked server object, so i can update the records like i update the records in the view object or execute query like this

update view_name
set staffname= 'new value'

the view object is the linked server object from table object

oh

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-16 : 07:29:03

Dear oh!

Even I - an inborn dummy - can clearly see that nobody here
can understand what are you talking about...

- Vit

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2003-07-16 : 08:08:52

dear vit

i'm sorry about that ..,
now i'm trying to make my question simple

1. is possible to create view object(in SQL server) and the source table from linked server ?
2. is possible to update records in the view object(linked server)?

i try to update records and returns this result:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name.....

oh

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-16 : 08:34:14

Hm... in QA a such view is updatable OK (update myView set ...).

From EM (Open View >> Return all rows...) really there is a problem.

- Vit

Edited by - Stoad on 07/16/2003 08:35:51

mr_mist
Grunnio

1870 Posts

Posted - 2003-07-16 : 08:50:41

Post the code for the view...

-------
Moo. :)

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2003-07-16 : 09:36:40

select * from Linked_server_name.DBName.dbo.TableName

oh

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2003-07-16 : 09:36:41

select * from Linked_server_name.DBName.dbo.TableName

oh

mr_mist
Grunnio

1870 Posts

Posted - 2003-07-18 : 04:22:15

Well, that should work, unless some part of Linked_server_name.DBName.dbo.TableName is wrong. Also, you should really use the field names instead of *.

-------
Moo. :)

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2003-07-21 : 01:11:48

thx for you answer,but
do you know why there is problem when i try from EM ?

oh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources