Saving Master Keys

Using Database Master Keys in SQL Server

Learn the basics of Database Master Keys and how you can use them in SQL Server.

Master Key creation

Administering Database Master Keys in SQL Server

A short piece that gives you the basics of how to administer the database master keys that form the basis for encryption inside of your databases.

Database Master Key Error After Database Restore

When restoring a database to another server, you may get a master key error if using symmetric keys

RE: drop column with default

use this sp CREATE PROCEDURE usp_DropColumn @TableName Varchar(50), @ColumnName Varchar(50) AS /*==================================================================================================== NAME: usp_Dropcolumn TYPE: stored procedure (SQL 7) CREATION DATE: 08/01/01 USAGE: DECLARE @TableName Varchar(50) DECLARE @ColumnName Varchar(50) SET @TableName = 'MyTable' SET @ColumnName = 'MyColumn' Exec usp_DropColumn @TableName, @ColumnName PURPOSE : To Drop a Column from a Table irrespective of the constraints defined […]

RE: DOES Full backup Clear out Transaction Logs?

Thank you thank you!!! Indeed it doesn't clear out the log and I was being able to log ship the transactions to secondary server!!!! and apply the logs successfully. Nevertheless, I have a new problem... With Log shipping wizard choose to be "terminate user while loading" option and "standby option" for the log shipping jobs... […]

Link server Problems

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Error log message about TransactionDispenserInterface

This is just an informational message meaning that the MSDTC service is unavailable at the time when SQL Server is started. It won't result in any problems with subsequent distributed transactions provided the MSDTC service is available later when the distributed transaction takes place. The solution is to start MSDTC before SQL Server - by manually starting MSDTC […]

RE: Where does SQLServer stores ResultSet

Thanx Bert De Haes. This is what I was actually looking for. One more question please. It's kind of silly but since I'm new and would like to find out what does # means before the table name in your reply. Thanx man for your help. Muneeb.