I am trying to publish my database to a file(.sql) using publish to provider in visual studio 2008. Its not working.
I am encountering with some error when I try to perform that operation . i.e., "Microsoft SQL Server Database Publishing Wizard has encountered a problem and needs to close. We are sorry for the inconvenience."
Is there any solution for this?? Help.