In SQL Server 2005 and later version, you can use sys.dm_db_index_physical_stats to query size and fragmentation information for the data and indexes. http://msdn.microsoft.com/zh-cn/library/ms188917.aspx

In SQL Server 2000, you could...

You need to know workload characteristics when deciding which tables to compress, please could read following article.It provides some guidelines to assist in deciding what to compress.

Data Compression: Strategy, Capacity...

found one article about error "Access to the remote server is denied because no login-mapping exists", please check whether it is the same scenario with yours.

http://blogs.technet.com/b/mdegre/archive/2011/03/10/access-to-the-remote-server-is-denied-because-no-login-mapping-exists.aspx

You can use Foreach Loop Container enumerate these files and save file path to Variable then deal with these file. Remember to move these files to other...

Microsoft SQL Server distributed queries can be used to query data from the Exchange Web Store through OLE DB Provider for Exchange and can be joined to tables in...

check the restore job history and there should be some useful information.

you can write a sql script to backup and clear backup files, then in schedule task, use sqlcmd to call this script.

Can you post a demo how did you run the exe or application, then i could simulate on my server.

Have you tried DTCPing tool, the log could show more DTC info:

http://blogs.msdn.com/b/distributedservices/archive/2008/11/12/troubleshooting-msdtc-issues-with-the-dtcping-tool.aspx

By the way, could you query each other successfully with Linked server?

SELECT ps.name AS PSName,

dds.destination_id AS PartitionNumber,

fg.name AS FileGroupName,fg.name,

t.name,

f.name as...

SELECT ps.name AS PSName,

dds.destination_id AS PartitionNumber,

fg.name AS FileGroupName,fg.name,

t.name

FROM (((sys.tables...

Oracle has a SYSOPER privilege allows opration such as:

instance startup,mount & database open;

alter database backup archive log and restore

This privilege allows the user to perform basic operational tasks without the...

Never used peer to peer replication before, but found this article, hope it helps.

http://www.databasejournal.com/features/mssql/article.php/3820361/Peer-to-Peer-Replication-in-SQL-Server-2008-150-Add-a-node-and-resolve-conflict.htm

If you don't want your DBA to view data, you could restrict his permission, not grant sysadmin or database role.

If couldn't then use encryption and audit tools.

Have you configured the DTC in OS? refer to this article:

http://technet.microsoft.com/en-us/library/cc753620(v=ws.10).aspx

SQL Server use MS DTC to control coordination of transactions .