Leo - Thanks for the reply.

I know DYNSA is not an orphaned user. DYNSA user is automatically created when Great Plains is installed on a SQL Server, much like 'sa'...

Thanks everyone for response.

For the record both of these queries worked and returned exact same results:

select * from Orders where cast(orderdate as date) = '2011-11-30'

select *

from dbo.Orders

where orderdate >=...

I think I found my answer on this website (should have searched here before posting...........

I tried this............

select * from orders where cast(orderdate as date) = '2011-11-30'

It seems to work -...

Okay - that makes sense. learning point - either use alias all the time or not at all.

The alias sure saves typing.

Is alias equivalent to synonym (which I have...

Actually - I took out the alias reference and this query works:

select

NBXWEB.dbo.RBI_POReceipts.PONUM,

NBXWEB.dbo.RBI_POReceipts.Vendor,

NBXWEB.dbo.RBI_POReceipts.RecDate,

NBXWEB.dbo.RBI_POReceipts.SKU,

NBXWEB.dbo.RBI_POReceipts.QtyReceived,

NBXWEB.dbo.RBI_POReceipts.ReadByGP,

RBI.dbo.BT_POP_QTY_REMAIN.REMAIN

from NBXWEB.dbo.RBI_POReceipts

Left outer Join RBI.dbo.BT_POP_QTY_REMAIN

ON NBXWEB.dbo.RBI_POReceipts.PONUM = RBI.dbo.BT_POP_QTY_REMAIN.PONUMBER

and NBXWEB.dbo.RBI_POReceipts.SKU = RBI.dbo.BT_POP_QTY_REMAIN.ITEMNMBR

I'm...

Thanks for the replies - I was able to 'track' down the service that had connection established - I manually stopped and was able to restore my database.

Very educational forum...

That's kind of what I thought.

Thanks for the assistance.