Last evening, as a result of our autogrow settings, our production
database grew from 102 GB to 107 GB. What puzzled me is that, prior to
the growth, we still had a good 10% free space left in the data file.
My understanding is that SQL Server will automatically grow a database

In the Portal1 case expression in the script at the bottom I would like
to replace where the result 1 is returned, with the substring function
returned as Portal
{SUBSTRING(Field1, CHARINDEX('tonep', Field1) + 4, (CHARINDEX('.txt',

I've started researching on Unit Testing and I must admit
I had never heard of Unit Testing until a couple of months
ago. Obviously I am interested in Unit Testing Stored
Procedures.

I want to copy a database from one server to another.  I'm happy about
how to do this but also want to copy a number of DTS packages, jobs and
alerts that relate to this database.  Is there any way that I can copy
them or will I need to create them again on the new server.