|
NorwegianViking
Junior Member
Denmark
119 Posts |
 Posted - 29 January 2004 : 19:40:37
|
Cool, grazman. Nice use of views.
And a very good set of instructions!
An Access user would not be able to use Views (I think) but could achive the same by linked tables.
About speed:
Linked server to another MS SQL Server is known to be slow. Very slow. Normally one would use the OPENQUERY function which allows a pass-through query against the linked server.
syntax is:
SELECT * FROM (linked server name,'SELECT [field1],[field2] FROM [instance].[owner].[table]'
But I have no idea if the Create View allows this function. It should be something like this, it it works:
CREATE VIEW dbo.FORUM_A_REPLY
AS
SELECT * FROM OPENQUERY ([SERVER9\I2],
'SELECT [CAT_ID],
[FORUM_ID],
[TOPIC_ID],
[REPLY_ID],
[R_STATUS],
[R_MAIL],
[R_AUTHOR],
[R_MESSAGE],
[R_DATE],
[R_IP]
FROM [SnitzArchive].[dbo].[FORUM_A_REPLY]')
GO
|
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
 |
|
Topic Locked
