Thank John.  Will check it out.

And yes, unfortunately, within the same domain we are using the same account.  I brought this up on nearly my first day with this company...

Yes, on both Primary and Secondary, I can run query select * From sys.availability_databases_cluster without any issues.

Tried closing and opening new query window and additional window, same error.

Thank you Andrei!!  

Anyone else try this and were they successful or had issues?

Thanks.

Thank you.  That worked.

Archana 2530. Not sure if this helps but I did what sami.sqldba suggested and changed parameter to varchar(25) then added one more statement to your stored proc that converts...

Thanks guys!!!

David,

thank you for your reply. Yes, I am running Ent version of sql 2000. I tried what you suggested (server I am working on is a backup so...

My apologies. The "FindUsers" server is a linked server that is setup already. I believe if you set up a linked server to a server that you know...

Indu:

As far as I know the only thing you can do is change the order of your parameters.

A trick that you may want to try (because the parameter...

Philip:

Is your "Due Date" a datetime or varchar? I know in the past when I tried to do a date comparsion I had to convert the datetime to a...

Thanks, was more of science experiment than anything else.  Figured I would have to simply use varchar(10).....occuseqno is an int currently.

Thanks all.

Thank you, that makes sense.

Yes, Thank you.