Can't Create SQL Server Stored Proc in VS.NET? Help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can create Stored procedures directly in SQL Server using the enterprise
manager but can't get VS.NET 2003 to let me. I am logged in as an
aministrator on the server, and using .NET on the database server. What
permissions am I missing to let me do this?
 
What version of VS are you running? Are you trying to use the Server
Explorer?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Hi,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you're trying to create stored
procedures on the SQL server through VS.NET Server Explorer. If there is
any misunderstanding, please feel free to let me know.

if you cannot create stored procedures, did you get any error messages? You
can try the following steps:

1. Remove the connection from the Server Explorer.
2. Create a new data connection to the SQL server using 'sa' as the login
name.

If you don't have sa privilege, please create a user with stored procedure
creation permission. You can first try the account on Enterprise Manager.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Your understanding is correct. When trying to create a Stored Procedure with
the VS Server Explorer I do not get the context menu option to create a new
procedure. However, when using the SQL server Enterprise Manager with the
same login, I can create new procedures.

I am logged in with an account that has database owner and full create
permissions. I am using VS.NET 2003 and SQL Server 2000 Developer. Is it the
Developer edition that hs this limitation? I can create Stored Procedures in
an MSDE version of SQL Server 2000 under the same login.
Ken
 
Hi,

Could you let me know which edition of Visual Studio .NET you're using? I
tried it on my machine and found this might not be a permission issue. It
seems that only Enterprise Architect and Enterprise Developer can create
stored procedures on Server Explorer. In you last post, you mentioned that
you have successfully created stured procedures on MSDE using Server
Explorer. It is true that there are some feature differences between
connecting to MSDE and SQL Server. Here is a KB article on this.

http://support.microsoft.com/kb/833903

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
I am using .NET 2003 Pro. Looks like from the link you sent that the Pro
version has limited integration with SQL Server. I think this issue should be
much more apparent to the buyer. If I had known that I would not be able to
develop SQL scripts in the Pro version I may have upgraded. In addition I
think it is a huge omission to leave the SQL designer out of the
"Professional" edition. What professional developer doesn't use SQL.
Thanks for your response.
Ken
 
Hi,

I'm sorry, but if you think you have purchased a wrong product edition, you
can try to contact the sale to see if they can change one for you. To find
a Microsoft Software Advisor near you, call (800) 426-9400 in the United
States or (877) 568-2495 in Canada.

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top