Here is another conversation with a sample script that might help:

http://www.sqlservercentral.com/Forums/Topic452358-148-1.aspx

When installing...

Are you using a send mail task inside the package or an execute SQL task?

SQL will take what it needs up to the max you specified (18GB). I have watched when I restart my SQL servers and noticed it takes about a day before...

You have the server at SP2. Did you apply SP2 to your workstation to upgrade your client tools? Google doesn't provide any further feedback, unfortunately.

SSIS is required for maintenance plans. Is it installed and running?

Based purely on the text of the question and the text in the link, the correct answer IS yes.

Interesting find here, when I run a SELECT RAND() on my servers,...

Check the surface area configuration to make sure that database mail is enabled on this box.

We were told by Dell that ALL services and applications that might have files open must be stopped and closed before the P2V process. The only exceptions were core windows...

Since this will run in the context of the SQL Agent user account, make sure that user has appropriate rights.

GSquared (7/24/2008)

---

Is it possible for you to add an identity column to the table, without breaking the rest of the code?

If so, then an insert trigger could update the column...

Wayne West (7/24/2008)

---

I forgot another comment that I meant to reply to. Some costs can be hidden and quite high: a lot of the servers sitting in your rack...

Shaun McGuile (7/24/2008)

---

Ah guys sorry I don't get the question about moving from virtual to physical servers....I'm not a network admin. 😉

Can someone state the issue - are you gonna...

Charles Cherry (7/24/2008)

---

Our state is moving to virtual servers at a very fast pace. So far they have virtualized about 150 servers, many of them production SQL servers. They have...

Load testing? What's that? 😀

Seriously, we didn't do...