Search results for query: *

That is why I was a bit confused with Steve's post. He says "...and then disable NIC 2 on server 2." I figured it was because I wasn't clear with my initial post that the cross-connect was between the NIC 2s on each server. Mike

Thanks for the response Steve! Before I go messing with my production server, let me make sure I get this right. SERVER 1 (Main) NIC 1 IP 192.168.1.1 Subnet 255.255.255.0 NIC 2 IP 192.168.1.100 Subnet 255.255.255.0 Server 2 NIC 1 IP 192.168.1.2 Subnet 255.255.255.0 NIC...

I am trying to create a reporting server. I have 2 hosted servers (windows 2003) each with 2 nic cards. I am trying to setup the cross connect between the two so I can sync data directly. Can anyone help with how to set this up or point me to some resource on how to do this? The two servers...

Alex, The latest worked like a charm. Thanks for the help and a fine example of how to write a query of this type. Mike

Thanks Alex! I will give it a try when I get to work tomorrow. Mike

I need to generate a report with the top 3 zip codes by Location. My tables are Location, Customer, and Address. I have a Select statement like this: Select l.name, a.zip, count(a.zip) as count From location l inner join customer c on c.locationid = location.id inner join address a...