I have created installation project for our application. In this installation project I am creating new database by using predefined SQL connection, Also I have added create script of table & store procedure .Now problem is that when I try to install our application installer is running fine until it copy our project to machine but at the time of creating database & executing SQL script if any error occurs installer directly rollback without showing me error message.
e.g. if I am creating database with name of "Test", If that database is already present then installer must show error message that "Test database is already present".At present it is not showing me any message.
Please tell me solution for above problem.