Viewing 15 posts - 1 through 15 (of 138 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...
-Dan
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...
-Dan
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...
-Dan
May 11, 2005 at 1:43 pm
Did you say that you DELETED the physical log file (LogFileName.ldf)?
-Dan
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...
-Dan
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...
-Dan
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.
-Dan
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...
-Dan
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...
-Dan
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.
-Dan
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...
-Dan
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...
-Dan
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
-Dan
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...
-Dan
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...
-Dan
August 14, 2003 at 4:33 pm
Viewing 15 posts - 1 through 15 (of 138 total)