Ars Technica

SQL Server 05: Grant Symmetric Key access to only 2 users

I got this figured out on StackOverflow, turns out the accounts I was using were all db_owner's of that DB so they had access to the key by default.<BR><BR>Once I created a new account that wasn't a ...
Ars Technica

SQL Server 2005 - copying tables and keys to another instance

How do I copy tables in SQL Server 2005 to a new instance while maintaining the foreign keys and identity columns in the source instance?<BR><BR>The import/export function in Management Studio creates ...