Stored procedures

[Adrian]

Is it possible to use stored procedures with SQL Server 2005 express
edition?

1. In "Object Explorer" under "Databases" there is no pocket called "Stored
Procedures". Is such a pocket available anywhere else?

2. Alternatively via C# Visual Studio (Standard Edition), if under "Project"
I select "C#", there is no "Database", and from there I cannot select ""SQL
Server Project" So how - in Visual Studio - can I create a stored procedure?

Many thanks,
Adrian.

 

[Robert Porter]

The "pocket" is now called Programmability under the selected Database
Key.

 

[Adrian]

I have found thr route.
Thank you.

Adrian.

The "pocket" is now called Programmability under the selected Database
Key.

 

[Adrian]

Using either SQL Management Studio or VS + Server Explorer, I can
potentially create a Stored Procedure. However, supposing that I have an
Application for distribution, and from within that Application I create a
database: how then can a Stored Procedure be created also from within the
Application?

Adrian.

 

[William \(Bill\) Vaughn]

When you build a SQL Server application, you build a database (usually with
the SQL Server or VS tools) to ship with it. This database contains the
Tables, indexes, views, users and the stored procedures used to access and
update the tables. This database is typically deployed along with the
application. SQL Server can make it easier to deploy the application as you
can now open the database in file form so it's attached automatically. There
are many more aspects to this...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
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.
__________________________________