Viewing 15 posts - 4,351 through 4,365 (of 6,105 total)
Yes, but you have to have a link to said server. Either you could code a linked server connection or you can run (though you may have to deal with...
May 15, 2003 at 2:18 pm
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...
May 15, 2003 at 2:12 pm
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....
May 15, 2003 at 2:08 pm
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
May 15, 2003 at 9:15 am
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...
May 15, 2003 at 8:24 am
quote:
so far, so good, but...to my knowledge this scenario is possible. Consider a NT User who is local admin to his machines,...
May 15, 2003 at 7:56 am
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...
May 15, 2003 at 7:46 am
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:
K....
May 15, 2003 at 7:39 am
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...
May 15, 2003 at 7:35 am
quote:
But how do you prevent a developer with admin rights or even an admin from login without removing BUILTIN/Administrator, which is a...
May 15, 2003 at 7:33 am
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...
May 15, 2003 at 7:03 am
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
May 14, 2003 at 1:52 pm
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,...
May 14, 2003 at 12:46 pm
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...
May 14, 2003 at 12:37 pm
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
May 14, 2003 at 8:43 am
Viewing 15 posts - 4,351 through 4,365 (of 6,105 total)