[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Stored Procedures NOT appearing in SQL Server Management Studio

Mike

3/29/2007 3:10:00 AM

Hi. Please forgive me, but I'm still getting used SQL Server 2005. When I
create stored procedures under Databases-MyDatabase-Programmability-Stored
Procedures, parse-them and save them, they don't appear when I refresh the
Stored Procedures window! This is driving me insane. The .stored procedures
are being saved as .sql files, but they're not appearing in
Programming-Stored Procedures for my database. What is going on? I want to
see them :)!

Thanks all.
5 Answers

Aaron [SQL Server MVP]

3/29/2007 3:32:00 AM

0

Parsing does not create a stored procedure in your database, it just
verifies the syntax (though it will not catch some things due to the way
deferred name resolution sort of works).

Saving merely saves the physical file on your hard disk.

You need to EXECUTE the CREATE PROCEDURE script in order to apply the
procedure to your database.

This is the same way Query Analyzer worked. Saving always had to do with
the working file and not with the object stored in the database.

--
Aaron Bertrand
SQL Server MVP
http://www.sq...
http://www.aspfa...




"Mike" <Mike@discussions.microsoft.com> wrote in message
news:A41316C1-38E8-4AD2-82CC-F7C4BAF195A0@microsoft.com...
> Hi. Please forgive me, but I'm still getting used SQL Server 2005. When
> I
> create stored procedures under Databases-MyDatabase-Programmability-Stored
> Procedures, parse-them and save them, they don't appear when I refresh the
> Stored Procedures window! This is driving me insane. The .stored
> procedures
> are being saved as .sql files, but they're not appearing in
> Programming-Stored Procedures for my database. What is going on? I want
> to
> see them :)!
>
> Thanks all.


Dave Patrick

3/29/2007 3:37:00 AM

0

Actually you don't even need to save the SQL just execute it to create the
SP

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.c...

"Mike" wrote:
> Hi. Please forgive me, but I'm still getting used SQL Server 2005. When
> I
> create stored procedures under Databases-MyDatabase-Programmability-Stored
> Procedures, parse-them and save them, they don't appear when I refresh the
> Stored Procedures window! This is driving me insane. The .stored
> procedures
> are being saved as .sql files, but they're not appearing in
> Programming-Stored Procedures for my database. What is going on? I want
> to
> see them :)!
>
> Thanks all.

Mike

3/29/2007 3:40:00 AM

0

Thanks for explaining this. I appreciate it...
Mike

"Aaron Bertrand [SQL Server MVP]" wrote:

> Parsing does not create a stored procedure in your database, it just
> verifies the syntax (though it will not catch some things due to the way
> deferred name resolution sort of works).
>
> Saving merely saves the physical file on your hard disk.
>
> You need to EXECUTE the CREATE PROCEDURE script in order to apply the
> procedure to your database.
>
> This is the same way Query Analyzer worked. Saving always had to do with
> the working file and not with the object stored in the database.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sq...
> http://www.aspfa...
>
>
>
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:A41316C1-38E8-4AD2-82CC-F7C4BAF195A0@microsoft.com...
> > Hi. Please forgive me, but I'm still getting used SQL Server 2005. When
> > I
> > create stored procedures under Databases-MyDatabase-Programmability-Stored
> > Procedures, parse-them and save them, they don't appear when I refresh the
> > Stored Procedures window! This is driving me insane. The .stored
> > procedures
> > are being saved as .sql files, but they're not appearing in
> > Programming-Stored Procedures for my database. What is going on? I want
> > to
> > see them :)!
> >
> > Thanks all.
>
>
>

Mike

3/29/2007 4:16:00 AM

0

got it - Thanks!

"Dave Patrick" wrote:

> Actually you don't even need to save the SQL just execute it to create the
> SP
>
> --
>
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.c...
>
> "Mike" wrote:
> > Hi. Please forgive me, but I'm still getting used SQL Server 2005. When
> > I
> > create stored procedures under Databases-MyDatabase-Programmability-Stored
> > Procedures, parse-them and save them, they don't appear when I refresh the
> > Stored Procedures window! This is driving me insane. The .stored
> > procedures
> > are being saved as .sql files, but they're not appearing in
> > Programming-Stored Procedures for my database. What is going on? I want
> > to
> > see them :)!
> >
> > Thanks all.
>

Dave Patrick

3/29/2007 9:17:00 AM

0

You're welcome.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.c...

"Mike" wrote:
> got it - Thanks!