Barry, we'll miss you. Between Grant and I, we'll raise a few.

Note that I'm not recommending Hyper-V. I'm not sure it's any better, or any worse, than other software. I have seen VMware used heavily, and it seems to work well...

Jack,

Good points and I do think we need to remember it's the Summit. In the past, PASS (the organization) has not offered much more than the conference.

I don't see PASS...

Have you enabled logging? Are you using the paths for backups set by SQL Server, or have you created your own folders? Have set security correctly for the SQL Server...

Do you mean that if I have a proc

create procedure myproc

as

exec p1

....

return

and I somehow create table from the execution of P1? If so, no, I don't think this can be...

I've added my vote. I'm not sure I'd add it to the current output, but it would be handy to have another property added.

CU6 was released last week. It stands on it's own.

you can't easily do this. If the procedure returns result sets, you need code specifically in there to create the table. I cannot execute a stored procedure, get multiple result...

What have you tried?

If the tables exist

insert table select field1, field2, from othertable.

If you need to remove selected rows, do it in batches. You can switch to simple mode, delete 1000 or so rows, repeat, and then switch back to full mode....

You need three arguments

http://msdn.microsoft.com/en-us/library/ms189794%28SQL.90%29.aspx

Use Books Online.

Are you allowing UDP 1434 through? Or is the SQL Browser working? Those are used to resolve the port.

look up

select...into

This task will work for you. a few things to check. Do you have files that are older than that date? Are you sure the paths in the task are...

You cannot do this. If someone is an administrator on the machine, and they have control of the environment, they can possibly get in.

You can make it more difficult. You...