Cannot save a view/function/procedure that is self-referenced.

  • Article

Views, functions, and stored procedures cannot reference themselves directly or indirectly. For example, if you have a view named titleview, you cannot insert SQL syntax such as SELECT * from titleview.

To correct this error

  1. Remove the self-referencing SQL syntax.

    –or-

  2. Create a new view/function/procedure by using the Save As command.

See Also

Other Resources

How to: Create Views (Visual Database Tools)

Help and Information

Getting SQL Server 2005 Assistance