Monthly Archive:: February 2011
Quickly script permissions in SQL 2005+
Posted by paschott in SQL Server On February 17, 2011
I wanted an easy way to generate a script to recreate all DB object and schema permissions for a database. Searching online, I found several different examples, but none quite did everything I needed. I put this
SQL 2008 R2 – SSIS Data Export Oddities
I don’t know if anyone else has had these sorts of issues, but we work quite a bit with conversions of various source data into our SQL Server database. I recently was handed a backup from SQL