this gets certs too, with a little work you can expand to get symm and asymm keys too

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

DECLARE @majver INT

DECLARE @minver INT

DECLARE @build VARCHAR(16)

SET @sql...

Depends what instances...

😉

a cert is an asymmetric key, what is it you are expecting to see

You're welcome

Yeah but mine is super awesome ??

a one node cluster will not support an availability group.

An availability group requires at least 2 replicas which must reside on separate nodes, therefore a 2 node cluster minimum is...

Here's my script, feel free to modify it as required, not that it should need it

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

DECLARE @majver INT

DECLARE @minver INT

DECLARE @build VARCHAR(16)

SET @sql = ''

SET...

as I said here, remove the current log shipping secondary database and add a new log shipping secondary. The primary stays in place

You don't remove Log shipping completely, the...

Yes this is detailed in the...

happycat59 (1/3/2016)

---

Once you have done this, you need to check what account you are using to run the SSIS package - if you don't have a proxy setup then this...

Briceston (2/1/2016)

---

Hi,

So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder. My next...

curious_sqldba (2/1/2016)

---

If you are moving to 2016, it will be two phase migration, from 2008R2 - > 2014 and then from 2014 -> 2016. At most you upgrade to 2...

dajonx (2/1/2016)

---

One more question about mount points. You wrote that the root volume must be small to prevent files/folders being created on that volume. So really, I can...