Hi,

you can use HTML tags to format your @MSG variable.We send html-formatted mails for other purposes.

hi,

you may use bcp to export MSSQL data and then use sqlldr to import.

hi,

you should avoid using prefix sp_ in your stored procedures. this is not related to your execution error, but just wanted to inform you.

Luzi62,

you mean C2 level auditing or?

within application truncating a table is not possible. but somehow tables are being truncated.

before truncating i want to check if tablename exists in truncate_table.if not table name and user info...

try

sqlcmd -Shostname\instancename -Uuser_name -Ppassword

hi,

you may use cursor to get all values deleted.

Hi,

If DB goes down so frequently DMVs will not be helpful. for a high-loaded system profiler might be a problem.

Hi,

CXPACKET wait type indicates that there is parallelism issue.

either query is using optiom MAXDOP or max degree of parallelism parameter is different than 1.

we had same problem. setting...

Hi,

by joining DMVs and Procedure type objects you may find which SPs has never been executed.

sys.sysobjects-- xtype =P

sys.dm_exec_query_stats --execution_count

dm_exec_sql_text --objectid

We have 3 Standby databases,2 of them are for disaster recovery one in same location and one at remote.

the other one is used for reporting. For the reporting database sometimes...

I see ,thank you. I will try to figure it out.

thanks,

You are right time difference is 3 hours. I have configured LS for a new db, no change it still uses UTC time as you said.

Can UTC be changed somewhere?...

Time Zone is GMT+2 and LogShipping has been configured via SSMS with default next-next setup.

any workaround?