You're welcome. Glad you got it working! It's a shame MS hasn't update that one with a working script...


>Thanks Tracy - those scripts worked fine. Looked in BOL and found nothing but should have googled myself. Looks like the invalid script has been on the MS site for at least eight months after it was first noticed !
>
>Thanks again,
>Viv
>
>>It seems everyone is having the same problem. See if these help:
>>
>>http://www.wardyit.com/blog/blog/archive/2006/04/26/101.aspx
>>http://groups.google.ro/group/microsoft.public.sqlserver.server/browse_thread/thread/3c4f748e76a510dd/c1787fdeff689f22?hl=ro#c1787fdeff689f22
>>
>>
>>>Hi,
>>>
>>>The script at this URl : http://support.microsoft.com/kb/246133/ fails with
>>>"'LOGINPROPERTY' is not a recognized function name."
>>>
>>>My knowledge of SQLServer isn't up to working out why. Anyone?
>>>TIA,
>>>Viv