Thanks everyone for the input on this thread. I don't see how MS can expect anyone to use this approach for deployment in a large data warehouse. If...

I have the same problem with SQL Server 2014 with SP1. Very disappointing since I have never had this problem with any other version we are using. Running...

I had this problem generating the same error message:

-Publication with table1 and table2.

-table1 schema did not match on the subscriber.

-table2 was removed from and added back to the publication.

-when table2...

I have used this technique with all versions of sql server up to 2014, and none of them return the detailed error description raised by the database engine that you...

Why does the MS documentation say you can do it with visual studio?

http://technet.microsoft.com/en-us/library/ms345099.aspx

It seems like the issue is column level vs row level errors. The method call is showing predefined errors, but does not return the same message you see from...

This article fails to mention this technique will only log error messages generated within SSIS. Errors reported by the database engine (including SQL Server) will receive the generic "no...

This is a good example that I would consider for use with a non-sql server based implementation. However, for sql server to sql server implementations, this could be accomplished...

This query does not return the last sql statement issues like inputbuffer does. It only gives the sql for statements currently running. Also, for stored procedures, it does...

Does anyone know how to solve this problem with a function? It appears that using hints is the only option. The WITH RECOMPILE option is not supported for...

Are you running replication on this database? If so, be sure your log reader is running. The transaction log will not empty unless the log reader has marked...