http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en

That is interesting. Did you delete and recreate the message (in that line) to eliminate any suspiscious characters?

Check that tempdb is set to authogrow. You can extend tempdb onto another drive if that one if out of space.

Look for long running transactions and kill them, you may...

Which book?

Brian Knight's DTS book (http://www.sqlservercentral.com/columnists/sjones/prodts.asp) talks about dynamic properties a little as does Darren Green's site (http://www.sqldts.com)

I tend to use SQLMail with Exchange in most places, but there are times when I've needed to send mail. I've use the above techniques as well as ASPMail with...

yes, correct!!!

Fingers moving a bit more quickly than the mind

Select * from dbo[.631586971108797504]

The brackets are around the object name. dbo is the schema. I use this when someone names a column "name" or "description" or some other reserverd word.

select...

use a dynamic properties task to select getdate(). you can use datepart to extract the items you need and then format them. The dynamic properties task can use this query...

I suspect you'll need to create a table with a text column to hold the data. Are these individual files? DTS is easy, but you'll need to script something to...

The easiest way to do this is run a backup of the current database.

In EM, right click the "DAtabases" folder and select "All Tasks

 Restore". In the name of the...

Usually this is a mark in the registry that there is a pending opertation. How many reboots have you done? I know in my company sometimes they have multiple patches...

Also, if you are backing it up, then attach doesn't work. You'd want to do a restore. Detach is the way to prepare the database for attach.

I have not heard, but I was expecting to have an SP 4 with Yukon delayed so much. I haven't heard anything about a date yet.

BCP is an old utility. I'm not surrprised it doeesn't work. Can you not map a drive to this locaiton.?

You can use BCP if the servers cannot see each other or DTS if they can.