The second. I administer all my servers from my work station using SSMS, that was not the question, sorry if it came out totally different.

What I am looking for...

This article might help you with this issue. Check it out. It seems to be a bug and the article sets the resolution. Good luck

http://support.microsoft.com/kb/810098

😀 :w00t: :hehe:

Thank you!! I knew it was something as simple as that, but ... those who do not know ... are like a blind person trying to read...

In the one I sent (usp_what) you will one column named blkBy. That column will tell you who is blocking the process. There are times when you need to figure...

I found a script here and created my own stored procedure to identify only active processes, which made my life easier. The name was different, but I named it usp_what....

Thanks, I posted one there as well. I really don't think it has anything to do with SQL, my concern is that something is wrong with the server and might...

Thanks Steve. I am as well. We recently implemented Foglight to monitor our servers and several servers are returning these massages. It does mark them as critical.

As you say, maybe...

Many, many, many thanks. It did work as needed.:w00t: :hehe:

:hehe: :w00t:

Adding a new question here.

I am in the process of consolidating all my servers. Over the years there were many SQL Servers installed and we ended up with a...

Thanks. Yes, the servers are in the same domain and I can access both as my account has admin rights. I will test the port as you suggested to see...

:w00t: Thanks, the article in MIcrosoft was very enlightening!!! By the way, I will use backup as well. We use SQL Backup from Red-Gate for all our backups and...

:w00t: Thanks. What about latency? Any recommendations? Dirty reads better? What about writing? :hehe:

You can use

exe sp_msForeachtable "ALTER TABLE ? DISABLE TRIGGER All" This disable all triggers in all tables, to disable only one table use

alter table [dbo].[tablename] disable trigger [tiu_trigger_name]

What I wonder...

WSS Lynn and it is using the internal database as the database is not in the regular folder, but in Windows Directory under the following path

C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data\WSS_Content_log.LDF

If it were in an...

Thanks, I have admin rights, but open the client I just installed I cannot connect to SQL Server. Message reads the configuration message indicating "no remote conenction allowed" Weird ah?...