Thanks a lot!

I would like to script out permissions assigned to a user for symmetric key/certificate created for column level encryption. Thanks.

Hi Perry,

I'm not able to script out the permissions for Symmetric keys/Certificate.

Thanks!

Thanks Steve!

Thanks a lot Perry! Appreciate your help!!

Thanks!

USE [Test]

GO

/****** Object: Trigger [dbo].[TR_Aud_Update_Datetime_Update_User] Script Date: 1/30/2016 11:16:58 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TRIGGER [dbo].[TR_Aud_Update_Datetime_Update_User]

ON [dbo].[Users]

FOR UPDATE

AS

-- Do not put anything before these lines!

IF...

Appreciate your help on this Hugo & Gail!

Updated the script:

USE [Test]

GO

/****** Object: Trigger [dbo].[TR_Aud_Update_Datetime_Update_User] Script Date: 1/30/2016 10:58:39 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER dbo.TR_Aud_Update_Datetime_Update_User

ON...

Sorry I was trying to update this from my phone as I had no access to system.

Please see updated script.

USE [Test]

GO

/****** Object: Trigger [dbo].[TR_Aud_Update_Datetime_Update_User] Script Date:...

Thanks for the advise Gail. I tried to modify the script.

Please validate the updated script.

--User_ID is PK Identity

CREATE TRIGGER [dbo].[TR_Aud_Update_Datetime_Update_User]

ON [dbo].[Users]

FOR UPDATE

AS

IF @@ROWCOUNT = 0

RETURN;

IF NOT EXISTS (SELECT * FROM inserted) RETURN;

SET NOCOUNT ON;

BEGIN

UPDATE dbo.Users

SET Aud_Update_Datetime=CURRENT_TIMESTAMP,...

Thanks a lot Hugo. Could you please provide a full script for the trigger with your recommended changes?

Sorry, I'm not good with scripting!

Can I create trigger & Constraints like this? Please verify the script.

Table name: [Users]

Audit Column names:

-----------------------

Aud_Create_User (Use SYSTEM USER)

Aud_Create_DateTime (Use create datetime)

Aud_Update_User (Use SYSTEM USER)

Aud_Update_DateTime (Use update...

No, per Microsoft.

I did the following steps and it worked.

DCOM User Group Membership

•Remotely logged into the server where SQL Server Integration Service was running.

•Started the Server Manager and brought up the...

Thanks Gail. I used VARCHAR(n) and it works.