My main concern is not having SSMS on the Server and the learning curve to use command line.

How do I get a version that only shows active connections?

I'm showing task that are still connected but they are not doing anything.

It is acting like sp_who2.

I already have it and I have been using it for years.

I challenged them why they was to encrypt the entire database.

I was told that it was a Business requirement handed down from Corporate.

What are some of CONS of doing this?

Thanks.

I'm sorry but what are you asking/telling me?

There are a lot of negative as backup and restore.Thanks for setting me straight.

I used encryption to encrypt a data element. and that went pretty smooth.

I did not want to...

Yes...

It works.

I had to go and accidently clicked too soon.

Lynn Pettis (6/8/2015)

---

Welsh Corgi (6/8/2015)

---

USE MASTER

GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'

CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'

USE Adventureworks2012

CREATE DATABASE...

USE MASTER

GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'

CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'

USE Adventureworks2012

CREATE DATABASE ENCRYPTION KEY

WITH ALGORITHM = AES_256 -- Error

ENCRYPTION BY SERVER CERTIFICATE TDECert

USE MASTER

ALTER...

I included the script for testing.

Thanks.

Thank you. I appreciate your feedback. Excuse me.

I was just trying to make it easier this is a very interesting subject.:-)

olibbhq (5/31/2015)

---

Hi,

Thanks for all your help, I took the example content from wikipedia but all the content I want to put into a table is in the format. Essentially I...

Why do you think you need that you do not need to use SSIS?

If you get your date in a simplified format you can use the Import Wizard To load...

olibbhq (5/31/2015)

---

Hi,

Thanks for all your help, I took the example content from wikipedia but all the content I want to put into a table is in the format. Essentially I...