One catch about Notification Services. It does require .NET.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

If everyone is using this one login, you can't restrict based on user authentication. This really leaves you with IP. When you say everyone is on DHCP, is it one...

If you put the information in a separate table, but you don't want to have to worry about users dealing with complicated joins, you can expose views which handle the...

The only issue with the net send is that it will go the first place it finds the user. So if you have a user logged in to two different...

I didn't see it on my SQL client tools. I have seen it on apps I have installed prior to and after the .NET install. For instance, used to run...

Probably the easiest way to do this without purchasing something is to use Perl. The Win32::EventLog package has everything you need to read the event log. The Net::SMTP has everything...

Use the Server Network Utility on the server, it should tell you what port. This can also be reached by using Enterprise Manager.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

I've not heard of such a thing, but then again, I don't keep up much on the AMD side.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

We're conflicting because our semantics are different.

I was thinking along the lines of the WHERE clause, which would keep from doing an entire clustered index scan, but instead a seek....

What version of SQL Server 2000 are you trying to install? It may be the version is incompatible with Win2K Pro. Since we're dealing with Win2K, I'll leave out the...

Is there what appears to be a crash dump in your SQL Server error logs? If not, take a look for .dmp files in your LOG directory. They are simple...

I have noticed a similar phenomenon on one of the laptops I carry. It's particular nasty on instant messenger clients. However, I've not seen it affect SQL Server in any...

Clustered Index Seeks are possible. Here's all the physical operators:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_5pde.asp

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

You can set up aliases for all your servers. Use the Alias tab (SQL 2K) and click to add a new alias. You can then set up all the information...

Best case there is to use a UNION ALL if you can. It's a little cheaper on the operation. The difference between UNION and UNION ALL is that with UNION...