SQL Server Performance

problem with the views

Discussion in 'SQL Server 2008 General DBA Questions' started by pankajsomraj, Aug 24, 2009.

  1. pankajsomraj New Member

    Hi
    I created a view in a development enviroment and migrated the same view to the test environment. The view works in dev but not in qa. can anyone tell the reason and where I should be looking to trouble shoot?
  2. Adriaan New Member

    Maybe you didn't script permissions on the view, or you're using object names without the owner prefix ... etc. etc.

Share This Page