refersh database

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  April 27, 2011 at 3:04 am

  #239214

  what are the possible ways to refresh the database in SQL ?

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  April 27, 2011 at 3:42 am

  #1316435

  What do u mean by refersh?

  U dont know the ACID Property.

  Thanks

• Ryan007

  SSCrazy Eights

  Points: 8275

  More actions

  April 27, 2011 at 6:21 am

  #1316503

  The only way to refresh a database is right clicking database node in object explorer and clicking on refresh. You can not do it by t-sql query or other way.

  Ryan
  //All our dreams can come true, if we have the courage to pursue them//

• Warwick Rudd

  Ten Centuries

  Points: 1240

  More actions

  April 27, 2011 at 6:44 am

  #1316510

  SSMS can be a little finicky and does not automatically refresh. You can select any part of the tree nodes and refresh at the highest level or by selecting something specific. Ie a DB or an agent job etc. This can be done by right click | refresh or selecting the refresh in the menu bar.

  MCT
  MCITP Database Admin 2008
  MCITP Database Admin 2008
  MCITP Database Dev 2008
  www.jnrit.com.au/Blog.aspx

• Ryan007

  SSCrazy Eights

  Points: 8275

  More actions

  April 27, 2011 at 7:37 am

  #1316565

  Check this link also

  http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.refresh(v=sql.90).aspx

  Ryan
  //All our dreams can come true, if we have the courage to pursue them//