Create view with specific owner
Posted on 2008-11-19
I'm distributing an application commercially, I hope. My installer needs to create a SQL database (called newDB), tables, functions, and views.
Which is better:
create view viewName as select field1 from ExistingdbName.dbo.tableName
create view viewName as select field1 from ExistingdbName..tableName
I know that under most circumstances the result is the same, but I don't want to be sloppy about it by making that assumption. Should my installation program ask the user for the owner of ExistingdbName? with a default to dbo?