It's all about requirement. 🙂

Thnx Folks...

Hi unaur,

Can you post your code?

The question appeared tougher to me, but I got the full score. I had a bit idea of the sys.column_store_segments catalog view.

SET NOCOUNT ON

declare @servername nvarchar(4000), @dbname nvarchar(200), @cmd nvarchar(4000) , @return_value INT;

SET @servername = (select @@servername)

SET @dbname = 'database'

Print @servername

Print @dbname

SET @cmd = 'FORFILES -p \\drive\SQL_scripts\db_TSQL_Scripts\Procedure\ /s /m ...

Hello Jeff Moden,

PEr your suggestion, I used FORFILES but as I have placed the .sql scripts in the UNC path, getting this error: =

ERROR: UNC paths (\\machine\share) are not supported.

Hi Andrew P,

Let me know if you have any better solution in my case to use VBA (C#) or Powershell may be ..

Thanks.

I am using sqlcmd servename database -i "input sql" -o "outputfile.txt".

But I m not really liking this method.... as ineed to update all file name. Instead if I could just...

Hi Andrew,

Could you plz provide more details or else if you have any such script in C# or powershell script which I can use..

I need the o/p files to review...

Seems like it's sort of ISNULL function. If it's encountered NULL, the 3rd parameter will replace the entered value. Nice Question.

Thanks everyone. Now, yesterday I wrote one. I will upload that to the script section, please review and comment. Will do it in the coming week.

Have a great weekend to...

I got one wrong. I did not realize to answer correctly that why the store proc did not execute.....

Those are all set..

I want to modify my exidting jobs efficient to stop running during less drive space matters...

Scored 1. 🙂

V Nice Question. The best part to solve Steve Jone's questions are , we need to read this thoroughly and carefully.

Keep posting more exciting questions, Steve!