>>>What is your SQL Server version? If it's Enterprise version, you can set up data driven subscriptions.
>>
>>Its 2005. How would I tell if they have enterprise version or not ?
>

>SELECT 
>	SERVERPROPERTY('Edition') AS Edition,
>	SERVERPROPERTY('ProductVersion') AS ProductVersion,
>	SERVERPROPERTY('ProductLevel') AS ProductLevel
>

>from
>http://berezniker.com/content/pages/sql/microsoft-sql-server/retrieving-sql-server-edition-version-and-service-pack-info

Standard edition

Version 9.00.4053.00

Product Level SP3