probably access via cmdshell is prohibited.

I've seen installations that raise a system error and log it into an audit log.

Contact the sysadmin(s).

since these logbackups start...

as stated in your OP, DTA does not support SQLExpress !

So you cannot use DTA with an SQL2005 express edition instance.

I have the impression you would like to use a "general code table" kind of table to keep track of your "sequencenumbers".

That might work, but keep in mind you may...

can you post the results of this query ?

select BS.backup_start_date

, BS.backup_finish_date

, BMF.physical_device_name

--, BMF.logical_device_name

, BS.backup_set_id

, BS.media_set_id

, BS.position

, BS.name

, BS.Description

, BS.first_lsn

, BS.last_lsn

, BS.type

-- , BMS.*

from msdb.dbo.backupset BS

inner join msdb.dbo.backupmediaset BMS

on BS.media_set_id =...

2. Resorting tnx log back (t2)

>>> restore log t1 from disk = 'd:\t1.bak' with file = 3, norecovery (tnx backup)

Processed 1 pages for database 't1', file 'T1_Log' on file 3.

RESTORE...

can you set the dblevel to 90 (SQL2005)

Some functions do not work with dblevel 80.

if you use

alter table xyz add mycol int not null default 0

keep in mind to rebuild your indexes afterward because your clusterratio may be horrible !

- search for 'pivot' in the forums at SSC, you'll find some examples.

- you'll need to build your query with sql2000

something linke

select group1, group2,

, sum(case when detailcolumn = 1 then...

I haven't tested that, but if you have all your log-backups, IMO it should be possible.

- Are your trying to connect to a sqlexpress instance ??

- can you post

select @@version

-- or the

select serverproperty('Edition')

, serverproperty('productlevel')

select serverproperty('productlevel')

check BOL

pivot does not exist in SQL2000

You've posted in the wrong forum.

Dynamic sql is your alternative.

my addition....

Indeed, for plan reuse, the line is getting very thin.

regarding security, the gap has not been closed.

- "curse and blessings of dynamic sql" is still valid; I haven't got...

...application retrieves database info...

does your application accept client settings ? Check your client's settings for decimal point. If that is set to comma, it's an application flaw. The application...