Hi SQLBill,

Its SQL Server 2005. I did that but not able to change the object owner.

Should I add that user in sysadmin role before change the DB owner, would you...

Thnaks John, I did and able to change the DB owner but having problem with object owner change.

Hi, I think still its not clear for me, they are going to run them soon, I want to prepare for that.

Thanks,

Hi, Thanks for quick response.

4-5 months back management did sql server security check, they ran the following query

select * from

Thanks for the reply, but mine is SQL Server 2005.

Thanks for your response, but cc/dd/ee/ff/gg may not in standard length in other words it can be ccc/dddddddd/eeeeeeeeeeeeee/fffffffff/gg, so substring doesn't work.

It worked, Thank you very much.

Ray,

Thanks, but I don't know which id is repeating, need all records from that table but repeated one's should concatinate.

Noeld,

I did but getting same error.

David Burrows,Sam Rabie,

Both solutions worked, thanks a lot.

When I said year doesn't matter means

Jan comes after Dec thats why I have 1/1/2005,1/2/2005 at...

I don't understand ur question.

SQLBill,

It returns in wrong order.

Mr. or Ms. 500,

I need the dates in order but i don't want to consider year.

Thanks.

Its DATETIME.

SQLBill,

Your query

SELECT CONVERT(VARCHAR(10), BirthDate, 101)

FROM tablename

ORDER BY BirthDate ASC

doesn't work.

It worked, Thank you very much.