Jeff Moden (6/22/2015)

---

Welsh Corgi (6/22/2015)

---

DBA From The Cold (6/22/2015)

---

You'd need to create the required partition schemes/functions and then rebuild your tables' clustered index onto the partition scheme.

Depending on how your...

he problem was solved.

I had to DROP the following:

drop database encryption key

drop certificate TDECert

drop master key

Then I performed the following:

BACKUP SERVICE MASTER KEY TO FILE = 'C:\Temp\service_master_ key'

ENCRYPTION BY...

DBA From The Cold (6/22/2015)

---

You'd need to create the required partition schemes/functions and then rebuild your tables' clustered index onto the partition scheme.

Depending on how your table is built you...

Post removed.

Jeff Moden (6/12/2015)

---

I can't speak for anyone else and I'm sure that it will rub some folks' sensibilities the wrong way but I do install the full monty on my...

I got my way. Server Core is out.

Lowell (6/12/2015)

---

sqlcmd.exe only? you should know better.

you can use your local SSMS GUI to connect to any version of SQL, including a remote SQL Server Core instance.

SSMS doesn't care if...

Lynn,

Thanks for the feedback.

GilaMonster (6/12/2015)

---

Hell no. Use SSMS from a client machine. There's pretty much no case I can think of where you'd need to...

Lowell (6/12/2015)

---

No.

the point is there is no need to have SSMS on the server.

you already have it local,...

I misunderstood. :blush:

So you can install SSMS on the Server?

Please post at the following:

[

http://www.sqlservercentral.com/Forums/Topic1694123-2799-1.aspx

/url]

I was about to put the link from the older post to the new one and I saw that Gail had responded. What I should have dome is...

I meant to post this in the 2014 forum.

So use the command line for everything?

What do you mean that is a minor one?

I only use it if the Server is not allowing remote connections.

Thanks.