Unable to make a new stored procedure

[jello]

Hello,

For the course I am currently taking I have to create a new stored procedure.

However, when I right click the Stored Procedures Node in the Server Explorer Tab, I only get 'Refresh" and "Properties" as my options, and Create New Procedure is not included.

So how I should fix this problem?

 

[Vishal Rana]

Hi

I think it is related to the Data Source or DataProvider.

".NET Framework Data Provider for OLE DB" does not seem to give an option to Create New Procedure.

"MS SQL Server" with ".NET Framework Data Provider for SQL Server" gives the Create New Procedure option.

 

[nbwd]

You can reinstall the Microsoft SQL Server 2005 Expresss