I knew that the limit has been doubled. From 25 its now 50.

drop table #tfoldsizeinMB

create table #tfoldsizeinMB(size nvarchar(100))

declare @cmd varchar(3000)='powershell "(Get-ChildItem ''D:\backups\MSSQLSERVER\'' -recurse | Measure-Object -property length -sum).sum/1MB"'

--select @cmd

insert into #tfoldsizeinMB

EXEC xp_cmdshell @cmd

select CEILING(size) as 'Size(MB)' from #tfoldsizeinMB where size is not...

For backup size of a folder , you may use this script:=

drop table #tfoldsizeinMB

create table #tfoldsizeinMB(size nvarchar(1000))

declare @cmd varchar(3000)='powershell "(Get-ChildItem ''D:\backups\MSSQLSERVER\'' -recurse | Measure-Object -property length -sum).sum/1MB"'

select @cmd

insert into #tfoldsizeinMB

EXEC...

Got full credit.

Was eager to know that is this an advanced level compared to CDC?

Nice easy question. Though hardly database mirror is in use, but good to recall the past.

Was an easy One. Scored Max.

Instead of writing two sepereate blcks, can I not modify the SP with the below string?

IF OBJECT_ID(N'Sales.GetSalesOrderByCountry', N'P') IS NOT NULL

DROP PROCEDURE Sales.GetSalesOrderByCountry;

GO

CREATE PROCEDURE Sales.GetSalesOrderByCountry

...

Nice Question. I scored the maximum. 🙂

Thanks Pramod for the nice question!!!!

Just to give everyone a bit more detail about "polybase" :

PolyBase allows you to use T-SQL statements to access data stored in Hadoop or Azure...

https://msdn.microsoft.com/en-us/library/ms143432.aspx

25 instances on a failover cluster when using a shared cluster disk as the stored option for you cluster installation SQL Server supports 50 instances on a failover cluster if...

Dear Folks,

I did more research on this.

For SQL 2008 R2 and below, use "@email_profile" instead of "@databasemail_profile", but from sql 2012 onwards +, you can use "@databasemail_profile".

Let me know if...

It internally calls the procedure : "sp_refreshsqlmodule_internal"

Can you tell me this if not resides in master as I can't find it?

Hi,

Can you pl add more logic here to send the .HTML reports via email to the recipients?

Hi Lowell

To run your script, do I need to use vb.net alone or any other way available?

Thnx Steve n Gian

In one instance, I found no Spn registered to the sql account thru that sql runs.

On few other servers, i found spn is regustered stil thereare permissio....