HI
I have a old ERP system that is using SQL server 2000. I wanted to upgrade to point to SQL server 2005. The system is using a super user that have ability to create database/users/tables etc. Somewhere during the installation is throwing an error when it querying a view to get the user info. on the query is using (..) notation instead of dbo ( that started on 2005). any workaround on the SQL server end to over come this? seem like 2005 doesn't support the .. notation
below is the full error:
Error: "" (1526)
Program/Method: CNODBCMGR. SQLCOMMAND C:\PROGRAM FILES in DATALIB.VCT
Line: 20
ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'master..PSILoginInfo'.
IF (OBJECT_ID('master.dbo.v_psilogininfo') IS NOT NULL) SELECT sysl.name as UID, sysu.name, sysl.HasPW FROM
master..v_PSILoginInfo sysl LEFT OUTER join PS11_0_W..sysusers sysu on sysl.sid = sysu.sid where sysl.name
='PSIUser_ADMIN'ELSE SELECT sysl.name as UID, sysu.name, sysl.HasPW FROM master..PSILoginInfo sysl LEFT OUTER join
PS11_0_W..sysusers sysu on sysl.suid = sysu.suid where sysl.name ='PSIUser_ADMIN' (208)