I believe it is a default instance.  There are no other SQL Servers installed on that maching and I only needed the name of the computer to register it.

Now I'm embarased to say I haven't actually bought it yet, a coworker of mine did and I am reading hers right now.

But I do have the previous one signed...

Thank you! 

I had to take a double take when I noticed your signature and it was for the book that I am currently reading and then found your name...

I'm getting a little farther now.  Thanks!

Now I get this error:

Executed as user: DomainName\administratoraccount. The package execution failed.  The step failed.

And the account it is using is an sa.  Its...

I have tried using the CASE function in the expression area and it never accepts it plus the CASE function is not listed as one of the functions that can...

As I normally do, I keep looking for a solution after I post here and I just found something I did not expect in the remarks for the REPLACE function...

You could store the count of all the rows that will be processed by the cursor in a variable.

Then use another variable as a counter and increment it...

Thanks for all your replies.

The problem is this server crashed a couple days and because we were told to get it up as soon as possible all the checks that...

Thanks!

You can control locking to a certain extent using locking hints. This might not do what you expect and you need to read up on the various hints so...

Any job that will allow me to work from home 2 to 3 days a week will get my attention. My current job refuses to let me work even...

Thanks!

Oh, I agree derived tables are useful, but in this SP they don't work since there is so much data that the entire derived table won't fit in memory.

The example...

OK, we now have two SQL Server 2005's with Integration Services installed.  Can I access both of them from one server?  I just tried and it wouldn't let me change...

OK, I found it and got access to it.  Is there anyway to register it like you do the database engines?