Currently, there are no rows in the MetaEvents table. Yes, I'm trying to update that table with the 1 row that is returned from the select query from the...

Hi,

Just wanted to update my post. It turned out that a table in the ReportServerTempDB database was corrupt. The weird thing is that I ran DBCC CHECKDB on...

Hi,

It looks like there is a problem with Reporting Services. I found this in the log:

ReportingServicesService!dbcleanup!1a2c!12/26/2007-00:04:34:: e ERROR: Sql Error in CleanExpiredSessions: System.Data.SqlClient.SqlException: Page (1:28575), slot 1 for text,...

Hi,

I already saw that article and we are not running SQL Server 2000 with an affinity mask and we are not seeing any other errors. It is frustrating because...

No, we are not currently using Database mirroring on this server.

Isabelle

Hi,

I will take a look at that paper on SQL performance troubleshooting. We are currently working with a Microsoft engineer:

Sanjay Karmakar

Microsoft SQL Server Support Engineer

I just thought I would...

Hi,

I will forward the suggestions about the hyperthreads to my sysadmin and take a look at the scripts you provided. Actually, we have purchased the SQL Diagnostic manager but...

Hi,

Unfortunately, 64bit is not something that we are thinking about at the moment. We only have /PAE enabled in the boot.ini

This is what is in the boot.ini

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(2)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows...

Thanks for the info. It looks like I have it in correctly. I wonder why it did not generate the dump log then?

Isabelle

I am still having trouble with this.  Even though I only gave them select to specific tables and have verified that they are not a part of any roles other...

I am experiencing the same issue as Ryan.  I have run the DMV

sys.dm_db_index_physical_stats and got the information that my index was 80% fragmented.  I rebuilt the indexes and...

I got it to work using the following:

select vw.whse_code, vw.item_code, vw.qty_onhand, MAX(rh.date_rcvd),

CONVERT(VARCHAR,MAX(rh.date_rcvd),12) AS CONVERTED_LOT 

from incinvw vw, incinv1 v1, podinrh rh

where v1.lot_control_ind = 0

and vw.whse_code = 'W011'

and rh.item_code =...

Any new inventory item entered into the system will get the number generated automatically by the application.  This is just a one time deal to get in our inventory from...

As I said, since we have both 2000 and 2005, I got confused and forgot this was in our SQL 2000 database.  Sorry.

I actually created an identity column which created...

Hi,

I'm sorry, but I forgot that this is a SQL 2000 database (we have both 2000 and 2005 and I got them confused) so when I try to use the...