Good heavens no, I did not think you were trying to insult me. You did not
know my background and I did not want you to think I was a SQL Server.
I truly appreciate your help
Thanks.



>I was not trying to insult you. I am sorry if it sounded like that.
>
>Just add the word SCHEMABINDING at the end and then try to index. It should work.
>
>
>>Thank you for your reply.
>>I apologize for my ignorance but I am not an SQL Server programmer, I am just someone
>>who was told to go program a stored procedure by my boss.
>>
>>I hope this is what you want.
>>
>>CREATE VIEW dbo.vw_SMPaper_Orders_LineItem_Inventory
>>AS
>>SELECT dbo.Inventory.item_status, dbo.Lineitem.item_cost_center, dbo.Lineitem.fulfillment_id, dbo.Orders.orders_id, dbo.Lineitem.lineitem_id,
>> dbo.Inventory.item_id, dbo.Lineitem.item_primary_reference AS lineitem_primary_reference, dbo.Inventory.item_prefix, dbo.Inventory.short_desc,
>> dbo.Inventory.cost, dbo.Orders.primary_reference AS orders_primary_reference, dbo.Orders.customer_reference, dbo.Orders.order_date,
>> dbo.Orders.ship_date, dbo.Orders.consign, dbo.Orders.ship_postal_code, dbo.Orders.ship_city, dbo.Orders.ship_region, dbo.Orders.ship_address_1,
>> dbo.Orders.ship_attention, dbo.Lineitem.qty_shipped, dbo.Lineitem.qty_ordered, dbo.Inventory.primary_reference AS inventory_primary_reference,
>> dbo.Inventory.default_uom
>>FROM dbo.Inventory INNER JOIN
>> dbo.Lineitem ON dbo.Inventory.item_id = dbo.Lineitem.item_id INNER JOIN
>> dbo.Orders ON dbo.Lineitem.orders_id = dbo.Orders.orders_id
>>WHERE (dbo.Lineitem.item_cost_center IN ('SMS', 'SMP'))
>>
>>If this is not what you need, where would I find a definition of my view
>>Thanks again.
>>
>>Jim
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>>What's the defination of your View? You cannot index all kind of views. There are some rules you need to follow. Copy your View defination here and I will be able to tell you why.
>>>
>>>>I created a view in the Create schema sql and then tried to index it.
>>>>I received the message.
>>>>Cannot create index on view 'vw_SMPaper_Orders_LineItem_Inventory'
>>>> because the view is not schema bound.
>>>>how do I bind my view to a schema.
>>>>
>>>>Thanks
>>>>Jim