Hello Mordechai,

What counters did you use? I know you say they are favorite counters, but if you can specify which ones.

If you looked at processor / DPCs Queued / sec...

Hi,

You may want to re-check your connection string if it explicitly specifies a server name, intance name, database name, user name etc. It may happen that your code is trying...

Hi,

In the case that someone created views in another database and you need to move them between servers or databases, just views by themselves you may script them by Right-Clicking...

Current Activity Window has to be refreshed. It may show the connections that existed earlier. You have to do Actions->Refresh

I think we are talking about 2 different scenarios:

1. Everyday Monitoring with Read-Only login for SQL Server - first-line support may use Event Viewer.

2. Quickly Troubleshooting Problems: first-line support will...

Mark,

The first thing I did when I read your reply in QOD was that I copied it to my notes. Thanks! I have to evaluate that how it will work...

Scott,

You say they are Windows Administrators and as Windows Administrators they have access to the Event Viewer and they are comfortable with it!

Events that are logged to SQL server log...

Rudy is correct.

You need a process for the first place. and you need to understand what standards could be technically implemented and what standards could be process-based implemented.

Example: you...

From the technical point of view if you have a database per client then you may detach these databases and keep database and log files and also database backups on...

I posted this issue on March 1 at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=262498#bm264885

It is Microsoft "By Design"

Excel evaluate data types for first 8 rows and it imports / selects NULL for the different data...

Agree with the grrrr expression. These are different dates.

The file properties for the test database say: THIS database created Monday, May 16, 2005, 2:27:47 PM The backup record in the...

To think of it, the design with 2 repeating fields does not put a database into the 1st normal form, see

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q100139

it would be better to put reference type description...

Joel,

Can you tell us what do you mean by "enforce an 'optional' relationship"

Do you mean that the record have to have at least one of 2 references either to A or...

I did not really find one for CPU for alerts.  See

http://msdn2.microsoft.com/ko-kr/library/ms186449(SQL.90).aspx

WMI Provider for Server Events Classes and Properties  

You may want to try more traditional WMI as in...

Mubeen,

Thanks!

I don't run ANYTHING on SA password, except for ocasional work in EM as myself. I looked up my notes related to the described problem that happened 2 years ago, and notes actually contained...