Is that found in the surface area configuration? Where do i find it?

The Database Engine already accepts remote connections for both TCP/IP & Named Pipes.

This is a MS SQL Server 2005 Exam question but it relates to a similar setup I have here in a Production environment.

I just wanted to see that I wasn't...

Thanks.

So in other words, you only enable AWE when you wish SQL Server to see beyond 4GB RAM?

Is this correct?

By default QUOTED IDENTIFIER IS SET TO OFF.

Are you sure that prior to executing DBCC CHECKDB that this option isn't set to ON?

samasura,

You are way off the radar! The problem is getting SQLSrvB to pass the Windows Account to SQLSrvA to execute queries. If I create a view, how would that help...

I'm confused, what do you mean its service account on SrvA is used to connect to SRVB?

The Linked Server is resides on SRVB that is configured to see SRVA.

I'm on SQL Server 2000. Thanks for that.

Luk,

I find it hard to believe that MS told you to turn off auto stats!

2 things you have mentioned though,

1. You have Developers who have written custom code to perform the...

I had to migrate an SQL 2000 Server to SQL Server 2005. I had Transactional Replication configured with 20 remote Subscribers.

I uninstalled Replication on the SQL 2000 Server, migrated...

Is there any descriptive errors in the SQL Error Log?

Have you actually registered SQLB in SSMS?

How can you configure the Subscriber if it's not seeable with Domain A?

I would start by checking to see if SQLDMOPreArt_TruncateTable or SQLDMOPreArt_DropTable are available in 2005. If not you may have to re-write this application using SMO.

Have you considered using Replication to create your Objects at the Subscriber?

This is available when configuring the Publication.

It appears that your RI requirements, needs & Implemenattion is rather complex, so I would suggest you use another form to copy data rather than use Replication.

I can see you...