Tell me some system defined procedures

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 2767

sp_addsrvrolemember = Used to add a login as a member of fixed server role.sp_helpdb = Used to see the details of database.sp_bindrule = Binds the rule with database object.sp_unbindrule = Unbinds the rule from database object.sp_rename = Renames the table,index and views.sp_help = Used to see the details of tables.sp_helpindex = Used to display info about the indexes.sp_fulltext_database = Used to enable the database to use full text service.sp_helptext = Used to display definition of user-defined rule.sp_configure = Used to enable the CLR integration.sp_lock = Used to display info about locks.sp_dbremove = Used to rename a database.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response