Hi to all,


  Good day to all! Just one question
  How can I change the System date of the SQl server using SQL script, sql function/procedure or sql commands?

Thanks
adyaky

You can use XP_CMDSHELL from Query Analyzer / your app to execute an executable which will change System date. This executable may be a C module.



B. Anant

Anantsharma is on the right track, as xp_cmdshell is the way to go. Although there is no need to write a C Module when the command shell (Windows -- even back to DOS) provides a command to change the date
EXEC xp_cmdshell 'date 02-01-06' -- This will change the Date on the SQL Server

-- CMD line command date [MM-DD-YY[YY]]

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com