Unable to run C# project from SQL Packager

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 9, 2004 8:17AM in SQL Packager Previous Versions
Hi Robert,

These seem to be to be some very common errors that come up when running SQL scripts produced by SQL Compare rather than formatting errors. The second one is a known problem in that when SQL Compare compares two NT database users, it sees a difference if the machine name is different. In other words, it will try to migrate 'A\ASPNET' because it's different than 'B\ASPNET'. When the script runs on the server, though, SQL Server will not create the user because a user called ASPNET already exists in the database!

The invalid column error is a mystery. It could be something as simple as already having the same column name in the table with a case difference. In that case, you could set the 'treat items as case-sensitive' SQL schema option.

More often than not, the error comes up when scripting a stored procedure due to dependency problems or linked servers that don't support ISOLATION LEVEL SERIALIZABLE.

Hopefully this information will help solve the problem.
This discussion has been closed.