Worked with OS team and the programmer, found the program was wrong, pointing to the wrong server.

Thank you for your reply

To be more clear to my question: which configuration in SQL Server can block DTC connection?

no, it is not clustered. Thank you for asking.

Thank you guys for the reply. OS team and network team are both working on the issue.

I know that both teams did not touch the server, only developers...

Thanks, Jon.

Well, contacted Microsoft, and ran portqueryUi, it was found that UDP port was blocked inside the server.

Now the question is how can we know where it...

@r5d4, thank you for your information. I have the same problem, and ran your script. The script only generate the scripts for normal indexes, which does...

Thank you!

I will talk to my boss

Thank you!

The interesting thing is that the owner of the box is the system administrator.

Journeyman

Thank you!

I do regular backup (full backup every day) with Transaction log backup

The back up files are backed up to the tape each day.

The reason I...

Thank you,

My server has 5 disks and in RAID 5, partitionted with C: D: E

C:\ for OS + an application

D:\ SQL DB (for that application)

E:\ Contains large amout of image...

Thank you! Have a nice weekend.

Yan

Thank you for the advice.

While ODBC drops, the SQL Server is running fine. It does not happen to all users at the same time. Network guy...

I prefer to eat alone at my desk, but this luxury has been taken away since other people think that I am not "part of them". "Communication skills" as...

Thank you! I will surely try it.

One more thing, yesterday, I used SSMS, right click the Database,went to Tasks and used: "Take Offline" function. Do you think...

Thank you for the advice. I actually made the database in single user mode and tried to take it off line, but still, it said "Database is laready open...