A couple of quick things to look at:

- Is the user a member of the local Administrators group for the server? If so, does BUILTIN\Administrators have sysadmin rights?

- Are there...

The default value is 2147483647.

The best way to handle this is first to issue the sp_configure statement setting advanced options (with RECONFIGURE) to see the current setting, something like this:

EXEC...

If you are this active, some ISPs provide a VPN solution so that you can tunnel in over VPN to connect to SQL Server. You may want to check if...

Yes, MSDE is a SQL Server engine so it will continue to request more memory as needed. You can, however, set a maximum amount of memory MSDE can use, much...

The main reason for this is because of the security implications with allowing SQL Server traffic across the firewall. In order to allow Enterprise Manager to connect directly to SQL...

Starting point to determine the support on a product:

Lifecycle Starting Point (Choose Country)

Extended support will be Dec 31, 2010 or 2 years after the next version...

Since it's a service account, you don't want to alter the logon hours. You may, however, want to secure what systems it can logon to. However, since the concern is...

Looking at syscacheobjects, I actually have three different entries. The first is the actual query as I submitted it, with uid = 1. The second is the parameterized query with...

Don't forget the NT Authority\System login if Full-Text Indexing is installed. It's at the bottom of that article.

Yes, tempdb is required. Without tempdb the SQL Server will shut down. An example is when too many people are attempting to login just as SQL Server is coming up....

I'm also a big fan of Safari. Safari is well-worth the money, IMO. I use it extensively. Most of my Active Directory library is sitting out on Safari right now....

Just a small point of clarification. Cross DB Ownership Chaining is present in SQL Server 7.0 and 2000. However, we had no option to turn it off until SQL Server...

Hrm. Mine cached 'em both. Odd.

Alamir is right in that you want to set what the AV software is allowed to scan. I discussed this in an article in order to draw out some comments...

You do not have to specify the server and database name in order to cache. Here's an interesting test. Execute the following adhoc query from master:

SELECT * FROM sysobjects WHERE...