Thanks for the help. This is what I came up with.

declare @minid int, @maxid int, @tofar int -- Minid holder, maxid holder, first null holder

declare @numberList table...

John Mitchell-245523 (12/13/2010)

---

To find out where the breaks are, you just LEFT JOIN your tally table to your table of IDs, and find the values in your tally table corresponding...

Thank you for the reply. I forgot one crucial piece of information. This has to run on SQL Server 2000 so the Over syntax, doesn't work...

Rudy:

Very nice. Hope I never have to use this. Never would have thought of this. Very cool!!

Steve B.:-D

Me Too Gail. Thanks very much.

Steve B.

Thanks for the update Steve.

Steve B.

Thanks for the reply.  What about the creation of the SPN at install time..  I suppose that can be taken care of by installing the SQL Server under a local...

Kathi:

Great Article.  Thanks.

I am interested in your login handling job........

"...The way I accomplished this was by adding the accounts and required access start and end dates to a table. My...

Suresh:

I modified your code to handle strange database names and large databases.

/*********************************************************************************************

Script Name: Sysfiles_Growth.txt

Purpose    : Displaying Auto-Growth factors of database files based on SYSFILES.

Created On : October 31, 2005

Author    ...

>>1) how large is the database ?

250 G

>>2) are you on local diska or a SAN ?

On a big "Array"...but not SAN....<sigh>.

Sorry about the confusion. Your first thought is what I was getting at,  'striping' a backup.