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

How to find source of Error

 
   Database Help (Home) -> Programming RSS
Next:  Link to lookup table in SQL statement  
Author Message
Lasse

External


Since: May 02, 2007
Posts: 2



(Msg. 1) Posted: Fri Aug 15, 2008 10:41 am
Post subject: How to find source of Error
Archived from groups: microsoft>public>sqlserver>programming (more info?)

Hi, I get this exception reported when tracing, Error: 547, Severity: 16,
State: 0.
How can I find what caused the error?

Thanks,
Lasse

 >> Stay informed about: How to find source of Error 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 2) Posted: Fri Aug 15, 2008 10:41 am
Post subject: Re: How to find source of Error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Lasse (lars.makiaho@(no_spam)falubo.se) writes:
> Hi, I get this exception reported when tracing, Error: 547, Severity: 16,
> State: 0.
> How can I find what caused the error?

If you add the UserMessage of the event, you also get the error message.


--
Erland Sommarskog, SQL Server MVP, esquel RemoveThis @sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 >> Stay informed about: How to find source of Error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Can't find error in WHERE CASE... -

How to: Use Data Source Object and Data Source View Object? - Hi, I can't possibly find any information of actually how to use a data source object or a data source view object in a package. After I've added a SQL Server data source object and a data source view object to my project I can't use any of them in..

Source Safe - Hi, We desperately need to have some Source Control for version maintaining and to enable quick replication of chenges done to development server to say staging server or QA server... or a production server Any tools, that can plug in to sql server,....

Export DB source help - Hello, i am looking to make a full scripted backup of my sql server 2000 database using various free tools, i can easily export the table structures and stored procs into my script, but i have not found anything to help with: - indexes - users/logins -..

Fucntion/View field source - Hi guys, I'll try to explain the problem. I have a function/view with returning fields A, B, C, D. A and B token from Table1. C and D token from Table2. Is it any way to check from wich table the function/view gets value of the result field? I can get..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
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 ]