Re: I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 26 Sep 2007 21:41:33 +0000 (UTC)
vasurajanna@xxxxxxxxx (vasurajanna@xxxxxxxxx) writes:
I created several stored procedures inside of SQL Server 2005 Studio
Managment, but I cannot view the stored procedures inside of Visual
Studio 2003. When I add a SQL data connection in VS 2003. I can see
the tables but no stored procedures. The DBA gave me create
procedure,connect and execute
premission. I have instaled Visual Studio SP 1 and I have show
objects
owned by any user checked.
When you create an object in a schema, you don't become the owner
of it, but the schema owner does. This can indeed lead the situation
where a developer cannot access objects he creates.
Ask your DBA to give you ALTER permission on the schema where you've
created the procedures. If he does not want to give you that, there
are several options, depending on what you really need to do.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005
- From: vasurajanna@xxxxxxxxx
- I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005
- Prev by Date: List of dangerous Command
- Next by Date: Re: Encrypted data in SQL 2005
- Previous by thread: I cannot view any stored procedure inside of Visual Studio 2003 that was created in SQL Server 2005
- Next by thread: List of dangerous Command
- Index(es):
Relevant Pages
|
