Firewall is the next place to look..

CEWII

Yes, I ran into this kind of problem before. On the remote end check to make sure that Network DTC Access is allowed, I'd probably look at another server...

Database Mail uses service broker so it needs to be enabled, this has been true since SQL 2005. I believe but am not sure that Notification Services in SQL...

I don't know if I agree Paul, my policy is that ALL databases are owned by sa and that no one should have the sa password. I don't ever...

I've been burned by this little problem before.. It makes it easy to remember..

CEWII

I have a question first. Has the connection EVER worked between them? Not just timing out but connections in general or ones that change some data?

My first though would...

You might try RTRIM..

CEWII

I'm guessing embedded spaces. The lookup is VERY sensitive to this and it drives me crazy.. Filter out the spaces before the lookup because they are probably not...

spenn6367 (1/26/2012)

---

arr.nagaraj (1/26/2012)

---

couldnt understand your question exactly.

On Node A you have Default instance ( VirtualServername1) and Node B you have named instnace (VirtualServername2\instancename). You want to connect to...

In Administrative Tools you'll...

That is quite odd. Considering that the users are stored at the database level and not the server. If it is indeed the same server it was restored...

Steve Kumbsky (1/26/2012)

---

I've come across a sproc in our system that does transactional calls to a linked SQL server. This all works fine, but the code is very messy, is...

Link here: http://www.sqlservercentral.com/Forums/Topic1242328-23-1.aspx

CEWII

For staging tables? Typically I include a primary key just to be sure I have unique data or at least a unique reference to a single row but I...

Koen posted a link.

I would do it through a stored procedure. I am guessing you don't have much experience with Service Broker, I would go through that link and...