For starting you could always create a SQL startup proc that sends an email (or a SQL Agent job that does the same when the Agent starts).

Otherwise you're going to...

Check your -erroraction in the event of a problem. I would normally set the script -ErrorAction "stop"

You can use invoke-sqlcmd passing in an insert query to do this or you could use bulk insert.

Here's an example from my blog http://sirsql.net/blog/2011/5/5/checking-database-space-with-powershell.html

You could use PowerShell to grab the contents of the CSV file and update the CMS directly.

Chad Miller's post will give you 90% of the information to do that http://sev17.com/2009/01/dynamically-register-sql-instances-in-sql-server-management-studio-2008/%5B/url%5D

How much memory are you running on your system? What other programs do you have open?

Could just be as simple as not enough resources.

Can you connect via ssms to the publisher (without using the alias)?

Are you trying to connect to a named instance?

What is the error that you are getting when attempting to login?

When you created the logins on the new machine did you use the same SID?

Service Pack 1 is over a year old now and there have been multiple Cumulative Updates since then. You might want to start implementing those in your test environment and...

Download and install the x86 version of SP1, that should get your dll's registered correctly and get you going.

Otherwise, do you know what dll's are not registered correctly?

Check out Sean McCown's recent presentation from 24 hours of PASS where he goes over deploying packages via powershell http://www.sqlpass.org/LearningCenter/24Hours.aspx

Do you have any service packs applied?

Create a varchar(max) variable.

Then insert into that all of your html, including however many tables you need. You can add multiple items, then just use that variable in the...

Are you moving to new hardware?

You can just backup the 2000 databases and restore on 2008.

You're going to want to do this multiple times and perform extensive testing on...

Lynn Pettis (4/23/2010)

---

After catching some interesting posts on the water cooler, I think I have another reason to revoke the certification -- plagiarism. I don't think we can have...