The script is not entirely correct. If the table creation doesn't explicitly use dbo., it creates the table under user credentials, NOT as dbo owned object. If you try to...

Thank you for the reply.

I am not sure how the views are being called, a friend of mine asked this question, how to use set transaction... in a view. This...