1. What is the use of "xp_fixeddrives" procedure in sql server?
Ans. It is used to check the free space on sql server.
drive MB free
(2 row(s) affected)
2. Which stored procedure is used to send mails in sql server?
@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';