Viewing 15 posts - 1 through 15 (of 137 total)
Just an FYI...I currently have a support case in with Microsoft about this issue. Although it may not be the same scenario, we started experiencing this problem when we updated...
August 1, 2006 at 1:14 pm
You should remove the DATEADD statements from the column side the statement. The server can't use the indexes properly if you run a calculation on the indexed value. Try something...
May 23, 2005 at 1:40 pm
The /PAE switch is only required when you have more than 4GB of system RAM. If you have between 4GB and 16GB of system RAM, you should use both the /3GB...
May 11, 2005 at 1:43 pm
Did you say that you DELETED the physical log file (LogFileName.ldf)?
May 11, 2005 at 11:41 am
Just an update, we ended up bringing in new hardware (not b/c of this problem though). I just set up the new machine with SQL 2000 SP3, RESTOREd all the...
October 6, 2004 at 2:56 pm
It could be database corruption, or a bug in the server. You'll most likely have to get Microsoft SQL support on the phone to find out for sure. Here is...
October 6, 2004 at 2:51 pm
Have a look at Microsoft KB article KB288095: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q288/0/95.ASP&NoWebContent=1
Looks like the problem, most likely.
October 1, 2004 at 4:18 pm
You won't be able to see the network drives/shares, but you can still access them by typing in the UNC path names.
Like this \\anothermachine\c$\backups...
September 21, 2004 at 9:31 am
There is a known issue(bug) with the checkpoint handler and ghost cleanup not playing nice with each other. If you are performing heavy data updates, more specifically delete operations, you...
July 7, 2004 at 3:42 pm
You should be able to fix this with "DBCC UPDATEUSAGE('tablename') WITH COUNT_ROWS.
This will fix incorrect values in sysindexes, and the sp_spaceused statement will then return the correct number.
April 28, 2004 at 9:15 am
We have a server with 6GB of RAM. I have the /3GB and /PAE switches set in the boot.ini. The server has the "awe enabled" option set to...
November 17, 2003 at 4:04 pm
I would use this method:
-- Allow this NT user to login to server...
exec sp_grantlogin 'mydomain\newUser'
-- Grant access to that db...
exec accounting..sp_grantdbaccess 'mydomain\newUser','newUser'
-- Attach role to user...
exec...
October 27, 2003 at 4:18 pm
Run this command in each DB, replacing 'security_account_name' with the actual user account name.
EXEC sp_addrolemember 'db_owner','security_account_name'
-Dan
Edited by - dj_meier on 10/13/2003 2:34:44 PM
October 13, 2003 at 2:29 pm
The transaction log backup should truncate the log file to the point of the last backed-up entry. A full backup will not truncate the log, only a log backup...
August 14, 2003 at 4:45 pm
You can use DBCC LOGINFO(dbname) to see which virtual log segment is active. The trans log is actually divided into multiple "virtual logs." If you notice that there...
August 14, 2003 at 4:33 pm
Viewing 15 posts - 1 through 15 (of 137 total)