Sql Server Administrator Interview Questions and Answers Part 2

1. What is the use of "xp_fixeddrives" procedure in sql server?
Ans. It is used to check the free space on sql server.
      EXEC master.dbo.xp_fixeddrives
      drive MB free
      ----- -----------
     C     51234
     D     84544
    (2 row(s) affected)

2. Which stored procedure is used to send mails in sql server?
Ans. xp_sendmail
       EXEC master.dbo.xp_sendmail
       @recipients =N'',
       @subject ='This is subject',
       @message ='Hi Good Mrng'

3. How to run the stored procedure for every server boot in sql server?
Ans. We can configure the stored procedure to run at every server boot.
     EXEC sp_configure 'scan for startup procs',1;
     EXEC sp_procoption @ProcName =  'Target_Sp_Name'
    , @OptionName =  'startup'
    , @OptionValue =  '1';


Receive Quality Tutorials Straight in your Inbox by submitting your Email below:

Delivered by FeedBurner

Protected by Copyscape Duplicate Content Checker