Can i compulsorily write the Stored procedure..

[Former Member]

Hi..

see the images..

I would like to write the sp

so, i opened db and try to open sp path..

but

normally in particular database tables ,views sps it is showing..

but it is not showing..

if i click and double click error message is comming

what was happened in my db..

2) my next question is can i write    the sp .......like  create sp like this way.....

[KennedyT21]

$riniva$ Rachumallu ...

The server is right one does the sap installed in the server what you have mentioned the server is not proper try to

The other very simple steps to recover the MSDB database from suspect mode is :-

1. Stop the SQL Server database & services

2. Rename or move the "msdblog.ldf" & "msdbdata.mdf" files

3. Copy "msdblog.ldf & msdbdata.mdf" files from any other working database installation to

the same path

4. Start the SQL Server database

This will make your MSDB up & running
hope this helps

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Please select the correct database and confirm its running before creating SP.

[Former Member]

Hi, Srinivas.

This issue is about SQL Server. Check this URLs:

http://msdn.microsoft.com/en-us/library/aa258745(v=sql.80).aspx
http://www.sqlservercurry.com/2011/03/repair-sql-server-database-marked-as.html
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/0a9253d0-6da5-4297-82fa-bf1...

I hope this is usefully.

Best regards,

JC.

[VamcParimisetti]

Hi Srinivas,

In Order to Open an SP Follow the below Procedure,

Go to SQL

Select the Database

Click on Programability

Then Go to Stored Procedures

Right Click on dbo.SBO_SP_TransactionNotification & Click on  Modify to Add a Stored Procedure.

Write your SP below 'Add Your Code Here' and Save

Check this Thread :

http://scn.sap.com/docs/DOC-7034

http://scn.sap.com/thread/1788218

[Former Member]

Hi,

First i am not able to open the Programability...

that's why i uploaded the images....