Ok, I understand which you are saying, atleast can i generate a report as follows?

It worked,  Thanks for your help

It gives me error if stored procedure exceeds 4000 charecters.

Thanks Yelena, Do you have any examples for the first option, if so please post or send me to personal mail.

With second option#, i have installes notesSQL and created...

Thanks for your reply.

The problem is i cannot create 15 maint palns because it is difficult to maintain. I am looking for a script (and a table) to do this....

Steve,

Good solution. I agree partially with Ramesh comments, If data grows there will be performence hit but we could create index on view.

How about putting same logic in user defined...

I did not do any thing but it started working again. Any ideas why?

Thanks in advance.

Outlook 2000

I have rebooted the whole server still getting same error.

Thanks for your reply: I don't know about exchange server but am able to open outlook and see the new messages.

Babu,

I am also looking for this kind of program, would you please post the code if you solve the problem.

Thanks

Would you please give position location details?.

Thanks!, It worked

Thanks!

Hi,

Thanks for you reply. I am going to face an interview for  SQL SERVER DBA position.

Thanks.