On any select statement output i want to eliminate the header line as below

"---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- "

Try

KILL {spid}   [WITH STATUSONLY]

Statusonly : displays the current progress report.

Also on SP_Who2 output check the staus of the SPID. If it is "Killed/ Rollback" you have restart the SQLServices.

Depending on what would like to monitor.

Try also BMC Patrol, IBM Unicenter. MOM.

Got weird !

The problem occures iintermittently for the last two days. Now the problem got resolved by itself. I have not made any changes.

I'm sure it would be of network...

Jayakumar,

It could be an indication that the primary_server_name column of log_shipping_primaries or the secondary_server_name column of log_shipping_secondaries does not reflect the proper names.

Ram,

Refered the links

http://www.dbforums.com/archive/index.php/t-929535.html

http://www.mcse.ms/archive81-2005-3-1512945.html

It does not answer the problem.

John,

 That is simple 'select statement againt a table', not even where clause being used. The table has arround 40000 records.

HTH

It is does not seem to be localized and network related issue. As I tried on different machinces running the queries. Even the application getting "Time out errors" because of...

It has external fragmentation. It requirs DBCC REINDEX to rebuild index.

DBCC INDEXDEFRAG will be useful if it is internal fragmentation that too if it less.

My box running on the latest SP and Hotfix, but facing the same problem.

I am facing the similar proble on SQL Server 200 running with SP4 and AWE hotfix applied box.

Process 243:0 (13d0) UMS Context 0x08F8FA18 appears to be non-yielding on Scheduler 3.                                                                                                                                        ...

Hi David,

Thanks for the reply.

So you mean to say that I have 6 Instances on both nodes, I need to apply one by one on each instaces. It is  just...

Is that no.of tranactions?

Would be around 1000 transaction per hour.

Hi,

 I too, facing this similar problem. But googled have not found any explanation or solution.

~ Sivaprasad S

Can you just elobrate what are things do I need set with SQL Profiler to capture the transactions which could cause the log file growth.?

'Reovery interval ' option has not changed , it is set with default value of 0 (Zero).