You can backup the files with a password, although it is not very strong. There are third party backups (Quest, RedGate, etc) that will encrypt the backup.

for the MDF, I'd...

I guess I have been seeing a lot of woman as DBAs. And she got top billing!!!

Green Lantern, that was probably about you

Mostly a locking issue. It's better than before and I haven't done any large scale development since early ss2k, so I might revise. Used to see too many "intermediate" results...

Good for you. I always ask about the negatives. They certainly will come up later.

Wow, that's a lot of databases. How many DBAs?

Sorry, try to catch those. It's been reformatted to fit better.,

Apologies to all. No idea what happened when I posted this.

Maybe I was running

select sin(confused_DBA(annoymembers()))

Is this SQL Server 2000 or 7?

Ah, but I'd put it up on my desk. Maybe a nice 30 incline to it.

Are there backup files from this server in there? From my testing it appears that this command will actually check to see if these are valid backups by running a...

CREATE PROCEDURE u_GetWeekNo

@ARG_CheckDate Datetime,

@ARG_WeekNo Integer Output

AS

select @arg = datepart( wk, @arg_checkdate)

return

I thought this one would be interesting

If you can connect to the other server, you can just do a save as on the other server as well.

Ah, but the question asked about AWE. The /3GB switch does not enable AWE, but moves the partition for the kernal to allow an application to use 3GB while reducing...