How can I get all the ErrorNumber, ErrorState, ErrorMessage?
I want to know all the errornumber, errorstate, errormessage which thrown by sQL Server 2005.
like ErrorNumber 515, ErrorState 2, ErrorMsg "Update failure"
I can't find all the message stored by sql server 2005 in SqlServer2005 book on line.
Error Message "Cannot TRUNCATE TABLE 'HR.dbo.Employee' ".
All of a sudden (!) I began to get this error whle attempting to run a multi-step job: This is during a very simple T-SQL statement.
Executed as user: EPRODSQLAdmin. Cannot TRUNCATE TABLE 'HR.dbo.Employee' because it is being referenced by object 'v_apps_Employee'. [SQLSTATE 42000] (Error 3729). The step failed.
Tables are being referenced by views all the time... Why would I begin to get this message?
The only thing I can think of is that I had just made my first "indexed view" ever, and it is in this database. Could that be related to the new error message?
Hi all
I am executing a SSIS Package in C# (2005).
Does anybody know how to find out, in case of an error, the
error message?
I am doing the follwoing:
Microsoft.SqlServer.Dts.Runtime.Package local_Package = new Microsoft.SqlServer.Dts.Runtime.Package();
Microsoft.SqlServer.Dts.Runtime.DTSExecResult local_DTSExecResult = new Microsoft.SqlServer.Dts.Runtime.DTSExecResult();
Microsoft.SqlServer.Dts.Runtime.Application local_Application = new Microsoft.SqlServer.Dts.Runtime.Application();
local_Package = local_Application.LoadPackage("c: empssis_package.dtsx", null);
local_DTSExecResult = local_Package.Execute();
if (local_DTSExecResult == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
{
Display MessageBox of the error message ...
}
Thanks for any comment.
Best regards
Frank Uray