Friday, March 23, 2012

How to Refresh database using SQL

Hi,

This question refers to, How do I refresh the database using SQL.

Refreshing mean just right clicking on the database, we can see the Refresh on the context menu.Thats what i ment.

Thanks


Please give more information about what you mean by 'refresh the database'?|||

If you mean that you're either trying to refresh a database node in Object Explorer in SQL Server Management Studio or a database node in the server pane in Enterprise Manager, then there is no way of performing these tasks using T-SQL.

Chris

|||

Simple Answer NO. There is T-SQL command.

You may be looking for something like DOS-Command (clear/cls). If you need on your UI you have to use SMO/DMO.

No comments:

Post a Comment