Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Some questions about Stored Procedures, Error Handling,Tra..

  
Goto page Previous  1, 2
   Database Help (Home) -> Programming RSS
Next:  Inconsistent Behaviour in ime Comparison Calculat..  
Author Message
Plamen Ratchev

External


Since: Aug 20, 2008
Posts: 672



(Msg. 16) Posted: Tue Jan 20, 2009 8:30 am
Post subject: Re: Some questions about Stored Procedures, Error Handling,Transactions... [Login to view extended thread Info.]
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Here are examples of catching SSIS errors and logging:
http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligenc...rchive/
http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx

And yes, a wrapper procedure can be helpful in your case.

--
Plamen Ratchev
http://www.SQLStudio.com

 >> Stay informed about: Some questions about Stored Procedures, Error Handling,Tra.. 
Back to top
Login to vote
Henrik Staun Poulsen

External


Since: Feb 11, 2008
Posts: 24



(Msg. 17) Posted: Thu Jan 22, 2009 5:37 am
Post subject: Re: Some questions about Stored Procedures, Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Plamen,

Thank you very much for those links.
They will be very useful.

Best regards,
Henrik

On Jan 20, 2:30 pm, Plamen Ratchev wrote:
> Here are examples of catching SSIS errors and logging:http://vsteamsystemcentral.com/cs21/blogs/applied_business_intelligen...http://blogs.conchango..com/jamiethomson/archive/2005/08/08/1969.aspx
>
> And yes, a wrapper procedure can be helpful in your case.
>
> --
> Plamen Ratchevhttp://www.SQLStudio.com

 >> Stay informed about: Some questions about Stored Procedures, Error Handling,Tra.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Libraries of Stored Procedures and Error Handling - I am trying to design a high quality set of library stored procedures in MSSQL 2005. My issue at hand is I don't know the best way to design error handling. For example, suppose I have the following stack of executed stored procedures in TSQ: Client..

Error handling questions - In my sprocs all SQL calls have TRY CATCH In CATCH, I want to log all error functions ERROR_MESSAGE(), ERROR_NUMBER() etc. etc. to a table. Can I call another sproc to do this or is the scope of the error functions only in the sproc where the error..

Questions about generated stored procedures by VS 2005 (Ta.. - Hi, When I let a TableAdapter generate stored procedure for "SELECT * FROM Supplier WHERE SupplierID = @SupplierID", it generates (some parts removed): Select: SET NOCOUNT ON; SELECT * FROM Supplier WHERE SupplierID = @SupplierID Update: SE...

OPENQUERY with stored procedures error - I am currently using SQL Server 2005 Express Edition and SSMSE. I have developed a unit testing suite for my stored procedures. The way it works is, all of my tests (stored procedures on the database that call the actual stored procedures to..

Exception handling in Stored procedure - Hi All, Conside this senario, (I am using SQL Server 2000) I have to process multiple orders and I have a store procedures to do this. This is schema/algorithm of my store proc Create Proc ProcessOrders Return ErrorStatus varchar(2000) Begin --....
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
Goto page Previous  1, 2
Page 2 of 2

 
 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



[ Contact us | Terms of Service/Privacy Policy ]