(Msg. 2) Posted: Mon Feb 12, 2007 4:42 pm
Post subject: Re: Error Message [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not really, this can be from a variety of problems.
> Microsoft Cursor Engine error '80040e21'
>
> Multiple-step operation generated errors. Check each status value.
>
> /Easitrak2006/Form2.asp, line 158
>
>
> Can someone tell me what is error is?
Rollback whole transaction save/keep error message/error s.. - Hi all, In SQL 2005, is it possible to rollback the entire transaction but save/keep the system generated error message/error severity information some where? I tried to store the error message in local memory but once rollback I lost it. Any ideas..
Please take a look at this query and its error message - This query was generate by Microsoft SQL Server Management Studio by right clicking a table and selecting script to. When I run the query against a different database (2k), I get the following error message: Msg 170, Level 15, State 1, Line 8 Line 8:...
How can I get error message and set as value - How can I catch and set the error message. for example I got system error message like " Msg 208, Level 16, State 6, Procedure sp_RunDBSqlScripts, Line 124 Invalid object name 'dbo.sp_RunDBSqlScripts_sqldev5. " set like set @errormessage = ...
ALTER TABLE error message 4929... - Hi, I've the following error message: ---------------- ALTER TABLE [dbo].[AnagraficoAutomezzi] ALTER COLUMN [CodiceXTrascodifica] varchar(10) Go Server: messaggio 4929, livello 16, stato 1, riga 1 Cannot alter table 'AnagraficoAutomezzi' because it i...
SQL 2005 Rollback transaction but commit error message - Hi all SQL 2005 gurus, I have an interesting question: In a loop process, is it possible to rollback one transaction if an error occured, but save the error message for this particular instance in a data table (or any where else)? Here is my scenrior: ...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
