Sql-server – How to reset the master key in sql server 2005

sql-server-2005

Our old DB admin is gone, any ideas?

It looks it was set up many years ago.

Best Answer

Assuming that you are trying to reset the database master key you just need to use the ALTER MASTER KEY statement adding in the keyword FORCE.

ALTER MASTER KEY 
FORCE REGENERATE WITH ENCRYPTION BY PASSWORD = 'YourNewPassword!';

Related Solutions

Sql-server – Advice with date column SQL Server 2005

You can do steps 1 and 2: but use the DATEADD/DATEDIFF technique as per this: How to the get current date without the time part

You will most likely be unable to index the computed column because it won't be deterministic with the varchar method

Sql-server – SQL Server schema intact but every record from every table is gone

This happened at my company.

Someone re-ran the schema creation scripts from within the application's admin interface--something like an "initialize database" command. These scripts included a series of IF EXISTS()...DROP...CREATE statements to drop and recreate each table and constraint. Since they were designed to wipe a database even if it was already populated, they were carefully structured to account for foreign key relationships. Thus, the database schema was there and looked great, but all of the data was gone.

To prevent this, revoke the appropriate DDL permissions from the app's database login after it has created its own schema, or make sure any "initialize database" functionality your application has includes several safety checks and presents appropriate warning to the user regarding what's about to happen.

Best Answer

Related Solutions

Sql-server – Advice with date column SQL Server 2005

Sql-server – SQL Server schema intact but every record from every table is gone

Related Question