Looks like a typo. Take a close look at the error message you posted.

Cannot open database "mastir" requested by the login

Did you mistype MASTER?

Chuck

I have had the same problem. There is nothing out there that does a fair job of removing comments. This is my solution which is part of a...

I made the assumption that you want any task that is due today or in the past.

create table #Task (Task varchar(10), Due smalldatetime)

insert #Task select 'TaskA','09/21/2009'

insert #Task select...

Thanks Jeff, I was hung up on having to do a self join with ranking to get the order I wanted. Just over engineering on my part. Thanks

In...