I've been using MS SQL Server 2000 for years - recently we upgraded a few servers to MS SQL Server 2005. I was hesitant to say the least. I still use administer and develop these by using MS SQL Server 2000 scripts / code and i use a 2000 server for testing and development.
So i thought id take the time to learn MS SQL Server 2005 - for some reason(unbeknown to me!!) they changed alot of things for the worse!!!!
What i was going to ask was - does anybody actually use the service / database / data encryption keys and certificates on live servers - we have has MS SQL Server 2005 for months now and i never even knew abou them until i read this book!!!!
Also does everyone else still use sp_addlogin and sp_grantlogin to add users instead of this create user for windows crap or is that just me??????????