How do you check the current date format of an SQL Server 2005 database?
How do you check the current date format of a SQL Server 2005 database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ohh... that's a single statement, must be run on a new query window
DBCC USEROPTIONS
DBCC USEROPTIONS
ASKER
I see it as : mdy
does that necessarily mean mm--dd--yyyy or could it be another day,month,year format?
does that necessarily mean mm--dd--yyyy or could it be another day,month,year format?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How do I check DBCC user options?