Thank you all dear!!

It was Independence day of India, so I couldn't reply.

Thank you once again, hope this was helpful to all.

Sure dear!,

I will use your query, I have tested this. seems good. Thanks once again.

Hope this will helpful to all.

Thanks ChrisM@Work for your comment. I got the tone.

Generally UDFs are slow as compare to same query.

you are right subhanshu-khurana

I have already send request for this.

Thanks for the comment.

Use below example :

DECLARE @i TABLE( mychar VARCHAR(50)

,deriv as SUBSTRING(mychar,1,3) --Use this

,newderiv as left(mychar,3)); --Or use this

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

...

Good Script..

It somewhat works like select the table and press alt+f1 .

Your welcome dear!

Still it is difficult to understand and change the script.

Good script 🙂

Either use

USE msdb

GO

in starting or...

Interesting Script. 🙂

But it is not a good practice,

Although you have described every thing about the script, You should create script dynamically because all organizations have different timings,

Scholars...

This script will fail while databases are in use.

User have to manually kill all processes related to those databases, which have to restore.

Then use following link -

Truncate all tables reference foreign keys[/url]

Hi This Script will not give any output but will rebuild or reorganize indexes.

This Script is only for production environment and it will create a job, You have to run...