Posts
Sort by recent activity
Object name to Definition mismatch
There appears to be an issue when syncing objects where the underlying definition does not match the object name.
For instance, you have a view object named v_users and its definition is:
create vi...
Views with Order By not in Select List
I noticed that if you have a View which has an item in the Order by list, but not in the select list the script will error out. For example:
CREATE VIEW user.view
AS
SELECT TOP 3 Id, Naam, Host, Wo...
Views that include Select *
I'm not using the 'Include dependent database objects'. However, I ran into the following situation:
Underlying table changes (column added)
> View references the table with 'Select *' statement, b...