The code statements of Using Views on Page 41 do not work in my Windows XP Pro PC that is on Microsoft Windows NT 4 LAN Syste. I got the following error messages in Parse or Execute without Results:
Msg 156, Level 15, State 1, Procedure InventoryPublisherView, Line 3
Incorrect syntax near the keyword 'SELECT'.
Msg 111, Level 15, State 1, Procedure InventoryPublisherView, Line 6
'ALTER VIEW' must be the first statement in a query batch.
I want to try your modified code statements (that worked in your PC/system - what kind of your PC and LAN System did yopu use?)in my PC. Please post your complete modified code statements on this Forum.