Viewing 15 posts - 886 through 900 (of 2,387 total)
I think you can't.
November 3, 2003 at 1:22 pm
No sure you can even run 64bit SQL Server on 32bit Windows system.
November 3, 2003 at 1:11 pm
DBCC CHECKDB will write an entry to SQL Server errorlog once it completes. You can search specific message in the errorlog.
Modify following script to meet your needs.
http://www.sqlservercentral.com/scripts/contributions/952.asp
November 3, 2003 at 9:29 am
Event ID 9 is related "SCSI Resets" and "SCSI Timeouts" of your storage if you run HP/Compaq machine. Run ADU report utility provided from them and send it back.
November 3, 2003 at 9:04 am
It seems you are tring to change the logical file name. If you run SQL Server 2000, use Alter database command to To modify the logical name of a data...
November 3, 2003 at 8:49 am
I would run hardware check to disk sub-system and send it back to verdor for analysis.
November 3, 2003 at 8:03 am
It could be server alias added by using client network utility from the machine EM is running.
Run sp_helpserver to verify server name. It should be 'SERVERB'.
November 3, 2003 at 8:02 am
Function Main()
Dim oFSO
Dim sSourceFile
Set oFSO = CreateObject("Scripting.FileSystemObject")
sSourceFile = "C:\SourceFile.txt"
' Check if file exists to prevent error
If oFSO.FileExists(sSourceFile) Then
YourAction
End If
' Clean Up
Set oFSO = Nothing
Main = DTSTaskExecResult_Success
End Function
October 31, 2003 at 2:21 pm
The SP runs command "DBCC SHRINKFILE (@LogicalFileName, @NSize)", If you place data file as input, It will shrink the data file. That is why you see your database file size...
October 31, 2003 at 2:15 pm
For example, if you have 8GB memory in total physically in your server. By adding /3GB and /PAE, system will allocate 1GB for itself, SQL Server and the rest applications...
October 31, 2003 at 2:12 pm
Performance monitor counter, SQL Server:Memory Manager Total Server Memory (KB) tells you how much memory SQL Server consumes.
By default, System will reserve 2GB for itself and the rest for applications...
October 31, 2003 at 1:47 pm
No, It can be local system or domain user account but no necessary to be admin account.
From BOL.
"Using the Local System Account
The local system account does not require a password,...
October 31, 2003 at 1:18 pm
Using AWE Memory
To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in...
October 31, 2003 at 12:44 pm
Viewing 15 posts - 886 through 900 (of 2,387 total)