What are system procedures in sql

Posted by Sekar.C under Sql Server on 3/27/2012 | Points: 10 | Views : 760 | Status : [Member] | Replies : 5
hi,
What are system procedures in sql?

Regards
Sekar.c

Regards
Sekar.c



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: CGN007 on: 3/27/2012 [Member] Silver | Points: 25

Up
0
Down
Here it is
http://msdn.microsoft.com/en-us/library/ms187961.aspx

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