473,394 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

How to create a Store_procedure On the Server From SSMS

syedshaffee
Hi People,

How to create a Store_procedure On the Server From SSMS

Please Give me The Syntax of it
Oct 29 '12 #1
6 2074
Rabbit
12,516 Expert Mod 8TB
The basic syntax is
Expand|Select|Wrap|Line Numbers
  1. CREATE PROCEDURE ProcedureName
  2.     -- Add the parameters for the stored procedure here
  3. AS
  4. BEGIN
  5.     -- Insert statements for procedure here
  6. END
Oct 29 '12 #2
Thanx Rabbit i tried that But the Procedure is not saved when Checked Under "Programmability" Please Help and when i clicked on save it is Shows to save it on my Local machine. i want it to be saved on the server. Please be gentle in am new in this "Creating Store Procedure"
Oct 31 '12 #3
Rabbit
12,516 Expert Mod 8TB
If there are no error messages and it says it ran correctly, then it got created somewhere. Make sure you're in the correct database. And after you run a create, it doesn't automatically refresh the list of stored procedures, you have to manually refresh it by right clicking the stored procedure folder and clicking refresh. It may also be the case that you don't have the permissions to view the stored procedures, in which case you will have to talk to the database admin.

When you click save, that's just save the code, it's a text file basically. That doesn't create a stored procedure.
Oct 31 '12 #4
Thanx a Lot rabbit for your reply
Nov 1 '12 #5
PsychoCoder
465 Expert Mod 256MB
Another option is to right-click on Stored Procedures and select to add a new stored procedure like in the attached image:

Nov 5 '12 #6
zmbd
5,501 Expert Mod 4TB
PsychoCoder
Please take a look at your profile, profile settings, attachments and double check the path to the file you uploaded... I can't seem to get at it to fix your post.
Nov 5 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mark Huebner | last post by:
I have Visual Studio 2003 Professional and MS SQL Server 2000 installed on my laptop. For some reason, I can't create a new database with the Visual Studio Server Explorer. The error message is...
0
by: No Spam | last post by:
After looking all the ways to progrrammatically create a new FTP Server & Virtual Directory, I have come to see that the code below is the cleanest. Here is my basic issue. When I run this code, I...
1
by: raghavendra | last post by:
How to create a server-side cookie using C#
15
by: joun | last post by:
Hi all, i want to create in my asp.net application a custom server variable, so i can retrieve later in other pages (even asp or perl) with request.servervariables("HTTP_mycustomvariable") ...
2
by: Neil | last post by:
I created a stored procedure to update a table on a linked server from a table in my local server. Both servers are SQL 7, and the linked server is accessed through the Internet. When I tried to...
1
by: ianicbass | last post by:
In deploying SQL Express, how do I create a new server (INSTANCENAME) programmatically? What would be the best approach to accomplish this. Thank you so much,
7
by: thisis | last post by:
Hi All, i have this.asp page: <script type="text/vbscript"> Function Body_Onload() ' create the object Set obj = Server.CreateObject("UploadImage.cTest") ' use method of the object...
4
by: John Straumann | last post by:
Hello all: Most of my development for websites has been on test VPC images where VS is installed on the server image. I now have a setup where I have a test server joined to my domain, and a...
1
by: Sagaert Johan | last post by:
Hi How can i create an sql server login (sql 2005 express) ? I have my TSQL code ready but how can i run it from c#? How can i execute TSQL code from Csharp, or are there better ways using some...
1
luckysanj
by: luckysanj | last post by:
Dear All, I want to make a radius server for user authentication for my PPPoE client so can any one have good idea or links to create Radius server easily. I see the many links on google but i...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.