When executing a large .sql file contents, which creates a lot of objects on a database, running the ExecuteNonQuery over a Database object, we're getting a FailedOperationException. Is there a way to find which of the SQL statements passed in
the string is causing the exception, and have some more 'familiar' error message?
Are there other options to run the multiple T-SQL statements created with the SQL Server Management Studio database script generation feature?
We are using the SMO on a .NET Fx 3.5 app running against a SQL Server 2008 instance on a 32 bits computer.
Alberto Silva Microsoft MVP - Device Application Development - http://msmvps.com/AlbertoSilva moving2u - R&D Manager - http://www.moving2u.pt
View Complete Post