[dba-SQLServer] Views

Gustav Brock Gustav at cactus.dk
Wed Oct 8 05:11:43 CDT 2008


Hi Susan

I use views to bring tables from linked databases (could be an mdb file) into the database where access is needed to isolate the name of the linked server and the not-so-easy syntax to attach this (the three dots):

SELECT
  <list of field names>
FROM
  LinkedDbName...OriginalTableName AS AliasTableName

/gustav

>From: "Susan Harkins" <ssharkins at gmail.com>

>Do views still share the same popularity in 2008?
>
>Susan H.






More information about the dba-SQLServer mailing list