Check sql server configuration manager.

TCP/IP.

named pipes enabled.

Try to connect using .udl file.

Check the default database for login in the login properties.

Change it to master or tempdb.

Please check the TCP Chimney Offload option as it can cause the network related issues.

Below is the reference link from Microsoft.

https://support2.microsoft.com/default.aspx?scid=kb;EN-US;942861

I have got solution for this issue.

I have increased timeout parameter in msdb..sysmail_server which resolved the timeout problem.

Add default constraint on column ZDateopened with getdate() function.

I guess the mdf file was not accessible at that point.

Please check system events for any storage issue.

Tried setting parameter zero for @query_result_header.

Its removing ---- with headers. I need headers.

Hi All,

I am using below query to send emails.

declare @sql as varchar(4000)

set @sql =' SET NOCOUNT ON

SELECT columns

FROM tables with joins'

EXEC msdb.dbo.sp_send_dbmail

@body_format = 'HTML',

@query = @sql,

@attach_query_result_as_file =...

Someone pls help.

you can use below query.

select serverproperty('productlevel')as sql_ervice_pack,serverproperty

('productversion') as Sql_version

Please check if the below link helps you.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bc28b3e3-a4a9-486e-9507-8450f070de8a/bypassing-recovery-for-database-xxxx-because-it-is-marked-as-an-inaccessible-database-mirroring?forum=sqldatabasemirroring

Pls check on below link. Might be helpful.

http://www.patrickkeisler.com/2013/01/how-to-remove-undo-table-partitioning.html

If sql services are not in services panel then sql is not installed on that server.

You can create Server and database audit to check what and who is inserting records in a table.

Also if possible use partitions for performance.

Gr8!!!! Njoyed a lot...

Game over. Human player wins in 48 shots!