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

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

"Kevin Yu [MSFT]" wrote:

> 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."
>
>
.

Relevant Pages

  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)
  • RE: Calling stored procs on AS/400
    ... server is non-SQL Server. ... I assume that you are using DB2. ... Execute openquery to the DB2 linked server from SQL Server (e.g. insert ... If you use ADO or ADO.NET in code, you can execute the stored procedure on ...
    (microsoft.public.sqlserver.server)
  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: How to test a custom conflict resolver procedure
    ... once I set my stored procedure as a custom resolver? ... Here is an example of a custom resolver I wrote which might help you ... --creating the stored procedure conflict resolver ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: What needs to be set up to use the xp_sendmail Stored Procedure?
    ... You can use an extended stored procedure that just uses SMTP, ... I installed Outlook 2000 on the SQL Server. ...
    (microsoft.public.sqlserver.setup)