From BOL.

"How to perform an edition upgrade within SQL Server 2000 (Setup)

To upgrade a SQL Server 2000 installation to a different edition of SQL Server 2000

Insert the Microsoft® SQL...

What application does the database run for, SMS?

The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the...

If you have transaction log backup files and tools to examine the log file, you can do it. See http://www.lumigent.com.

Suggest you set your databases transaction log file grow automatically, backup the log regularlly if your databases need to be backed up for up to point-of-time recovery. If there is...

The updatedate column in syslogins should tell you when changes has been made to the specific login.

Which columns are used to create index(callwhen)? An index created on columns callnbr and callwhen should be used.

From BOL.

Table Hints

"Caution Because the query optimizer of SQL Server usually selects...

The information in sysperfinfo is actually same as what you see from the performance monitor.

http://www.sqlservercentral.com/columnists/jsack/troubleshootingsqlserverwiththesysperfinfotable.asp

Yes, It is Windows security log. Thanks again.

Check your server's network card and network configuration.

Only 2GB can be used by applications (Non-system processes) if 3GB is not enabled. After you stop another instance, you may have to wait for sometime before you see the...

Maybe you could try to create the new file and append the content of another three files into the new file.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsmthopenastextstream.asp

Maybe some VB Guru can follow up this.

Edited by -...

This is syntax. DBCC checkdbts (dbid, newTimestamp)]. Can't find anything else from the Web.

Why do you need that?

Edited by - allen_cui on 09/12/2003 08:47:30 AM

Check your SQL Serevr errorlog for any related error messages before taking any actions.

Thanks for the help, Anyway. The problem is we really have no control how many columns the records may have. It is generated when we dump the event security log...