Is Stored Procedure and 'in' broken in MSDE 2000/SQL 2000 SP4?

This is not the command that im running but demonstrates the problem just
fine, basically 'in' using statored procedures seems to be performing as 'in'
or 'is' where as sending a query direct (identical) only performs 'in' as
expected

Example

Use msdb
Select * From Sysalerts Where database_name in (Select
convert(sysname(128),null))

returns nothing

but put the select command in a stored proceedure and it will return all the
rows with database_name that is null

Am i not seeing/setting something?

Simon
.

Relevant Pages

  • Command line uninstall tool
    ... & registry keys will assist in performing a manual uninstall. ... xml file) and then run a command line application via a logon script ...
    (microsoft.public.windowsxp.security_admin)
  • Re: FAT / NTFS
    ... without having to format the partition and reinstall everything. ... always when performing any serious changes, ... "Allan Melville" wrote in message ... > Above command does not work - can anyone assist - I need ...
    (microsoft.public.windowsxp.configuration_manage)
  • [PATCH] Device-Mapper 7/9
    ... Clarify the comment regarding the "next" field in struct dm_target_spec. ... "next" field has different behavior if you're performing a DM_TABLE_STATUS ... command than it does if you're performing a DM_TABLE_LOAD command. ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: How to read a file
    ... Shadrach schrieb: ... performing a function with the data. ... Read a file with IP addresses and run some command against that IP address and a line by line basis. ... and AtEndOfFile. ...
    (microsoft.public.scripting.vbscript)
  • Re: Cant open word .doc
    ... You have to figure out in the association, as a command line option, to ... > opening .doc files. ... The old comp used MS Word and this ... > performing this action. ...
    (microsoft.public.windowsxp.basics)