Yesterday I received following questions on blog. Ashish Agarwal asked following question.
Hi Pinal,
Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query?
If yes, can you please tell me the query?
Thanks,
Ashish Agarwal
Answer to above question is NO. It is not possible to do the same task using SQL Query.
However, if you have changed some SP or any other object and if they are cached in the database, database can be refreshed using DBCC commands.
Read my previous article about SQL SERVER – Clear SQL Server Memory Caches.
Reference: Pinal Dave (http://www.SQLAuthority.com)
pinaldave
Hi Pinal,
I am using SQL SERVER 2005. So I am working on this project, where I have an ITEM_PURCHASE table and an WAREHOUSE table
I want users to be able to input data into the ITEM_PURCHASE table thru a form and the WAREHOUSE table will automatically populate from certain fields in ITEM_PURCHASE. In this scenario should I use a trigger or stored procedure? Can someone provide the SQL code to get me started? Can someone help me out here, it will be greatly appreciated.
Thanks,
Wakil
Hi.
I m using SQL Server 2005, 64 bit edition. Our problem is .. We need to restart or Refersh sql services mostly to increase the performence of Serve. My server configration is very good but the performence goes down suddenly. Please help me regarding this issue.
Dear all
I am using ms sql 2005 for database.
i want if i make any changes in database or add any thing.
it should be refresh automatic i don’t have to refresh my website or software just like cricket’s website.
if someone is using my website it should be automatic refresh in every 1/2 minutes refresh.
can someone help me.
regards all
firoz khan
@Firoz.
That should be done through front End interface / Web interface.
~ IM.