How to customize asp.net web application deployment
                            
                         
                        
                     
                 
                
                    actually my client is asking to run(deploy) some .sql files (it may be "create table" or "create function" or whatever scripts related to sqlserver need to run automatically when deploying the asp.net web application)during  the time of deploying the application. so according to him, whereever he install the project, no need to worry about something missing as its added with the project setup.
normally i run this .sql in sqlserver's query analyzer, but how can i customize setup project to do this?.