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

Thanks and we'll consider this. Sometimes it adds a lot of work to explain or create references for wrong answers, but I'll see if I can get better.

Robert,

Congrats on the new job!

I definitely fight that lack of people. My wife is usually here, but weeks like this one, where she's gone all week, are lonely and hard...

Comparisons usually require a line by line marking and T-SQL isn't good at this.

Word does this if you select the "Track Changes" menu item. This works pretty well and you...

You should get the Express Edition of SQL Server with VS and I don't think it includes SSMS.