No one asks the version of your SQL Server, can you tell that?

Have you tried to drop the user login and re-grant him to access server B.

Use sp_helpuser to see whether the user is in the database and sp_revokedbaccess 'theusernamehere' to remove it.

Which SQL Server version and service pack do you run?

Backup and restore, detach and attach. Be aware of the limitation of database size is 2GB in MSDE.

If you are running non-Enterprise edition, see http://support.microsoft.com/default.aspx?scid=kb;en-us;281574

If you have to upgrade Virtual Servers from SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition, follow http://support.microsoft.com/default.aspx?scid=kb;en-us;314947

http://support.microsoft.com/default.aspx?scid=kb;en-us;305711

http://support.microsoft.com/default.aspx?scid=kb;en-us;218172

Multiple files can be used to increase performance. If there is a single database file, SQL Server would only use one thread to perform a read of database. But if...

quote:

---

Hardware upgrade may be an option. Any suggestions on hardware to handle the situation that has been described?

---

Try this example. Assuming you have branch number as input.

create table Test (branch int, invoice int)

declare @br int

select @br = 1

insert into Test

select @br,

case count(invoice)

...

Your query does join a table from linked server "BRSPPWS1". Please check the linked server setup (Security and Server Option) and ensure the user who you used has been mapped...

quote:

---

Managment has asked the question about failover clustering and load balancing. Can either do anything for performance regarding optmization?

---