To simplify the management of user access to SQL Server my company recently implemented a policy limiting the number of local login accounts. Software developers are now required to use their domain accounts to access and work within SQL Server. This new policy works great, except for those of us wh... [More]

I do a lot of database development, so I have several SQL Server and Oracle instances running on my system at any given time. Tonight I wanted to remove an instance of SQL Server that I installed a few weeks ago, but didn’t want to remove SQL Server in its entirety because I have other instances run... [More]

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created. I ran into this fun little... [More]