The " dbcc inputbuffer" (with the proper syntax, which is to pass the spid that identifies the process that is running) should return the last statement that ran on that...

select case when a.key is not null and b.key is not null

  then 'both'

case a.key is not null

   then 'ReservesFile'

case b.key is not null

   then 'Temp'

 else -- not sure...

Hmmm!  SQL 2000 Enterprise Manager would sure save time.  I don't have Management Studio Express, but I don't think that it has the import wizard.

Can you create an Access database with linked tables...

You call the import wizard from SQL Server Enterprise Manager.  This tool (which is a client tool for SQL Server 2000) allows you to manage the databases, etc.  The import...

To answer your immediate question:

A case when statement must be of form in your condition:

case when <condition> then <value>

when <condition> then <value>

else <value> end

The point is that the whole...

 Are you just moving the data?  You can use the import wizard to create a DTS package for SQL 2000.  You first do the import to a test server from...

You need to cast the floats as decimals:  convert(decimal(18,9),mycol).  Use a sql query for the source.

If you want to position yourself as a SQL 2000 guru, then maybe MCDBA better.  Also, MCDBA includes a Server operating system test the MCITP does have, which may interest...

Another trick is to delete a section.  Say you want to delete all records before Jan 1, 2006.  Create a loop

declare @date datetime

set @Date = '1/1/1960'

while @Date <= '1/1/2006'

 begin

   delete...

I am going to assume that the first and second questions are related:

create proc myproc @key int

as

-- Second question (count)

declare @numRec int

select @numRec = count(*) from MyTable

where myKey...

Try:

if DTSGlobalVariables.Parent.Tasks("DTSTask_DTSDataPumpTask_2").CustomTask.RowsComplete = 0 then

Under what conditions does the task run?  You can set up a workflow from the datapump to this task.  You can state that you want the routine to only when...

Be sure to get the name of the task not the step.  They are different.  "DTSStep_DTSDataPumpTask_2"  looks like a default step name not a task name.

You can get the TaskName...

It should be DTSGlobalVariables.  I am not at my work machine with all of my DTS packages.

function Main()

if DTSGlobalVariables.Parent.Tasks("MyExcelTask").CustomTask.RowsComplete < 20 then

' 20 or some other threshold

  Main = DTSStepScriptResult_DontExecuteTask

else

 ...

I'm not certain.  Is the bat file on a network drive and do you refer to it using a mapped drive letter (this may cause problems)?  Does the Win32 process have...