Hi, I have a problem, maybe someone can help me.
I'm traing to create a view with a Linked Server
This query works great:
select id, descr
from SERVER.DB.dbo.T ABLE
When I tray to create the view:
CREATE VIEW dbo.View1 WITH SCHEMABINDING
AS
select id, descr
from SERVER.DB.dbo.T ABLE
GO
I have this error:
Server: Msg 4512, Level 16, State 3, Procedure Pais2, Line 3
Cannot schema bind view 'dbo.View1' because name 'SERVER.DB.dbo. TABLE'
is invalid for schema binding. Names must be in two-part format and an
object cannot reference itself.
So I try this:
CREATE VIEW dbo.View1 WITH SCHEMABINDING
AS
select SERVER.DB.dbo.T ABLE.id, SERVER.DB.dbo.T ABLE.descr
from SERVER.DB.dbo.T ABLE
GO
I have this error:
Server: Msg 117, Level 15, State 2, Procedure Pais2, Line 3
The number name 'SERVER.DB.dbo. TABLE' contains more than the maximum
number of prefixes. The maximum is 3.
Then I try this:
CREATE VIEW dbo.View1 WITH SCHEMABINDING
AS
select a.id, a.descr
from SERVER.DB.dbo.T ABLE as A
GO
I Have this error
Server: Msg 4512, Level 16, State 3, Procedure View1, Line 3
Cannot schema bind view 'dbo.View1' because name
'iservsql1.osde rrhh.dbo.pais' is invalid for schema binding. Names
must be in two-part format and an object cannot reference itself.
This query alone works great:
select a.id, a.descr
from SERVER.DB.dbo.T ABLE as A
The names aren't what I describe here (id is not valid without []).
ANY IDEAS?!??!?!
I don't know what else can I do.
I need help!!!
TANKS A LOT!!!!!!!! 1 10122
Ariel (ap@data54.com) writes: Hi, I have a problem, maybe someone can help me.
I'm traing to create a view with a Linked Server
Stop! Take a step back and consider what you are doing!
An indexed view is a materialized view. This means that when an update
is made to a base table, this update is propagated to the view, not
only logically, but also physically.
Now, if that table on the remote server was updated would should happen?
Particularly, what would happen if our local server was unavailble? Or
the particular database was unavailable?
In practice, you cannot even have cross-database indexed views on the
same server, and you run into a stopblock already WITH SCHEMABINDING.
If you could create a schema-bounbd view that referenced another database,
each attempt to drop or rename a databaes, or set a it offline, would
need to check all other databases on the server for SCHEMABINDING
references.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike J |
last post by:
I have several stored procedures that run fine from my SQL Server
database (via the exec command.), though when I call these procedures
from my web application, they do not complete. I have other
procedures that in fact do run fine through my web application though,
so I do not believe its a front-end problem. The procedures only take
about 30 seconds to run from the back-end, so I know its not a time
out issue as well. Does anyone have...
|
by: wireless |
last post by:
I've had my SQL server database running for two years now without a
problem.
However, just today one of the main tables started returning an error.
The table is contained within a database called engineering. I back
it up once a week and the file size is up to about 40 MB.
The error returned when trying to return data from one table
(DbLucent) is:
|
by: Avirneni |
last post by:
With my understanding of indexed views and according to books I read
"indexed views" are supposed to perform much better than "temp tables"
(temp table having primary key and indexed view with clustered index
on the same keys).
But when I tried in my system I am getting opposite results. With
Indexed Views it takes 3 times more time.
Any body has any reasons for that? Or my understanding was wrong?
|
by: noelwatson |
last post by:
I am looking to create a constraint on a table that allows multiple
nulls but all non-nulls must be unique.
I found the following script
http://www.windowsitpro.com/Files/09/21293/Listing_01.txt
that works fine, but the following line
CREATE UNIQUE CLUSTERED INDEX idx1 ON v_multinulls(a)
|
by: Little PussyCat |
last post by:
Hello,
At work we have various servers, therefore we have various DTS Interfaces
which transfer data between them.
However when trying to save a new View to one server which gets its data
from another server nothing happens, I get an hourglass and nothing else.
Then I have to exit out of SQL Enterprise Manager and then no-one can access
the database on that server, so we had to restore from backup!
| |
by: Neil |
last post by:
I have an Access 2000 MDB file with a SQL 7 back end. I have a main table
with 50,000 records; and I have a selections table with 50,000 records for
each machine that uses the database (about 25-50). This allows each user to
have their own set of selections.
The selections table has three fields: ID (int), Sel (bit), MachName
(varchar). ID and MachName comprise the primary key.
I have a view that combines the main table and the entries...
|
by: Lyle Fairfield |
last post by:
I have a table: Schools,
and another table: Teachers
as one teacher may be assigned to more than one school I link these with a
third table: SchoolTeachers
I index (unique) this linking table on SchoolID and TeacherID to prevent
assigning a teacher to a school more than once.
So far, so good.
|
by: savvy |
last post by:
I searching using Keywords in MS Word and pdf documents for which i
have used the Index Server and linked with SQL Server but when i am
running the stored procedure thro my webpage i'm getting these errors.
And when i run this code in Query Analyzer its giving expeceted
results. I dont know where the problem is can anyone help please . I'm
really badly stuck. Thanks in Advacne
User does not have permission to perform this action. Line 3:...
|
by: Neil |
last post by:
I had a strange situation with a view in SQL 7, that I could use some input
on.
I had a very simple view -- select a, b, c from table1 where x=y and z=q.
Field a in table1 originally was varchar 70. A long time ago I changed it to
varchar 95.
I used this view as an ODBC linked table in an Access MDB. Recently, there
was one row which has a value in field a that was more than 70 characters
long. This caused an error when the view as...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |