SQL Server creates and executes a parallel plan for a query only when the estimated cost to execute a serial plan for the same query is higher than the value...

Check BOL "Using the inserted and deleted Tables"

Index ID 255 indicates there is a text/image column in the table. It maybe corrupt.

bcp sysindexes out

truncate table sysindexes

bcp sysindexes in

Before you do that, backup your database and set direct...

If you can run dbcc dbreindex, run it to your tables and then shrink the database. One of difference is that DBCC INDEXDEFRAG is online operation and DBCC DBREINDEX will...

Just wondering, Did you refresh the databases from EM when you saw database was in 'loading' status?

Create new database with same name, stop SQL Server, replace the MDF file from original database file and restart SQL Server to see whether your database is back in suspect...

What precentage free spaces do you expect after the database shrink? It shrinks the size of the data files in the specified database to desired percentage of free space left...

http://support.microsoft.com/default.aspx?scid=kb;en-us;841401&Product=sql2k

Backup log to a share folder which can be accessed by both servers using UNC path.

backup log pubs to disk = '\\servername\foldername\pubs_log_20040610.bak'

SELECT * FROM db1.dbo.UserObject WHERE u_logon_name NOT IN (SELECT * FROM db2.dbo.UserObject)

SELECT * FROM db2.dbo.UserObject WHERE u_logon_name NOT IN (SELECT * FROM db1.dbo.UserObject)

What service account do you use to run SQL Serevr and Agent services?

Try to grant Windows NT group/user 'DTSRV\ServiceSQLServer' to access SQL Server with proper permissions. Or change the job...

Use performance monitor to see how I/O subsystem performs when both SQL Server and Exchange are busy, also CPU and memory resources. That will give you ideas whether you should...

http://support.microsoft.com/default.aspx?scid=kb;en-us;841394&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;841251&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;841252&Product=sql2k

sysreferences table contains mappings of FOREIGN KEY constraint definitions to the referenced columns and OBJECTPROPERTY returns information about objects.

select "select ObjectProperty(OBJECT_ID('" + object_name(constid) + "'), 'CnstIsDisabled')" from sysreferences will generate...

SELECT TOP 10 used AS "# of Pages", rows AS "# of Rows", (used * 8) / 1024 AS "# of MB", object_name(id) AS TableName

FROM sysindexes WHERE indid...