Kevin,

Can you post the schema and indexes for the tables CommunicationEntry, Customer_Address, and Address please?

kinderdesign (8/29/2012)

---

Most columns are identical and this is what I'm traying to make a report of. Is there a way to grab all current tables in the db with...

Sqlism (8/29/2012)

---

Thanks everyone this topic really really helped me a lot.

I installed management studio on my desktop and my other dba's desktop, we successfully connected to named instance,

so by this,...

Sergiy (8/28/2012)

---

In my opinion it happened long before my involvement. I tried to bring attention to it while clarifying your confusion...

Nadrek, I agree that poor hiring practices for local departments can get unqualified or semi-qualified people into local IT positions (for example, what does a doctor really know about a...

Barkingdog (8/28/2012)

---

In addition to our Microsoft Sql Server farm, I’m responsible for the Admin of our SharePoint and TFS farms, writing SSIS packages, query tuning, converting old COM+ objects to...

You would need to check if it's running in services. RDP to the box, Rt-Click on "My Computer",...

Quite correct, this conversation took a left...

Sergiy (8/28/2012)

---

Evil Kraig F (8/28/2012)

---

*scratches his head* Out of curiousity, you realize these are other people you're talking to, not your drinking buddies who don't take offense to your constantly...

Hey folks! Need some administrator backup, it's been at least 2 years since I've argued with install issues outside of my personal box.

http://www.sqlservercentral.com/Forums/Topic1351321-391-1.aspx?Update=1

Friendly enough feller and I've hit the...

Yeah, check the last value, it should...

One down... 🙂

Does each SQL Server listens on different port numbers?

for example: default on 1433 and named on something...

Verify that remote connections for the instance are set to on, and double check the listener on the server that the instance is listed. I think Gail's wild guess...

Agreed, need the error to help here. There's a few dozen things it could be.

As a troubleshooting test, can you load a copy of the database itself (not the SQL table side, just the access one) onto a user's system and see if their...