Change the system date to future date in desired database

Question

Change the system date to future date in desired database

gary1

SSC-Insane

Points: 21152
More actions
June 21, 2013 at 5:01 pm

#276636

How to change the system date in only one database?
When an application accesses this database, it should show the future date. But the rest of the database should show system date and when I'm done I can set it back
Is this possible in sql server. I know it's possible in Oracle.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Not possible. The system date is the Windows system date. This shouldn't be changed as it can cause problems with Kerberos tickets.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Aadhar Joshi Hall of Fame Points: 3202 More actions · Answer 2

The alternate is u should keep two columns, u have to tell developers to use FutureDate column while for other database, it should CurrentDate.

The second option is u should create view which adds timing difference to date so it works like future date.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

gmamata7 (6/21/2013)
How to change the system date in only one database?
When an application accesses this database, it should show the future date. But the rest of the database should show system date and when I'm done I can set it back
Is this possible in sql server. I know it's possible in Oracle.

Maybe if you explain why you want to do this, we can offer positive suggestions?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

gary1 SSC-Insane Points: 21152 More actions · Answer 4

One of our application needs to be tested the policy rate effects by referencing future dates

I tried to implement the steps mentioned in below link but the command-line steps tmuser is nit recognized.

http://www.solution-soft.com/whitepapers/MS-SQL-setup/Configuring-MS-SQL-to-use-TimeMachine.pdf