"New Stored Procedure" Option in VS.Net 1

[jkusmanto]

Hi All,
I have a problem with Sql Server.
I use SqlServer 2000, VS.Net 2003 Enterprise Edition and Windows XP Prof.

Actually we can create a Stored Procedure via Server Explorer in VS (left side of the screen, click on the databank, right click on "Stored Procedures" and choose "New Stored Procedure").
But, there is no such of option in my VS. I have only 2 options: Refresh & Properties.

I though maybe it is something to do with username or permissions. I have done what it has to do, but it didn't work. But I can create a Stored Procedure via Enterprise Manager.

Can anybody help me please ?

Thanks in advance,
JKusmanto

 

[SQLBill]

This is not a SQL Server issue (or at least it doesn't appear to be since you CAN create a SP in Enterprise Manager). I suggest posting in a VS (??) forum. One thing to consider, however, is you say "there is no such of option in my VS". Could you be using an evaluation edition or an edition that does not have that capability? Maybe, you didn't install all parts of VS.

-SQLBill

Posting advice: FAQ481-4875