Change system date using sqlserver

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Change system date using sqlserver

Author

Topic

nagarajuk
Starting Member

7 Posts

Posted - 2007-02-17 : 02:30:55

How can I change system date using sqlserver?

Please help me.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-17 : 02:32:45

You can set the system date/time via cmd, so you can run the command through xp_cmdshell. This is highly not advised though. So why would you want to do this?

Tara Kizer

nagarajuk
Starting Member

7 Posts

Posted - 2007-02-19 : 02:14:36

In my system, I am getting different date other than system date, when I use getdate() function in sql query analyzer.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-19 : 02:38:18

Is that because you have your SQL Server installed on a different machine?

Peter Larsson
Helsingborg, Sweden

nagarajuk
Starting Member

7 Posts

Posted - 2007-02-20 : 00:14:45

No,I installed sqlserver on my machine.
Is it problem with sql server installation?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-20 : 00:50:57

The SQL Server gets the GETDATE() value from the machine where it is installed!
If you get different time using GETDATE() and looking at system clock, you are using a SQL Server from another machine.

Peter Larsson
Helsingborg, Sweden

nagarajuk
Starting Member

7 Posts

Posted - 2007-03-23 : 01:30:50

How do we implement security in sqlserver?

nagarajuk
Starting Member

7 Posts

Posted - 2007-03-23 : 01:34:26

How can we write a stored procedure which should execute at a particular time everyday?

nagarajuk
Starting Member

7 Posts

Posted - 2007-03-23 : 01:53:44

Can we create extended stored proceudre using MS.Net?