Post reply

''databasePROPERTYEX'' is not a recognized function name.

  • February 3, 2005 at 6:20 pm

    #165894

    Win2K server & SQL 7.0 SP4

    'databasePROPERTYEX' is not a recognized function name.

    When I try to run a script.

    It works on SQL2K.. is there any way to make it work on SQL70 or there is an equivalent?

    Thanks

     

     

     

     

  • February 3, 2005 at 7:35 pm

    #540572

    Direct copy and paste from Books Online

    Important  Use the Microsoft® SQL Server™ 2000 function DATABASEPROPERTYEX to obtain information about the current setting of database options or the properties of a specified database. The DATABASEPROPERTY function is provided for backward compatibility.

    This would probably indicate that the DATABASEPROPERTY function would work on SQL Server 7.0

    Did you look a Books Online before posting??

     

    --------------------
    Colt 45 - the original point and click interface

  • February 4, 2005 at 4:51 pm

    #540790

    Yes, but the DATABASEPROPERTY does not return data.

    I have been playing with this but it could be that SQL70 did not have the data available.

    Anyway, thank you for your advice and helped me to confirmed that I looked in the right place.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply