Will do.  Thanks for your time as always it's much appreciated.

Thanks Brian. Is it true that if I explicitly deny this user any permission it will take precedence over any allowed "role" permission?

Thanks PW. I didn't know you could Decalare a parameter locally like that. It worked like a charm. Thanks again!

Thanks Ian.  I don't have the text in row option turned on but I'm thinking about it (BOL said it could be read and written to as fast as a nvarchar,varchar, or varbinary.) Not...

Great, thanks for the response Lowell. I'll check out the links!!!!

Ok I tooled around a little bit (deleted and recreated the account, then tried connecting on a different puter from the one I usually work from) and now this user is...

Thanks sushila will check it out!

Thanks all for your replies. I belive that most if not all these tables are indexed. I'd have to go thru em all but they should be. I re-indexed the...

ha look at all those smillies! I'm not too famliar with execution plans either!! I better add it to the list!

rqR'us I ran your query:

  |--Compute Scalar(DEFINE[a].[BP_VALUE]=[a].[BP_VALUE], [Expr1042]=Convert([t_MTSTM_STOP].[NEEDED_FROM]), [Expr1043]=Convert([t_MTSTM_STOP].[NEEDED_FROM])))

       |--Nested Loops(Left Outer Join, OUTER REFERENCES[ord].[ID]))

            |--Hash Match(Right Outer Join,...

I haven't heard of derived table/joins.

rqR'us here ya go:  (view definition I'll have to remember that one!)

CREATE VIEW dbo.v_MTSTM_Main

as

select    

ord.ID as ORDER_ID,

ord.NUMBER as ORDER_NUMBER,

ord.ENTERED_ID,

ord.CANCELLED,

ord.BROKER_ID,

ord.AGENT_ID,

ord.BILLTO_ID,

ord.STATUS as ORDER_STATUS,

ORDERSTATUSTABLE.STATUS_NAME as...

C R thanks for the tip! I'll contact Sterling Commerce and figure out what we need to do. I don't want corrupted DBs!!!! Thanks again!

Well.....sort of. This program Gentran uses an Access DB and is always running on the same server that SQL is on. Not sure that I want to change it to...

Thanks AJ Ahrens. Will have to do some searching. Thanks again.