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...

Take advantage of more memory beyond the 2GB that's standard in the Windows kernel (32bit)

No offense taken. Just clarifying. I had to go back and reread the question after your post to make sure.

Remember to answer the question and not read beyond or try...

Actually we asked that a series of queries occur within a transaction. I guess we could have specified 3, but given the questions, the answer should be obvious if you...

Thanks for the complements and hopefully this will help some people.

David, you missed it slightly. Early in my career I had a 3 year time frame, looking to gain different...

, Godwin's Law certainly applies to Slasdot.