|
Posted by Erland Sommarskog on 12/08/05 23:49
(paulmac106@gmail.com) writes:
> You know I had tried that seperate table with an insert trigger, but
> again the windos app didn't like it, and unfortuanately I don't have
> control over the windows app. I didn't see how you can put an index on
> a view...am i missing something?
Read about it under the CREATE VIEW and CREATE INDEX statements in the
T-SQL reference. The view must be created WITH SCHEMABINDING, and all
notations must be two-part: dbo.tbl. There are a couple of more
restrictions, which is why I refer you to the manual.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|