Viewing 15 posts - 1,156 through 1,170 (of 2,497 total)
On a 32-bit server Task Manager does not know about memory above the 4GB line.
If you enable AWE you will have to look in the SQL Errorlog file...
October 28, 2009 at 4:25 am
If you are using /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" you do not need /SQLSVCPASSWORD
October 26, 2009 at 4:23 am
I think there is a KB article about how to change the SQL service account using the Services applet. It includes the registry key permissions and file permissions that...
October 26, 2009 at 4:18 am
There are a number of syntax differences between the RDL of SQL 2008 RS and previous versions. Many reports work OK, but some will need upgrading.
October 20, 2009 at 5:09 am
The .Net 3.5 media should be included in your SQL install media, except to Express Edition.
Whenever I have done a SQL install with FineBuild, the install time has...
October 20, 2009 at 5:04 am
You may want to look at FineBuild V2.1. One of the scripts allows you to apply maintenance to an existing instance or to all instances.
October 20, 2009 at 4:56 am
The reason you did not get the result you wanted from the shrink is that Truncate just marks the table as empty, it dos not release the space it uses....
October 20, 2009 at 4:40 am
Persinally I would always use SQL 2008 unless there was a specific need to use SQL 2005. SQL 2008 can read and update databases created by SQL 2005.
I do...
October 20, 2009 at 4:20 am
I have not done this on Windows 7, but on Windows 2003 the sequence 1) SQL 2005, 2) Visual Studio 2008 worked. Mostly.
On a newly built OS, you should...
October 19, 2009 at 2:51 am
In a 32-bit OS, ALL processes need to share the memory below the 4GB line.
If you have a process sthat is PAE-aware (such as SQL database engine), then it can...
October 16, 2009 at 3:25 am
The ability to use Windows privileges and membership of local Administrators group are two different things in current Windows operating systems. Even in NT4 you could limit the privileges...
October 15, 2009 at 2:54 am
You can set 'Lock pages in memory' on all nodes. You must also work out how much memory to give each instance on each node so tat you do...
October 15, 2009 at 2:49 am
Do you just want to transfer your DTS packages from SQL 2000 to SQL 2005 or SQL 2008? If so then probably the best way is to use DTSBackup2000...
October 14, 2009 at 5:17 am
Does the service account have the Impersonate a client after authentication (Internal Name: SeImpersonatePrivilege) privilege in Windows? This is needed to allow SQL to use different security contexts.
Another important...
October 14, 2009 at 4:43 am
Is the job owner account a sysadmin account? If the job owner is not a sysadmin account then it will not be able to use the sa security context.
October 13, 2009 at 4:47 am
Viewing 15 posts - 1,156 through 1,170 (of 2,497 total)