Regarding EM.........

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  September 21, 2005 at 1:18 am

  #166145

  Hi!!

  I have some query about Sql server..

  When we enter in sql E.M , If I right click on any table and there show/hide sql pane ther besides that we have other option like property..In that suppose I want Group by extension to be enable then how could I do that????????

  Another query is that I have one column of DataType as DateTime and I set it default as getdate(). now when I select it in Q.A i can see that column in format as yyyy-mm-dd hh:mi:ss.mmm(24h) but when i open that in E.M i can in format like yyyy-mm-dd hh:mi:ss AM or PM...............

  Is there any setting in EM so that i can see that

  column in format like yyyy-mm-dd hh:mi:ss.mmm(24h)

  T.I.A

  Shashank

  ---

  Regards,

  Papillon

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  September 21, 2005 at 6:13 am

  #591678

  shashank - I don't think I understood your first question - could you pl. rephrase ?!

  As for the second - EM picks up your locale settings for Date & Time!!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**