dts supports a number of different connection-objects, provided by the dts-environment itself.

e.g. oledb / sqlserver / text / odbc / access ...

open dts and create a new package :  you'll...

you could fall back to the windows scheduled tasks  and use SQLCMD to execute your backup commands

Like many of us, you'll get in troubles when using system-objects other than INFORMATION_SCHEMA.

Make the effort to adapt to INFORMATION_SCHEMA-use.

You can stil use the sys.sysobjects stuff. So...

Are you looking for set deadlock_priority low ?

This way the executed statement is prefered victim for deadlock handling.

you could off course always select 50 columns

e.g. set @sqlquery = 'select yourcol1, yourcol2, null, null, null,... from yourtabel '

I guess you can alter the system-db's dblevel without a problem.

You'll also notice the (db) reports for e.g. space usage, will not work, but give you an errornotification that the...

Did you find a solution ?

I'll be out of the office until 01/25

So, how does your logshipping work ?

Did you build you own backup\restore cyclic procedure ?

Maybe this script can help out.

It's meanth to generate a script to restore a sequence of...

you should be able to start the correct sqlagent job to invoke the replication cycle to get them back in sync.

This should work automaticaly if you have setup logshipping.

Check BOl for "log shipping, overview"

Check your server's sqlagent if the jobs have been or are running ...

As always, there is no straight forward in  a relational environment

If you use it in a well-considered way you'll gain from it, else...

just to add to peterhe's reply :

1) connection pooling works for the full connection string. and must match each and every bit...

If you have it captured to file , save the file to a sqlserver and launch queries against that table.

This way you have a quick overview of your large consumers...

did you use sql-profiler to look what's going on ?

offcourse .... your previous reply got me back to hinking ....

use yourdb

go

DECLARE @TableName nvarchar(261)

DECLARE @SQLStatement nvarchar(4000)

DECLARE TableList CURSOR LOCAL FAST_FORWARD READ_ONLY  FOR

SELECT

    QUOTENAME(TABLE_SCHEMA) +

    N'.' +

    QUOTENAME(TABLE_NAME)

FROM

    INFORMATION_SCHEMA.TABLES

WHERE EXISTS

    (

   ...