THIS STATEMENT IS NOT TRUE: "You should note that you cannot re-attach more than 16 files for a single database"

I regularly attach our databases that are 4TB in size...

This statement is in correct:

"You should note that you cannot re-attach more than 16 files for a single database."

I routinely re-attach databases with 25 files.

This is a nice .vbs that I use:

____________________________________________________________________________________

Const OpenAsASCII      =  0

Const OverwriteIfExist = -1

Set oFSO = CreateObject("Scripting.FileSystemObject")

sResultFile = "e:\merge.txt"  ' any existing file will be overwritten!

sSourceFolder = "e:\test"

Set oFolder =...

Thanks.  I found this:

http://www.sqlservercentral.com/scripts/contributions/144.asp

Here is another good one:

http://www.databasejournal.com/features/mssql/article.php/1461661

I hope Yukon will offer more.  This seems like it would be a common problem.

Thanks for the links.  I will check them out.  I got a script from SQLTeam that works:

Select

[LName] =

case

when charindex(' ', Col001) = 0 then Col001

Else...

Sorry.  I guess the code tags did not work.  By the way, the last record has 5 elements.

SELECT

 Column1 =

  CASE

   WHEN PARSENAME(REPLACE(Col001, ' ', '.'), 4) IS NULL AND PARSENAME(REPLACE(Col001, ' ', '.'), 3) IS NULL THEN PARSENAME(REPLACE(Col001, ' ', '.'), 2)

   WHEN PARSENAME(REPLACE(Col001, ' ', '.'), 4)...

SELECT

 LName =

  CASE

   WHEN PARSENAME(REPLACE(Col001, ' ', '.'), 3)

   IS NULL THEN PARSENAME(REPLACE(Col001, ' ', '.'), 2)

   ELSE PARSENAME(REPLACE(Col001, ' ', '.'), 3)

  END,

 FName =

  CASE

   WHEN PARSENAME(REPLACE(Col001, ' ', '.'),...

Thanks!  This seems to work also for the LName but I may be making this harder than it is:

SELECT SUBSTRING(Col001,1,LEN(SUBSTRING(Col001,1,CHARINDEX(' ',Col001)))) AS LName FROM table

Yes.  I do alot of my data scrubbing in Excel but Excel is limited to 65,000 lines.  I need to do a couple of million records.

Raw Data

Col001

AABY TAMARA J

AADNESEN MARJORIE

AARANT MAUREEN R

AARON MICHELLEE

AARON PATRICIA J

ABBA DAVID W

ABBATE ANTHONY P

SELECT SUBSTRING(Col001,1,CHARINDEX(' ',Col001)) AS LName,

SUBSTRING(Col001,CHARINDEX(' ',Col001)+1, CHARINDEX(' ',Col001,CHARINDEX(' ',Col001)+1)-CHARINDEX(' ',Col001)+20) AS FName,

REVERSE(SUBSTRING(REVERSE(Col001),1,CHARINDEX('',REVERSE(Col001)))) AS MName

FROM table

Gives...

Yes.  I have found a few UDF that will split the field but I need something like this:

SELECT SUBSTRING(Col001,1,CHARINDEX(' ',Col001)) AS LName,

SUBSTRING(Col001,CHARINDEX(' ',Col001)+1, CHARINDEX(' ',Col001,CHARINDEX(' ',Col001)+1)-CHARINDEX(' ',Col001)+20) AS FName,...

Thanks Frank, David for the suggestions!