Perry, thanks for the reply. I saw the same doc. It says MS has tested with 100 DB's which I assume are in a lab. I was after any real...

Hi Gail, thanks for the reply. I had seen your informative article previously. In this case the log filled overnight and had cleared before anyone was able to get onto...

Gail, thankyou very much. Thats much easier to read!

Hi Steve, thanks for the reply. The issue is that I have a db which is in simple recovery. The transaction log file is on a fast disk separate from...

Yes tried this and got a different error message:

Could not find installable ISAM.

I have checked and the c:\winnt\system32\msexcl40.dll is registered. Thanks.

Hi, Yes my excel file is 2002.

Thanks MeltonDBA. This worked a treat:

Setup.exe /q /Action=Install /Features=ADV_SSMS

Thats great. Thanks for you help. 🙂

Dave, tried that one. Even when pushing results to Grid I get the same error:

Msg 6335, Level 16, State 102, Line 2

XML datatype instance has too many levels of nested...

Hi dave. Thanks for the reply. I tried the following:

SELECT usecounts, cacheobjtype, objtype, text

FROM sys.dm_exec_cached_plans

CROSS APPLY sys.dm_exec_sql_text(plan_handle)

where text like 'Blah%'

ORDER BY usecounts DESC;

GO

however the text output is...

Jack and Gail Thankyou for your replies. sys.dm_db_index_usage_stats is a very good starting point for this as all of the transactions are very small and all table are indexed. Appreciate...

Hello, we are planning to use transactional replication for some high throughput databases. I wanted to gather info on the DML of various tables to help us decide whether or...