SQL Server 2005 does not have such a data type. SQL Server 2008 has added the 'FILESTREAM' feature, which is not a data type, but a new attribute to a VARBINARY(MAX) data type.
If your question is about the maximum storage capacity, it is limited only by the size of the disk volume.