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.

In SSMS under the Tools->Options->Query Execution->SQL Server->ANSI

You can check the IMPLICIT_TRANSACTIONS

Run the below query for the database you want

SET IMPLICIT_TRANSACTIONS ON

Give below permission to the user in msdb

USE [msdb]

GO

EXEC sp_addrolemember N'DatabaseMailUserRole', N'user'

GO

You can send mail.

Anybody is having idea on this?

Declare @command varchar(max)

set @command='exec dbo.sp_spname'

Create table #test (based on the columns returned from the stored procedure)

insert into #test exec (@command)

I will do that and check if that is creating the problem or not.

We do have one reindexing job based on the fragmentation which runs every week sunday. So every table will not be affected. Log backups are taken successfully.

Full backup is taken every week Sunday.

I am not sure about the big data load since I have no information what the appliaction does.

Log backups are taken successfully every hour.

Hi,

The log has grown to 48Gb in one month where the database size is 43 GB.

I have checked log_reuse_wait_desc and it shows LOG_BACKUP

MSDN site says "A log backup is required...

Hi Gail,

One of the user wants the select, insert and delete statement during certain period of time of one month back. We dont have the transaction logs backup and we...

Actually I want it from the query in SSMS specifying the location name and this is not repeatable.

We want this for a particular time after restart. We can see the current owner but what about few days back when the server restarted? There may be failover among...