Have you configured replication on SQL Server? What is the result of SELECT @@VERSION

You can create indexes on Temporary tables and place TempDB on a separate filegroup/drive for performance.

Not exactly sure about your question, but :

SELECT fulltextcatalogproperty('Catalogue_name', 'PopulateCompletionAge')

Returns the difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00.

This can be manipulted...

DBCC SHRINKFILE

DBCC SHRINKFILE

    ( { file_name | file_id }

        { [ , target_size ]

            | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ]

        }

    )

EMPTYFILE

Migrates all data from...

I know for sure that if BUILTIN\Administrators is removed Full Text Search breaks - becuase it always uses Local System Account. It cannot query remote servers. If SQL Server and...

I think the problem occurs with only with AWE enabled, because /3GB switch is for Widows User mode address space enlargement and AWE is specific to SQL Server. But there...

Can you give some more details about the job which fails with this  error. Also what is your Service Pack level? I would like to know the results for SELECT...

BuiltInAdministrators can be removed but it is not recommended (esp. on the cluster) - it can cause SQL Server or Agent Not to Start.

Sorry, I forgot - U will have to setup log shipping again, after deleting the current log-shipped copy of the database.

Don't apply SP4 if you have eanbled AWE.

http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx

http://support.microsoft.com/?kbid=899761

****IAM page (4:62991) for object ID 2073058421 is incorrect. The table ID on page is 413960551; should be 2073058421. The entry in sysindexes may be incorrect or the...