Very basically a deadlock occurs between two threads when each thread requires a resource that the other thread owns. Therefore both threads are effectively waiting on each other. Blocking is...

My bible for DTS is SQL Server 2000 DTS published by Wrox. I also have the DTS object model poster that Lumigent produced.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original...

Error 1114 indicates a DLL failed to initialize.

Try re-installing MDAC, or maybe re-registering ODBCJT32.DLL

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Take a look at the following topics in Books Online,

"SQL Server: Databases Object"

"Checkpoints and the Active Portion of the Log"

"Transaction Recovery"

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and...

Take a look at the links I posted in response to your other post,

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16581&FORUM_ID=9&CAT_ID=1

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

xp_sendmail relies on MAPI, which is installed with Outlook. And yes when you install Outlook you will get an icon in Control Panels.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original...

The nicest way is to let the other process complete whatever it's doing

The nastiest is to issue the KILL command to terminate it

What about running Profiler and Perfmon to monitor whats happening on the server when the problem occurs. This will hopefully enable you to establish some sort of pattern as to...

Sounds like a task for some sort of resource kit utility. I know there was a utility that performed this sort of task in NT. Not too sure about W2k...

Can you provide an idea of what your table structure and indexing looks like?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Your question isn't that clear, are you trying to connect to the database from SQL Server in a DTS package?

You'll need to create an ODBC Datasource connection to the Visual...

To use global variables in the SQL statement of an ExecuteSQL task, put a ? for each parameter required, click the Parameters... button and assign Input parameters as required.

Hope this...

Have a read of the following, it may give you an idea of what is wrong,

http://msdn.microsoft.com/library/en-us/dtssql/dts_pkgmng_sec_09dl.asp?frame=true

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Try this,

SELECT a.name, a.current_execution_status

FROM OPENROWSET('SQLOLEDB','<your server>';'< sql login >';',sql password>',

   'SET FMTONLY OFF EXEC msdb..sp_help_job') AS a

WHERE a.current_execution_status = 1

This will not work...

I've modified your script so that it changes the table name as well as the connection properties. You wil need to put in the name of your datapump task where...