Did you have chance to read the discussion in the following link?

http://www.mcse.ms/message1461870.html

May it help.

Did you try to set DTC (Distributed Transaction Coordinator) in MS SQL between servers?

You may have a FULL backup and remove all transactional backups prioir to the FULL backup. However, in this case, you will not be able to restore to the point...

You should not lose any information on security, such as logins and users, if you have right backups.

I cannot see any potential issue but one point why you need both transactional backups and differential backups.

It has nothing wrong for a user to access SQL Server using a domain account if the server is not a production server. You can set permission to his/her account...

You may try to OPENROWSET to connect your EXCEL. Make sure your connection string is correct (Is there one extra back slash '\"?).

You may try to use udl to generate...

You may try to run

DBCC CHECKDB

to see what error you have and decide what you need to do next.

If you use SQL 7, you may try to expand your data...

sp_dbcmptlevel 80

There are two diferent approaches to remove duplicates as far as I know.

1. Retrieve distinct data into a new table, drop the old one, and rename the new table.

2. Create...

I am not able to try to answer your questions one-by-one. But the following link may help.

http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx

Personally, it is a very good one from my personal point of view.

How about

select * from [linkedServer].[dbName].sysobjects where xtype = 'u'

I came acroos the same issue before.

Check whether or not you are the only person to have this issue.

Try to see whether or not the server and your client...

I believe that QA uses the same protocal setting as EM. We can set it in server/client network utilities.

DBCC TRACESTATUS(-1)