I was able to setup 3 instances each on there own IP and each using port 1433.

I am concerned about the number of people who have said this cannot be...

I have setup multiple IPs on servers before.

This is the piece I was missing:

Try to use SQL Server 2005 configuration manager for each instance - Network Configuration - Protocols for...

Thanks for the responses, I'll try DBCC log then maybe convice my manager to buy one of the other products.

I was able to discover yesterday that their was a transaction haning with an ABORT?? at the end. I don't understand how this hung because every statement I was able...

So what was the solution in your case?

Did you rewrite your DTC transactions? Or was their more to it.

I don't have any DTC transactions that I know of.

I don't know about other DBA's, but I don't usually let Developers start editing registry entries on the SQL server.

I got this question right, but can someone tell me why a developer would care about moveing a database between systems. It seems to me this is an admin job.

I agree completly with jtshyman. The very first thing to do is make sure that the firewall is a factor at all. It could be something completly different. Moving the...

The replace values are switched around.

'abc.com','123.com'

vs

'123.com', 'abc.com'

I'll second that

I agree, I would catagorize this as SQL Admin.

I'm not sure I understand the resoning for this answer.

Taken from BOL

'By default, this option is set to ON for all databases when using Microsoft® SQL Server 2000 Desktop Engine,...

I am a huge supporter of virusscan on a SQL server, just be sure as suggested above that you exclude the database files themselves.

Our virusscan on that server saved us...

No conflicting information here...

Win2k Advanced Server supports up to 8gb of ram, so SQL server can only support 8gb on Advanced Server.

Datacenter supports up to 64gb

Thanks for the help everyone, I built the page useing my origional idea (Posted in my first message) and everything seems to be working fine.

I had not been aware of...