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.

I actually need to write something about this, but here's what I know.

1. This has happened for years in the US. But not to other countries, to lower cost US...

I agree with Denny. Opening 1433 to the Internet is a bad idea. At least redirect it, but preferebly limit this to VPN access only.

Yes, each can use 2GB, but you need to save some for the OS, I'd say 500MB or so, so really 1.7GB or so per instance.

And you should set the...

And what kind of monitoring do you need? Have you looked at Profiler?

load from file: EM, right click DTS, select "open"