We are running sql server 2005 and I need to create some views to be used in a third party application. I am not by any means an expert on this but have enough knowledge to create a view to perform the task needed. The only problem is that when I create a view, it saves with the schema "dbo" ( the default, I assume). I need the view to relate to a different schema, but I have not found a straight forward way of defining it at the time of creation. Can anyone help walk me through this? This is very important for my report writing in the third party application.