Tag: sql-server

Using DTS Import

Using bcp -out and use bcp -in to insert the data into the new SQL 7 Server

Use the DTS Export

Using bcp -copy, copy the data from the SQL 6.5 Server to the SQL 7 Server

Both A and B

Rebuild Master database

Edit registry

Run regrebld.exe

Restore registry from backup

TCP/IP

Unix Command Protocol

Multiprotocol

Named Pipes

DBCC CHECKDB

DBCC NEWALLOC

DBCC CHECKALLOC

DBCC CHECKCATALOG

All committed transactions that are in the transaction log

All uncommitted transactions that are in the transaction log

All committed transactions that are in the transaction log between the last checkpoint and the failure

All committed transactions that are in the transaction log between the last two checkpoints

Run the stored procedure set query governor cost limit.

Modify the configuration parameter min memory per query.

Modify the configuration parameter show advanced options.

Modify the configuration parameter query governor cost limit.

Both C and D

C:MSSQL7LOGERROR.LOG

C:MSSQL7ERROR.LOG

C:MSSQL7SQLSTP.LOG

Windows NT Event Log-Application Log

Windows NT Event Log-System Log

When the xp_logevent stored procedure is invoked

When sp_addmessage or sp_altermessage define errors to be written to the NT application log

When SQL Server errors occur with severity levels between 19 and 25

When the RAISEERROR WITH LOG statement is executed

All of the above

SQL Server Enterprise Manager

SQL Server Transact

SQL Server Network Client

SQL Server Query Analyzer

Both A and D

Replication management

Job execution

Notification

Alert management

All of the above