Solved

SQL message id

Posted on 2010-08-20
5
366 Views
Last Modified: 2012-05-10
what is the meaning of the value of this found in Log file viewer?

thanks
0
Comment
Question by:anushahanna
  • 2
  • 2
5 Comments
 
LVL 16

Expert Comment

by:vdr1620
Comment Utility
can you re phrase your question?
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
the code value in the column (see attached)- what is the significance of it. there was no error in those steps.
msg.bmp
0
 
LVL 10

Assisted Solution

by:Banthor
Banthor earned 175 total points
Comment Utility

Select * from sys.Messages

Open in new window

0
 
LVL 16

Accepted Solution

by:
vdr1620 earned 325 total points
Comment Utility
SELECT * FROM sys.messages
where language_id = 1033 and message_id IN (5060,3014)
0
 
LVL 6

Author Comment

by:anushahanna
Comment Utility
Thanks experts.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now