[AccessD] SQL Server Link

You can make indexes on a SQL Server view provided that the view meets some conditions (among others the view must be made with schemabinding and no outer joins are allowed).
The first index created must always be a unique clustered index. Then you can build additional non clustered indexes on the view.
You say you are able to create one index your view. Then your view seems to meet the conditions, and I don't understand why you shouldn't be able to create additional indexes.
What error do you get? From where do you try to create this index (a query in SQL Server Management Studio, an Access query, a procedure in an Access module)?
Asger



-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kaup, Chester
Sendt: 20. januar 2010 20:34
Til: Access Developers discussion and problem solving
Emne: [AccessD] SQL Server Link

Is it possible to create two separate indexes to a SQL server view. One is no problem but two has me stumped. Thanks.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com