For the moment I'm running both at my windows xp sp2 without a problem

I started with the sql2k-personal edition, then installed my 2005...

Thank you for the replies.

For the moment, none of the applications has a specific need for a non-default collation.

The only way we may get into troubles is with our DTS-packages...

Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.

The reason is most of the...

in sql2005 use the xml-datatype

I just took a look at the way biztalk handles it, and they are using a mix of ntext...

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...