Dependency issue while executing the script

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  March 6, 2009 at 4:06 am

  #155381

  Hi All,

  We are getting dependency issue while executing the script (Created the Script using, Generate Script option for a database) in Views.

  Here my question is, is it possible to SET dependency option as OFF/disable ... something like that for a Database or for a Script?

  Please help me to solve the Problem...

  Appreciated your help!!!

  ---

• Grant Fritchey

  SSC Guru

  Points: 398872

  More actions

  March 6, 2009 at 6:15 am

  #954805

  Does the syntax of the view have WITH SCHEMABINDING in it? If so, simply remove that.

  What is it you're trying to do?

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning