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.
| Author |
Topic |
|
asad.lte
Starting Member
32 Posts |
 Posted - 2010-05-09 : 13:51:03
|
| Hi Experts,My query is simple one but still i need an idea from u people to solve my prob.i hav a structure which is running fine in my office and i tried to create the same structure at my home pc.The prob is datetime2 datatype which is working fine in my office but where as at my home m getting prob like "i cannot find datatype datetime2"ne explanation on this wud be appreciated to solve this .thank you for da support |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-05-09 : 14:04:59
|
| That datatype is available in SQL Server 2008 and above. Is your home system running that version? If it is, then check the compatibility level of the database and make sure it is set to 100 (10.0 - SQL Server 2008). If not, then you need to upgrade or install SQL Server 2008. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-10 : 13:29:37
|
| try this and see what it returnsSELECT SERVERPROPERTY('ProductVersion')EXEC sp_dbcmptlevel 'dbname'------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
problem with datetime2 datatype