The complete error message is as follow.

[DBNETLIB]ConnectionRead (recv()).

[DBNETLIB]General network error. Check your network documentation.

We have no problem running our scripts on QA any time. On some servers, our scripts always...

Some suggestions.

Check the total memory usage using tools, such as task manager.

Check if some other applications eating up your physical memory using the task manager. (If an application is not...

Two general approaches to avoid deadlocks are:

1. shorten you transactions

2. change the order of your transactions

In your case, you may try the first approaches and see if it helps.

Thank you so much, James. Your interpretation is right and clear.

Thank you so much for your input.

I have to mention that the script snippets provide our DBA team excellent data. There is no error at all. I just need...

When optimizing databases, you may use up space. Check space allocation and see if it will help.

Running DBCC CHECKDB is very important. You do not want your db corrupted little by little without knowing it.

The owner of a database should not be changed with the loginID.

The owner of a database can be changed after creation. The owner may not be the database creator!

I cannot...

Of course, you can. You can find the IPs if you can RDP to the server. You can either use ipconfig from the prompt command window for a standalone server...

Based on my experiences, most blocks originate from the scripts/queries and database designs. Being a DBA, he can only tell you what blocks what and what scripts may be criminals....

By default, it locates at C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC

You can also find the console using mcc from RUN to start the console.

Then, you can create a shortcut.

There is no simple answer. The allocation of the size of log files depends on your applications, such as read, write, ...

Think about this scenario. You allocated 10 MB for your tempdb log file and set 10% for it to grow. Then, a transaction started. It needed 20 MB space in tempdb to...

Did you try:

detach a database,

open it,

change something there

attach the database

Generally speaking, I do not think you can unless you turn on the C2 audit mode.