Hello Jessie

I found that you mentioned about one function: "fx_DelimitedSplit8K". Can you please reply me with the function code?

Ops, thanks for the question. Good one.

Started my day with a easy question. To my understanding being developers we need to think for doing explicit conversion rather asking sql engine to take the pain.

Thnx Lowell for giving me the approach and the nice script indeed. Many thnx.

Hi Luis

I can go to online site to steal their password if incase I have a one...

To my understanding SQL Server may not need much use of FORMAT as if I want that users need to enter mobile no based on US style i.e. 3-3-4, then...

How to do it for all procedures available in a database and mail them to email address??

I use this utility quite often to call procs from sql. Scored 1 mark.

Got full credit...

HI Guys

I found something interesting. I was trying to setup broker in msdb as I got this error msg "Database Mail depends on Service Broker. Service Broker is not active...

Use this:=

IF NOT EXISTS (SELECT value_in_use

FROM sys.configurations

...

I found that you added CASTING with BIGINT. Thanks.

The revised script is here:-

********************************************************************

set nocount on

CREATE TABLE #tempList (Files VARCHAR(500))

DECLARE @result int,@cmd sysname,@cmd3 sysname

DECLARE @var sysname = 'C:\Users\'

SET @cmd3 = 'DIR...

I think the correct answer would be "Stream Aggregate". Anyways.!!

Turn on xp_cmdshell thru sp_configure.

By default the feature is turned off and u need to enable it before you start your work.

Awesome script by Lowell.

I quick questions, if in a server multiple database mail accounts are configured. How to ensure which are the db mail accounts?

If I run :=

...

Thnx Perry.

So is my automated script wrong (attached one in previous mail) per the process of enabling aTDE??

Do I need to do any changes to it? Plz suggest.