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.
| Author |
Topic |
|
gavinjb
Starting Member
34 Posts |
 Posted - 2011-10-06 : 06:47:43
|
| Hi,We have a fairly complex setup which is causing problems when trying to open Views in the Designer.We have two Servers that we have linked (MIS-01 & MIS-03), but due to them being on a diferent domain when we setup the Linked Server we have had to define them as MIS-01.domainname & MIS02.domainnameThis means that in SQL when we want to references databases on the Linked Server we have to [MIS-01.domaainname].Database.dbo.Table, this works fine in SQL but if you open a view in the designer (works fine if we Alter View to Query Window) is trips the [] round the Linked Server Name.Does anyone know of a way to stop Management Stdio doing this and enabling us to use the Design View again for our Linked Server Views.Thanks,Gavin, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Designing Views and Linked Servers