Another thought just hit me. If you're just looking for SMTP (not sure why you need POP), you can install SMTP from IIS and have it with the smart host...

A friend of mine uses NTMail from Gordano.

Also, there are sendmail variants for Windows out there. It's open source, but can be a real bear to configure and secure....

Enterprise Manager is legal so long as you have a license for SQL Server.

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

Yes, I'm positive. Your rights on your system don't grant you additional rights on a separate system.

Okay, what I'm about to say is at a very high level, but...

quote:

---

so far, so good, but...to my knowledge this scenario is possible. Consider a NT User who is local admin to his machines,...

Take a look at the following roles:

db_datareader

db_datawriter

These roles give read or write respectively on all tables and views within a given database. These permissions are implicit, meaning when you add...

Well, if you're willing to shell out a few dollars, check out the Transact-SQL Language Reference from Randy Dyess. It's supposed to be quite comprehensive and is in eBook form:

http://www.transactsql.com/

K....

I can't claim credit for the idea. I saw it in something that Richard Waymire of Microsoft wrote. However, it's an easy concept to make happen.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

quote:

---

But how do you prevent a developer with admin rights or even an admin from login without removing BUILTIN/Administrator, which is a...

quote:

---

The SQL database uses Domain security and therfore all members of the domain have the select,update,delete rights on the respective databases.

My problem...

You have to have SQLAgentMail configured before you can send emails or pages to the operators you've setup.

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

Keep in mind that for object creation, if a user is a member of the following roles, the user can create an object with dbo as owner:

db_owner

db_ddladmin

When creating the object,...

Okay, here's where I hit you up with a shameless plug for my eBook.

Other good sources are:

http://www.sql-server-performance.com/

Windows 2000 Resource Kit

SQL Server 2000 Resource Kit

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Do you truly want them aliased to dbo or just have db_owner rights?

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

We're primarily a SQL Server shop, but I do play with MySQL off and on.

MySQL, using the Berkeley piece, does support transactions. Stored procedures, true referential integrity support, and...