MS SQL Server - domain controller Date and SQL server Date

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

domain controller Date and SQL server Date

Hiten

2006-03-27, 11:23 am

Hi,

We need to test some functionality in our apps and want to change the system
date. But since the system is on domain, it syncs the date back to current
date.

Is there a way where I can change the SQL server date time so that when we
call GetDate function it will use return me the datetime based on the changed
date and not system date synced with domain?

Any help or comment would be appreciated.

Thanks in advance

Sponsored Links