I tried to install ZAM7 w/SP1 on the Win2003 with SQL 2000 SP4.
When Run configuring-DB (Enterprise Deployment Database Setup Status),it
show "Connect Exception: 156" , I check the DBSetupLog.txt and got some
message below


DBCreate.dll 2006/11/24 上午 07:08:15 000
The sql script at C:\Program Files\Novell\ZENworks\Asset
Management\SQL\MSSQL7\Metadefn.sql has been loaded and will now be
executed.


DBCreate.dll 2006/11/24 上午 07:08:16 000
The C:\Program Files\Novell\ZENworks\Asset Management\SQL\MSSQL7
\Metadefn.sql script was executed.


DBCreate.dll 2006/11/24 上午 07:08:16 000
The sql script at C:\Program Files\Novell\ZENworks\Asset
Management\SQL\MSSQL7\CreateViews.sql has been loaded and will now be
executed.


DBCreate.dll 2006/11/24 上午 07:08:17 000
Microsoft SQL-DMO (ODBC SQLState: 42000)returned error: 156
Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect
syntax near the keyword 'WHERE'.

DBCreate.dll 2006/11/24 上午 07:08:18 000
Rollback: the database was successfully dropped.


DBCreate.dll 2006/11/24 上午 07:08:18 000
Rollback: the new login was successfully dropped.



is CreateViews.sql error ???


wencheng