Viewing 15 posts - 3,331 through 3,345 (of 6,105 total)
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...
October 6, 2004 at 9:02 am
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...
October 6, 2004 at 7:43 am
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...
October 6, 2004 at 7:33 am
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...
October 6, 2004 at 7:26 am
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...
October 6, 2004 at 7:13 am
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...
October 5, 2004 at 2:40 pm
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...
October 5, 2004 at 1:55 pm
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...
October 5, 2004 at 11:34 am
Don't forget the NT Authority\System login if Full-Text Indexing is installed. It's at the bottom of that article.
October 5, 2004 at 11:30 am
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....
October 5, 2004 at 11:28 am
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....
October 5, 2004 at 9:42 am
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...
October 5, 2004 at 9:29 am
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...
October 5, 2004 at 8:33 am
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...
October 5, 2004 at 8:28 am
Viewing 15 posts - 3,331 through 3,345 (of 6,105 total)