I cannot find the CPU utilization under the alerts.. Is it under the performance condition alerts ?? Can you please explain...

Try pinging to the other server and make sure network is fine. The next step would be to check if any of your linked server settings has changed. Also make...

Yes you can certainly have more than one instance on a single SQL Server. Please check this link http://msdn.microsoft.com/en-us/library/ms143432.aspx for the Maximum Capacity Specification for SQL Server.

You might be...

Exactly what I needed. Thanks a ton !

You are correct. Column 8 of Output column has an ID of 42.

I am not very sure with the Available External Columns and Available Output Columns I see in...

Wot is a column ID ? How do I find the column ID ?

The login has been dropped from the server. The login is an SQL login. The errorlog is shown in my first post. From that I was able to find the...

The machine is an application server with lots of application and changing the port number or switching sql browser off is not possible. But yes as you said the realistic...

This user is no longer needed in our environment. So it can be dropped. I ran profiler. The application name is given as ".net sqlclient Data provider". Could not find...

But I thought if the corresponding login was removed the error log entry will not occur. The developer involved does not have a clue as to which application or wot...

Even I have had this doubt for a sometime now... Have seen different views in blogs more than once on this topic... The obvious answer may be 1 but I...

Yes.. Locking of the table would have been the issue...

I actually thought about it... have seen this on numerous occasions... the first log backup can actually be as big as the log file itself, the second log backup will...

Thanx for that bit of information.. I never knew about that.. But like you said, the recommended file name extension for secondary data files is .ndf and it's the convention...

The primary data files are the ones with .mdf extension. Yes you can add more data files, but then they will be secondary data files and they will have .ndf...