would you please put example , how to do that ? SMS application is another program , how i can tell it to send sms ?

Thank's , if i uninstall MSSQL SERVER 2005 on server and install it again , can it solve problem ?

Hello , Please Help me to solve problem

sorry , i check my back up folder i dont have back up MSDB back up , there is my data base back up and adventure work back up ,...

i run that command , give me this message what should i do ?

Msg 8979, Level 16, State 1, Line 1

Table error: Object ID 117575457, index ID 1, partition ID...

yes, i have back up from my data bases

i run :

DBCC CHECKDB (MSDBData) WITH NO_INFOMSGS, ALL_ERRORMSGS

give me the error : the data base doesnt exist ?!?

no , dont encryption . I saw a database , when i open Stored Procedure list , a lock icon appear near the name of Stored Procedures , and when...