Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Index cannot be created on view because the underlying object has a different owner RE: Index cannot be created on view because the underlying object has a different owner

  • It is difficult to answer the question, because I don't know why you set up different schema owners in the first place. My preference is to have dbo to own everything, but that also requires the right way of thinking about security for that model.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]