Probably the requirement for POP3 comes from the need to configure something in the MAPI profile. I'm trying to remember as I did this once... but I don't remember if...

Typically, I recommend creating the permissions with the stored proc and then whatever change control mechanism you use, stored procedure and permissions are stored together to be run together. Eliminates...

I explain about how to break down the requirements for the MCDBA in this article:

http://www.sqlservercentral.com/columnists/bkelley/gettingcertified.asp

Basically, there is a category for SQL Server Admin. You can either take the SQL 7.0...

LockwoodTech Software also has a log explorer type product in the works. It'll probably be cheaper than Log Explorer. When the money becomes unfrozen, it, too, may be an option.

K....

It is informational. Here is the article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

Scroll down to Q17.

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

That works well, too. You know, that technique solves an issue I've seen posted here a lot... how to give developers the ability to create objects as dbo but without...

When you go to kill a SPID, SQL Server has to rollback all the transactions that were in progress at the time. This may take some time. That's one possibility.

K....

1. In the past, my experience has been the MS Press books aren't enough. They are better than they were even a year ago, but don't expect them to get...

This behavior is by design.

SQL Server will start the identity seed so that the next value to get inserted into the table will be after the records inserted with...

In that case, I'm glad my comments helped you find the little beast!

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

That makes sense. Hope you didn't pull too much hair out looking for it. First place I always check is the administrators group on the SQL Server box. Over time...

If you mean through SQL Server, there is no native way. This is on just about every DBA's wish list for Yukon.

If you mean through other methods, it depends. From...

If you (as the user) are trying to stop or start SQL Server Agent, you need to be in one of the following local groups on the system:

Administrators

Power Users

SQL Server...

Doh! I should have been much more specific. As long as the client is validly licensed, as DRBuckingham indicates, whether by CAL or per-processor, SQL Server tools can be installed....

Outside of Lawson, I'd expect to see that very rarely. Notice my qualifier...

Lawson's different screens/programs/whatever you want to call them have varying levels of proficiency with...