Re: Stored Procedures Query

http://msdn.microsoft.com/vstudio/products/compare/default.aspx. Sadly, "SQL
Server Support" does not kick in until the Professional edition. Again, the
SSMSE tools can create SPs. Actually, any version can create them--you just
have to roll your own CREATE PROCEDURE code--all the tools do is give you a
template and a way to insert an SQL into the code. Yes, VS pro and better
can step into a SP as well. But if you just need to create one, Visual
Notepad and SQLCMD can do that... ;)

--
____________________________________
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.
__________________________________

"Adrian" <00@xxxxx> wrote in message
news:4512b686$0$728$5fc3050@xxxxxxxxxxxxxxxxxxxxxxxxxxx
I don't have a "free" version, I have the "Standard" version which wasn't
"free". However the "Add New Item" does not show "Stored Procedures" :(

Adrian.


"William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
news:%23uXoAEZ3GHA.2228@xxxxxxxxxxxxxxxxxxxxxxx
The SQL Server Express Edition supports most of the functionality of the
other versions--including stored procedures. The developer tools, however
are another matter. The free versions of Visual Studio have limited
support
of more of the advanced functions so you're going to want to download the
free SQL Server Management Studio Express from Microsoft.

hth

--
____________________________________
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.
__________________________________

"Adrian" <00@xxxxx> wrote in message
news:4512967e$0$718$5fc3050@xxxxxxxxxxxxxxxxxxxxxxxxxxx
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.








.

Relevant Pages

  • Re: Project problem - sourcesafe & dotnet
    ... Microsoft MVP ... > "Your source control provider does not support checking out while ... > disconnected from the server. ... > Visual Studio will automatically attempt to check out these items. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Slow booting xp home.
    ... The LexBce Server service terminated unexpectedly. ... Windows is loading will come on and then the desktop, ... I read somewhere that Microsoft ... Visual Studio Source Control and SourceSafe -» ...
    (microsoft.public.windowsxp.perform_maintain)
  • RE: connect to server in vs.net
    ... the "server explorer" is mainly used for conveniently manage/view ... some database instances in visual studio, ... Microsoft MSDN Online Support Lead ... You can send feedback directly to my manager at: ...
    (microsoft.public.vsnet.ide)
  • Re: NAT and keepaliveopen connection over TCP
    ... Microsoft MVP, MCSD ... use your server connection for anything else after you punch ... If it was symmetric nat case, I was unable to make the first succeded ...
    (microsoft.public.win32.programmer.networks)
  • Re: out-of-proc server COM
    ... Microsoft MVP, MCSD ... "Alexander Nickolov" wrote: ... write in-proc server, there are some materials about out-of-proc ... My purpose is just to learn how to write EXE server from ...
    (microsoft.public.vc.language)
Loading