TFS messages gone adfter MS SQL reinstalled

HI all,

after replacing failed HDD i had to reinstall MS SQL server application and reatah all the DBs to it. Since then i have no Team foundation specific messages in event logs. All it says is something like this:
A database error occurred (SQL error 18054) ---> Error 500031, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
Error 500022, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
No items were checked out

it was supposed to tell which user has the file already checked out.
subineAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

Did you restore/reattach the previous MSDB database? That is where the customer error message is kept iirc.

Cheers
  David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
subineAuthor Commented:
Thanks for answer. we did fix it a bit different way, so not full points are assigned
0
subineAuthor Commented:
Thanks,

we took another fresh tfs server linked it, and inserted the messages. not sure but looks like the messages are in Master db.

DECLARE @Error AS VARCHAR(6)

DECLARE @Severity AS VARCHAR(5)

DECLARE @Message as VARCHAR(4000)

DECLARE curMessages CURSOR FOR

SELECT error, severity, description

FROM [WorkingTFSServer].master.dbo.sysmessages

WHERE error >= 40000

OPEN curMessages

FETCH NEXT FROM curMessages

INTO @Error, @Severity, @Message

WHILE @@FETCH_STATUS = 0

BEGIN

print @Error + ', ' + @Severity + ', ''' + REPLACE(@Message,'''','"') + ''''

SET @Message = REPLACE(@Message,'''','"')

EXEC ('sp_addmessage ' + @Error + ',' + @Severity + ', N''' + @Message + ''', @replace=''REPLACE'' ')

FETCH NEXT FROM curMessages

INTO @Error, @Severity, @Message

END

CLOSE curMessages

DEALLOCATE curMessages
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.