For implicit transaction, SQL server needs to write transaction log to disk (or powered disk cache) for each INSERT statment.

For explict transaction, SQL server can potentially have one I/O...

It's upto what provider you use. If you use SQLOLEDB, you can give any legal SQL identifier as the server name. E.g.:

exec sp_addlinkedserver 'MyLinkedServer1', '', N'SQLOLEDB', 'SQL Host/Instance name',...

In msdb system tables, there are bunch of tables prefixed with log_shipping. Check BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f8910aae-2013-4645-880c-134577cbcbe0.htm for details.

If you don't use dynamic query, I don't think you can you use parameters in the FROM clause in any part of the four-part name, like server1.myDB.dbo.MyTable.

Linked server name is...

I don't think SQL server 2000 truncates the transaction log after a full backup. You need to run BACKUP LOG command explicitly both in 2000 and 2005 to truncate tran...

1) This sounds a bug. The "Automatically remove agent history checkbox and set the time delay" is not set as an agent property. Check the set agent properties system SP...

The subject heading is truncated. So we don't know the questions exactly.

In the readme file (http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm) of SQL 2000SP4, there is a section (3.5 and 3.6) that describes how to install SP4 on replicated database. Check 5.2 also, SP4 has...

First of all, check how much space is really used in the log file, you can do this in enterprise manager->your database (in collapsed mode)->view->taskpad

If most of the space is...

In your script file, you need to have batch terminator "GO". You can have only one "create/alter procedure" etc in one batch

Then in your asp code, read one batch a...

Mark is right. I checked my machine. It turned out that IT department rolled out windows 2000 SP4 recently in our network. The SP installed the latest version msjet40.dll and moved...

And just a reminder, if the file path has spaces, you need to use double quotes for the whole path and file name.

I remember I could not access remote excel file by linked server or opnedatasource/openrowset before. But after I installed the pre-requisite (latest MDAC) of SQL 2000 SP4, I can do...

SQL server has a builtin\administrators account. When connect to SQL server by windows authentication, all administartors of local computer will map to this sql account.

So you can logon your computer...

If you are using express, evalution, or developer edition, the remote connection is disbaled by default. In surface area configuration, go to service and connection--> remote connections, select "local and...