Hi Chris,

Your script is different than the topic.

HI Britton,

It works.,

Kool one

Thanks JAcob, Lynn and Others....

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [database_name].[dbo].[sp_fulltext_database] @action = 'enable'

end

I want to execute the above database to a specific database.

Please suggest how to write the syntax dynamically.

Only these section have some logical error, I suppose:-

--Print @out_fileDate

DECLARE curs_oldfiles1 CURSOR FOR

SELECT a.output_file_name

...

Need to write in T SQL alone.

Hi Lynn,

I am tryoing to duplicate the same file with a different name (basically want to add timestamp to it and want to keep the oputput file for 5 days...

Easy and Obvious!!!

Same failure.

Shared path. It is properly passed as s variable, I verified.

Worked. Many thanks Lynn...........Good Day

Can you please suggest all the files from one location to another using the temp table (#FileDetails)?

I have a rmeote location where I want to copy all the files from...

Awesome Post. Thanks Jeff Sir...

Eirikur,

Can you suggest how to use sample percent and other hints using sp_updatestats??????????....???????

The table which has billions of records do u suggest running sp_updatestats???????????????????????????????????????