Cannot delete these objects because they are open in designers.

The selected database objects are currently open in a designer. If you want to delete these objects, you must close the designers and then, for each object, choose Delete on the shortcut menu.

See Also

Other Resources

How to: Delete a Database Diagram (Visual Database Tools)
How to: Delete Tables from a Database (Visual Database Tools)
How to: Delete a Stored Procedure (SQL Server Management Studio)
How to: Delete Views from Databases (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance