After TFS Database Restore, all functions stopped working

Question

after restoring TFS 2010 backup set, all functionalities of TFS stopped working.

the error message is :

Procedure prc_security_read_identities
Must declare the scalar variable "@rowCount".

this error also occurs when executing prc_security_read_identities procedure manually. this is an encrypted stored procedure, so I can not see what is happening inside!

Msg 137, Level 15, State 1, Procedure prc_security_read_identities, Line 77
Must declare the scalar variable "@rowCount".

Any help would be appreciated...

Answer 1

Hi Farzin,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Best Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

We need some more info:

• How did you restored the TFS databases?
  
• Did you follow any articles?
  
• Did you maybe use TFS Power Tools for backup?

Please detail what you did.

---

Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help.