DeveloperBarn Forums

DeveloperBarn

Programming & IT forum

stored procedure

This is a discussion on stored procedure within the Microsoft SQL Server forums, part of the Databases category; Hello, I am using sql server 2005. I clicked the database then selected Programmability and then selected Stored Procedure selected ...

Go Back   DeveloperBarn Forums > Databases > Microsoft SQL Server

  #1  
Old February 5th, 2009, 01:10 PM
Barn Enthusiast
 
Join Date: Mar 2008
Posts: 462
Rep Power: 2
todd2006 is an unknown quantity at this point
Default stored procedure

Hello,

I am using sql server 2005.

I clicked the database then selected Programmability and then selected Stored Procedure selected New Procedure.

Wrote the procedure and clicked on save it opens up a dialog box and its storing the procedure in Projects.

Can someone tell me why I cant store the stored procedure the one which I wrote under Stored Procedures.
Reply With Quote
  #2  
Old February 5th, 2009, 01:25 PM
jmurrayhead's Avatar
The Barnfather
 
Join Date: Mar 2008
Real name: Jason
Location: Washington, D.C.
Posts: 1,953
Blog Entries: 8
Rep Power: 15
jmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud of
Default

You should right-click anywhere within the procedure and select 'Execute' OR you should click the 'Execute' button up in the toolbar.
__________________
jmurrayhead
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

If you like it here...throw us a few bones to help
support us.

Join our Folding team: DeveloperBarn Folding

Reply With Quote
Reply

  DeveloperBarn Forums > Databases > Microsoft SQL Server

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Dynamic Stored Procedure without Building Strings jmurrayhead SQL Code Samples 11 March 17th, 2009 12:12 PM
[ASP.Net - VB.Net] Problem with MySql Stored Procedure micky .Net Development 24 October 20th, 2008 08:08 AM
Using Parameterized Stored Procedure richyrich MySQL 14 June 12th, 2008 07:00 AM
If statement stored procedure peebman2000 SQL Development 32 May 23rd, 2008 03:54 PM
Dynamic Stored Procedure jmurrayhead Microsoft SQL Server 16 March 26th, 2008 11:19 AM


All times are GMT -4. The time now is 10:24 PM.


Copyright ©2008-2010, DeveloperBarn

Content Relevant URLs by vBSEO 3.3.2