Thank you Steve for posting script.
Usually people added just a handful of object types they want to script. Tables, views , SPs
For source control, I don't want to...

Can I download scriptdatabase.ps1 file? I do not see link to it.

You've choosed great example. I personally credited many times Andrew Zanevsky for his sp_force_shrink_log procedure.

Vijay,

it is not clear to me why you "...do not want to use left or right function". Are you looking for some new features in Yukon?

Anyway, here are statements that might...

Move from varchar to Nvarchar will increase data size by 100% and that will bring other performance and hardware considerations.

AlexM

Use scptxfr.exe utility located in \MSSQL\Upgrade\ folder and schedule CmdExec step.

   scptxfr.exe /s server1 /d pubs /I /f c:\pubs.sql /A

DBCC SHRINKFILE ('x2_Log', EMPTYFILE)

ALTER DATABASE x REMOVE FILE x2_Log

Keep in mind that you cannot remove primary log file.

Simple adding new zipcodes and keeping old ones may not work correctly.

For example: Lee Mont, VA zipcode used to be 23403 now it is 23421

Adding new record will leave...

This might show database growing trend.

select backup_finish_date,database_name, backup_size from msdb..backupset where type='D'

cluster res "SQL Server" /off

Check out relog.exe command line utility from W2K Reesource Kit.

http://www.microsoft.com/windows2000/techinfo/reskit/tools/new/relog-o.aspt

I'm not sure it will resolve your problem. Try it again. I just did it with pubs..authors and it worked as intended on S2K SP3.

First connection:

USE pubs

SET TRANSACTION ISOLATION LEVEL...

Maintenance plan creates backup with different name every time. Backup name has dbname then "_db_" then datetime portion. Knowing that we can use xp_cmdshell dir command to get all available...

There is a great procedure sp_force_shrink_log written by Andrew Zanevsky. Download it at http://www.pinnaclepublishing.com/sq/SQmag.nsf/Index/F36C151BD80FAD8F852568D0007799BE?opendocument