I have now performed the same test on a x86 SQL Server build using the 32 bit drivers and I have not been able to repeat it.

I will assume ms...

Even with service pack installed get the same behavior.

Does anyone have any suggestions/ideas. Looks like going to x64 is not a good idea

Just discovered that a service pack exists.

http://support.microsoft.com/kb/2460011

Not sure if this will resolve my issues only one way to find out. 🙂

Also D is a local to the server.

I have also killed of the thread using process manager however this causes the SQL Server and the openrowset works again.

You could try this

GO

/****** Object: StoredProcedure [dbo].[DBA_checkForBlocks] Script Date: 07/13/2010 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER proc [dbo].[DBA_checkForBlocks] @wait_threshold as int,

@emailto as varchar(500)

AS

--Last updated 22/07/2008...

Hi this is a awesome backup report

Made a couple of changes to so it did not return blank results and databases that do not require backups. ie tempdb

--Create a table...

We are also running sql Safe. PRocess could not backup as well.

Yes all databases are enabled to auto grow.

we encountered the same error on sql server 2005 x64 sp2. Error log grew to 12gb.

Service was restarted

we encountered the same error on sql server 2005 x64 sp2. Error log grew to 12gb.

Service was restarted

You can run the following in the master db

select count(*) from master.dbo.sysprocesses

or can use sp_who or sp_who2 for more detail other than a count.

Hope this helps

I did this by using udf's to work out the start and end date of the month.

The link below explains how you can do this

http://www.sql-server-helper.com/functions/get-last-day-of-month.aspx

Hope this helps.

Unfortunatley without the previous log or log files you will not be able to recover this particular log file.

You can also try Books on Line

moving system databases

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

moving user databases

http://msdn2.microsoft.com/en-us/library/ms345483.aspx

xp_smtp_sendmail can be found at

http://www.sqldev.net/xp/xpsmtp.htm

I have found this program also very useful.

http://www.dimac.net/default2.asp?M=Products/MenuCOM.asp&P=Products/w3JMail/start.htm