I happened to have an Azure SQL Database in the same region and when I executed the following statement I get the following result set.

SELECT GETDATE() AT TIME ZONE 'US...

I had the same issue that I needed to troubleshoot. In my case it was McAfee EPO which was blocking the ReportingServicesService.exe to relay emails to SMTP server. ...

Here is the simple statement you can use to turn of Auto close option, just change the database name.

ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF

Here is the simple alter statement you can use, just change the name of the database.

ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF

Hello all,

Thanks for responding.

Phil,

I have tried to write to local drive and do file system task to move and rename the file it failed too. But this time I...

http://msdn.microsoft.com/en-us/library/ms345408.aspx

the link above says that resource db can not be moved and it's updated December 2008.

I have SQL Server 2008 BOL August 2008 installed and it clearly says...

Eric and James, thanks to you both for your input. Only copying the last 3 days of data sounds like better idea than deleting more than a year old...

If you have installed SQL Server 2005 you can access the books on line but if you have not here is the online version of books on line from MSDN.

Thanks Noel, I will also add those procs to my trace.

Have a nice day...

Bulent

thanks for the reply, no matter how the jobs started disappearing the process must be using sp_delete_job proc. I will run a trace for watching the proc above.

Have a...

Hi Sanjay,

I just checked the recovery mode of distribution database and it's simple. I think I will decrease the transaction period to 36 hours to see if that will...

thanks both, I have checked the job on distributor. It is scheduled to run every 10 minutes however job history shows that it takes average 25 minutes to run...

After failing over to passive node I started seeing a nightly process failing with the same error message. It was working fine on the former active node of the...

manaprime (5/27/2008)

---

I have a batch file that executes the BCP command.Now i just want to execute a store procedure with two date input parameters from BCP. The store procedure is...

Before upgrading to SQL 2005 running the SQL Server 2005 Upgrade advisor inspects the databases and stored proc codes to find issues that should be resolved before/after or anytime. ...