They can claim anything. You could dispute it, but they might be able to narrow the definition to back up their claim.

What's the worlds largest database? Disk size? Rows? Trans/sec?...

There used to be issues with knowing the proper device sizes in 6.5 for some restores.

How is the server dying? Can you not add disks? That might be the easiest...

Please don't cross post: answered here http://www.sqlservercentral.com/Forums/Topic493712-19-1.aspx?Update=1

Not really. You could save each package as a VB file and search them or you can open each one.

Is this occurring in SQL Server? It looks like an Oracle error is bubbling back through.

My guess is that the create is getting sent through to Oracle and so it...

Go get the Management Studio express and install that. http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en

Then you can see the databases listed.

Red GAte's tool (I work for Red Gate) only does databases, not servers.

ApexSQL has a doc tool, and there are a few more (SQL Scribe, etc, search SQL Server documentation...

First, do not type in all caps. It's shouting and rude.

Second, it's a temporary table. Using the incorrect verbage can confuse people.

Third, what doesn't work? what does "well" mean? Please...

I'd still be wary, though find out what's happening. The Volume Shadow Service, VSS, is supposed to work with SQL, but people have reported issues with it.

Not sure how well...

If this works, I'd do that. I have had issues at times with conversions and needed to go to the datepart function to get things to work.

select datepart( yyyy, datefield),...

There is a great XML series on this site by Jacob Sebastian. You might want to check it out and see if there are techniques in there that can help...

test, test, test.

Throw a load at the SQL Server, snap it, and then see if the other side is useable. There's always chance for an issue, but if you can...

Grant and Luke have good advice. I'll add one more: update your resume.

You might be the fall guy if this fails.

I'll pull for you and wish you good luck. There...

That's not the worst plan, although it things don't work you'll have an extended outage while you remove 2005 and reinstall 2000.

Be sure you keep backups of the 2000 databases...

SUBSTRING and PATINDEX/CHARINDEX can split things out, but you need to have some sort of pattern.

Also, if there are a variable number of items in the 2nd column, there's no...