Posts
Sort by recent activity
sp_refreshview broken in 2008 for views with different owner
Scripts were created using SqlCompare 6.x against an SqlServer2005 database. The particular database has since been upgraded to SqlServer2008-R2, and those scripts fail on sp_refreshview commands....
Bug? - SQLCompare 6.1 doesn't refresh views with drop column
It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one o...
SQLCompare drops but doesn't recreate statistics
Greetings,
We have clients who have created various statitics in a database that needs upgrading (ie synchronizing). If Statistics are ignored in project options, then no drop statements are gener...