Thanks Sugesh fro the prompt reply, I am waiting for updated scripts.

Hi,

Following DB creation script works fine in SQL server 200 but It is giving problem in the SQL 2005. Unfortunately I dont have sql 2005 installed environment access with me....

http://www.databasejournal.com/features/mssql/article.php/3489111

Probably you can try this http://www.mssqltips.com/tip.asp?tip=1202 solution

To avoid error "Ad hoc updates....." db user must have db_securityadmin rights.