>Since, delimited string would be passed as a string data type, so limitation of size of string data supported in SQL Server 2005 comes into picture (4000 / 8000 characters max including the delimiter character).

I'm not sure that is true. We use varchar(MAX) to pass comma delimited strings. I believe these are up to 2GB