*URGENT* SQL Server 2000 Question

[beatmix01]

Ok, Here is the problem. I need to implement view to enforce a rule I have. I have the following SQL statement:

CREATE VIEW v_new_cable

AS SELECT Make_ID, Model_ID, PurchaseDate, Equipment_ID, Description, Vendor_ID, Image_ID

FROM Inventory$
WHERE Equipment_ID = '3' -- The number 3 represents a cable.

Anyway I check the syntax and that checks out ok. Then I get an Alert Message saying that:

The Query Designer does not suppor the CREATE VIEW SQL Contruct.

What does that mean and how do I fix this?

Thanks!
😕