Try this:

select substring('2006-zzzz', 1, patindex('%-%', '2006-zzzz') - 1)

You would actually replace the hardcoded string with a variable or column name.

I just reread what you posted regarding your backup process.  To be sure what is going on,

you use the same filename for your transaction log backup file each day.  It...

My concern with your process is this; If you were attempting to restore to 10:00 AM Thursday due to a hardware failure and your Thursday morning Differential Backup file was...

My suggestion is that we start asking Best to show us what he has done before doing his work for him.  Perhaps then, we can help his to start helping...

I am curious as to why you truncate the log at 10:00 PM.  Are there any jobs or user activity that occurs between 9:00 PM (the last transaction log backup)...

If, in this case, you are always looking for the first 4 characters, use SUBSTRING or LEFT.  I would just use substring: substring('2006-zzzz', 1, 4)

right here:

Select count(*) from PartnerLeadTypes e2 where e2.PartnerLeadTypeID <= e.PartnerLeadTypeID) as e.rownumber

Take the e. off the alias.

Looking at SQL Server 2005 and SQL Sever 200, it looks like you will need to restore the 6.5 database to either SQL Server 7.0 or SQL Server 2000 first...

See if this works for you:

declare @Name varchar(50)

set @Name = 'ABC' -- or what ever nema you are testing

select

    HREMP.Name,

    count(dt.Name)

from

    dbo.HREMP

    inner join (

        select

            mlog.Name

        from

            dbo.mlog --...

What should the result of this calculation be based on your example?

My first question is what database are you trying to run this maintaenace plan against?

The first error is due to the fact that the database could not be placed in...

KH, That's because of the typo.  I left out the '0,' after the 'dateadd(dd,', which is what Michael was tell me.

Michael, Regarding the typo, that's what I get for writing the select statement on one system and typing it on another (didn't use cut and paste).

Thanks

I think it would help if you could post the DDL for the table and index.

Sounds like a permissions issue on the file or directory.  Is the S drive local or on a san?