October 13, 2003 at 9:21 am
I have a view incident, the dbo is _SMDBA_ but could not get a name right. instead it returned 'Invalid object'.
October 13, 2003 at 9:34 am
I used select * from [_SMDBA_.Incident] and got 'Invalid object name'
October 13, 2003 at 9:46 am
Try:- select * from [_SMDBA_].[Incident]
October 14, 2003 at 4:24 am
if _SMDBA_ is the user dbo, it would be :
select * from dbo.incident
October 14, 2003 at 5:59 am
It is definitely [_smdba_].[Incident]. _SMDBA_ is the owner. This is a view from the Magic Solutions Help Desk Product.
Ron Sorrell
613-913-1540
Nashco Enterprises
A Network Associates Premier Partner
866-590-0846
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply