Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 4087
Home > Forums > Sql Server >

What are system procedures in sql

Posted by Sekar.C under Sql Server on 3/27/2012 | Points: 10 | Views : 1701 | Status : [Member] | Replies : 4
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
hi,
What are system procedures in sql?

Regards
Sekar.c

Regards
Sekar.c

Reply | Reply with Attachment
Alert Moderator 

Responses

Posted by: Balajikcp8 on: 3/27/2012 [Member] Starter | Points: 25

Up
0
Down
This may help

http://www.codeproject.com/Articles/38682/Overview-of-SQL-Server-Stored-Procedure

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Sksamantaray on: 3/27/2012 [Member] Silver | Points: 25

Up
0
Down
Procedures haveing prefix sp_ are system procedures.
ex: sp_rename,sp_help, sp_helptext etc. They are predifened stored procedures.

Thanks,
Sanjay

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down
SYSTEM STORED PROCEDURE IS AN INBULD IN SQL SERVER

EXEC SP_WHO
EXEX SP_WHO2
EXEC SP_RENAME
EXEC SP_HELP
EXEC SP_HELPTEXT
EXEC SP_RENAMEDB

HOPE THIS WILL HELP

REGARDS
SRIRAM.R

sriram

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: Ajay.Kalol on: 5/21/2012 [Member] Starter | Points: 25

Up
0
Down
System Procedure are inbuilt procedure built by MS Sql Server for Supporting your sql use.

Ajay
ajaypatelfromsanthal.blogspot.in

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response

Latest Posts