I've always asked what the hours are and what's expected. Someone should formally admit to what they want. Anyone that "hints" at more than what they'll officially say is being...

Ralph,

Hope it gets better and smile, tomorrow's Friday

Matt, thanks for the licensing update. Missed that one.

My friends are using 16GB of RAM and dual quad cores, over allocating the physicals. So they might have 32GB of RAM...

go dowload Log Rescue from Red Gate (I work for Red Gate). It's free and it will read the logs and give you the reversing statements.

I don't think it's a big hit, but I agree with Gail's issue with naming conflicts.

I'd avoid it, script out the procs and make the changes, You could even...

DO NOT RUN Allow_data_loss. It's results are completely unpredictable and the storage engine team does not recommend it. They'd like to remove it.

Call PSS if this is a production database...

You need shell access, xp_cmdshell, or use a job and give rights to start the job.

I'd actually set up a job to check a small table, look for 1 ,...

Make sure it's indexed.

Try to remove the functions from the WHERE clause somehow, maybe add a computed column. Avoid the , that causes a complete table scan. Think about...

you can't do this. The 64-bit edition requires a 64-bit hardware architecture. 32-bit requires a 32-bit architecture, but a 64-bit Windows installation includes an emulator.

You can't stuff 64-bits into 32...

Either you use times or you don't. It can't be everything up to 23:99 unless I enter something else.

If you want everything up to midnight, you can use < @enddate,...

Set tempdb so it doesn't need to grow. Look at what the peak size appears to be, add a slight pad, and size it there.

You could have orphaned users (no mapped login). Run sp_change_userslogin to see what the issues are. Look up the report switches in books online.

You haven't asked a question? What do you need help with?

What would you do? Show us that you have made some attempt to figure out what should happen, and that...

How do you run the stored procedure? You can set alerts if jobs fail and have those send emails.

I think the important thing to remember with VMs is that they're not the end-all be all, and implementing VMs doesn't mean implementing them for all servers. If you have...