The Distributed Transaction Coordinator (DTC) service coordinates transactions that update two or more transaction-protected resources, such as databases, message queues, files systems, and so on. These transaction-protected resources may be...

Found this transaction replication article from the URL as useful and therefore listing the same for your benefit since you are essentially looking to monitor and conclude on what is...

Please read the information listed on the following URL, this will help you in achieving your objective.

www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205

you can also use SQLSERVERAGENT to schedule the package to execute as per...

and further could you please clarify as to what you intend to state when you mentioned the following in your post :

SQL server uses about 80 threads which is above...

if you are referring to database connections when you mention threads you can execute the following query:

select a.name as "databasename",count(*) as "No of connections"

from sysdatabases a, sysprocesses b

where...

From my perspective you can avoid trigger creation as that would mean object creation in a production environment.

you can instead start a very lightweight server side trace (that will...

As per my current understanding there is no limitation, you are free to choose the compression option on the subscriber.

This is because data compression is transparent to an application...

ok this suggestion may seem a bit out of context but maybe you can execute a Update statistics for all tables with full scan and then attempt executing the...

SQL Server 2005 exposes a lot of information like missing indexes and indexes which are not used for a period of time, can prove very useful as well.

you can...

it looks like the job did not run today because you specified in the schedule that it should run on day 1 of every month.

This means that it will run...

and if you do not have a long enough window on weekdays you can run a lightweight version of Checkdb by running it with a parameter ==> "with Physical_Only"...

if nothing else works you can maybe work on a weekly once Full backup + Daily differential backup + Transaction log backup strategy.ofcourse this strategy goes out of...

ok i cannot mention this with a great deal of authority but this points to a possible CPU contention \ pressure on your server.But then we are bound to see...

I completely agree with Steve, shrinking without thinking can come back to haunt you really bad.

Perfect example ==> Log grows over the weekend during a index rebuild or...

As A.J. suggested have you ruled out index fragmentation by running a DMV query ( even though the table has not changed as per your feedback) ?

Also are...