OK, maybe I'm dim but this confuses me:

"We configured the SQl 2000 client on another server (server b)"

 Do you mean you're using Query Analyzer on Server b to attach to...

The problem with copyrights and patents is that the concept of intellectual property rights is fundamentally flawed.  (In that they are completely unnatural and in no way rights).

As a result...

Ah yes, the wascally wapper pwocedure.

When you have difficulty with multiple outer joins, you can always embed and do a join with an intermediate result set:

FROM tablea a

        JOIN lookuptablea la ON a.key = la.key

       ...

Do a left outer join between b to a on both columns and filter (where ) a.keyfield IS NULL.  You only need the columns from b then in your result set.

It may just be a misunderstanding of the "LEN" function:

create table #test ( a CHAR(10), b VARCHAR(10) )

insert into #test SELECT 'x     ', 'x     '

select len( a ) , len(...

If it's an application that I'm writing, I tend to wrap everything in stored procedures.

I'd use a datamodel to define events and recurrence and also an actual date/what's going on...

Somebody posted a script here using ISQL/OSQL some time ago as I recall.  Try searching for that in the script area.

is it because backup file has an entry for both Database and Log?

Perhaps you want to group and sum?

I've done this before.  It is easiest if it's done in a multi statement proc.  Looping is not necessary though, it's just easiest to stage in temp tables for joining to...

??  That was me being nice... Oh well, back to work leading horses to water...

"The soapbox is now free."

OK.  Ahem... "Consider the lily..."

Yep, security is silliness.  Man's desire to surpass natural law and guarantee things that cannot be guaranteed mixed with his laziness:  Want...

Not sure what your specific problem is, but you may be talking about query analyzer only showing 256 characters of the result.  If that's the case modify max characters per...

if you're writing your own little utility that is only for you and your process (that is you're not passing it on as an aftermarket addon product to this vendor's...

"Sometimes I wonder if I keep on working as database developer/DBA, what kind of future do I have?"

What kind of future do you want? 

If you're saying your boss(es) is...