Monday, October 02, 2006 - Posts

SSIS - Feature requests for annotations

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS - Feature requests for annotations
The new RSS feed is here

I was looking through the feedback in connect and saw a suggestion about wrapping text in annotations. If you've tried to be a good citzen of developer land you will have come across the fact that annotations don't word wrap. If you find that annoying then please vote.

In addition I have added another suggestion that annotations are tied to transforms and tasks

Finally I have requested that annotations can be formatted i.e. make them bold, italic etc. some packages are complicated so annotations are key to understanding the package.

Please support these suggestions

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS - Feature requests for annotations

TSQL - How to validate all SPs in a database?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/TSQL - How to validate all SPs in a database?
The new RSS feed is here

Views compiled without schemabinding are prone to issues if the underlying tables change, i.e. are dropped or columns change.

You can validate a view against the current schema by using sp_refresh_view. However this only works on a single view. To do all a database you can use the following script

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/TSQL - How to validate all SPs in a database?