Understood. But are there any issues with using the Local Machine account?
I have an app which I ideally want to authenticate as a pre configured domain service account. We have been advised by the vendor that this is not...
I have been doing some DBA work for a while now and I typically match vendor recommendations for their databases to the actual version of SQL Server....
At a 10,000 foot level..... why did you chose to do this via a cursor? Cursors are notoriously inefficient and my quick review of your code did not...
Typically it is a permissions issue with the perfmon service. Make sure it uses a log on that has sufficient permissions.
I just meant that you are running on x64 hardware with an x64 OS and x64 SQL Server. You could be running x32 SQL Server on x64 hardware with an x64...
Really? Are you saying Diskkeeper is going to help in this situation because the table is a HEAP or Diskkeeper would help with actual index...
What you have there is a HEAP. Simplest way to remove the fragmentation would be to add a clustered index.
If you are running true 64-bit across the board, there is no need for AWE.
Monitor a DBCC SQLPERF(LOGSPACE) and see if the % Used within the log is increasing as your app does it's writes. I am guessing your app is not...
Quick and dirty off the top of my head...... --For SQL Server 2000 DECLARE@DBName VARCHAR (50) ,@dSQL VARCHAR(256)DECLARE recDBname CURSOR FOR...
Am I correct in that you would expect to see this error thrown from a page/object that experiences a high level of I/O? SYSXLOGINS does not fit that...
Another tidbit of information..... that page referenced belongs to sysxlogins. This does nothing to clarify the issue for me. Anyone else have any...
Actually I did not do the CHKDSK until this morning. THe problem never came back after the initial reboot. I am of course paranoid that it may come...
On Friday night I had a very important server go down as a result of a: Error: 845, Severity: 17, State: 1 Time-out occurred while waiting for buffer...
Separate names with a comma.
