I think I posted my Error on creating the SQL 7.0 DB in the worng place - My apologies, if this a duplicate entry -
I have used ISQL to create the DB.
I resolved the COLLATE problem and now only one remains, as follows -
Server: Msg 195, Level 15, State 10, Procedure wwfSpDBinfo, Line 33
'ServerProperty' is not a recognized function name.
I have editied out all the COLLATE statements, and this one remains- any advice on this one please ?
Jon (spartanx15) email: jonux@ixtech.net
The error occurs within the following lines -
---Creating Output Table
select @dbsize Databasesize, @dbpath DataLocation , @logpath LogLocation,
@dbfilesize DatabaseFileSize, @logfilesize Logfilesize,
@maxdbfilesize MaxDBSize, @maxlogfilesize MazLogSize,
ServerProperty('edition') Edition,
CASE ServerProperty('IsCluster')
WHEN 0 THEN 'No Cluster'
WHEN 1 THEN 'Cluster'
ELSE 'No Cluster/Unknown'
END Cluster,
CASE ServerProperty('License_Type')
WHEN 'PER_SEAT' THEN 'Seat Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
WHEN 'Per_Processor' THEN 'Processor Licensing (' + Convert(nvarchar(5),ServerProperty('NumLicenses')) + ')'
ELSE 'Licensing Disabled / Unknown'
END Licensing,
ServerProperty('ProductLevel') PLevel
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO