schemabinding view creation issues

• Graham Cockram

  SSC Rookie

  Points: 31

  More actions

  October 3, 2006 at 10:30 am

  #172918

  Hi all,

  I'm new to SQL Server 2005, I'm trying to create a schemabinding view and get the following error message:

  Msg 4512, Level 16, State 3, Procedure Policies, Line 2

  Cannot schema bind view 'tablename' because name 'schemaname.dbo.tablename' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

  The table I'm trying to create the view from is in another schema of the same SQL Server 2005 database, to reference the table in a select statement I need to put schemaname.dbo.tablename - when trying to create the view I get the error message above.

  Does anybody know how I should reference the table in question when creating a schemabinding view as I need to use the indexing capabilities on this view.

  Thanks in advance for your suggestions,

  Graham.

• Abhinav Nigam

  Newbie

  Points: 1

  More actions

  March 2, 2007 at 9:26 am

  #692879

   

  HI I am also facing the same issue.

  What did you do it get over it.

  Please respond at abhinav.nigam@gmail.com

  Regards

  Abhinav