To find DTC:

1. GO Start Menu - Admintrative Tools -Component Services.

2. Under Component Services, Expand Computer - Right click on My Computer & slect properties.

3.In the pop u Window,...

Please check your DTC settings.

You are correct. But when there is no disk space even to perform a full/diff backup how would you handle that?

You can try out something like this.

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'U'

order by modify_date desc

But you will be still able to transfer passwords along with logins to different server though.

I was able to shrink successfully.

Here are the steps i followed.

Change the DB back to Simple If it is in Full mode.

Change it back to Full mode.

Use T-sql

DBCC Shrinkfile(logfilename,Size...

Try to avoid using &% and see if you make it through.

I would suggest to use MS procs sp_sendmail & sp_alerts. You can have custom subject, Body etc..

We cannot have more than two secondary DBs. But in coming Denali onwards, it supports more then two secondary DBs

I had experienced similar issue while trying to log shipping sql2000 DB onto a SQL 2005 instance. Although job history shows successfully running. Actual restore wouldn't take place. Check SQL...

Let me know if i am not clear?

Do a Sample update on a non critical table\article on the publisher by

updating column with. and check on the subscriber if it is current and roll back to original...