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

I assume your dts package (dts2000 ?) is trying to send a mail, but it does not succeed. Hence "NOTE: Failed to notify 'HELPDESK' via email."

Check your account that serves...

can I have a go ?

Since I try to avoid hints ...

how about ....

-- just a copy from your initial #empshifts

insert #empshifts2

select * from #empshifts ;

--now set up...

with SQL2005 osql and isql have been replaced with SQLCMD.

If you cannot alter the software to use SQLCMD, I guess you'll need an SQL2000 client install (or msde) to get...