thank you for the reply, I think for now this solution will work.

Thanks.

I'm not sure if there's a problem, I have not seen this query before and I was inquiring information about it. I see now that updating statistics generates these...

This is all that the sql monitor tool throws out to the log:

SELECT StatMan([SC0])

FROM

(

SELECT TOP 100 PERCENT [AT_field_3] AS [SC0]

FROM [dbo].[tablename]

WITH

(

READUNCOMMITTED

)

ORDER...

I have a job running statistics, that's generating it?

use [DatabaseName]

GO

UPDATE STATISTICS [dbo].[tablename]

WITH FULLSCAN

GO

Do you know why is selecting some tables and not others?

Well, a new day and new outcomes. After struggling with this problem for a half a day yesterday, this is what I did this morning.

1) Added a new dummy...

I dropped userB from the database and I tried changing the owner of the databases by going through the database properties and changing the dbo user that way under the...

I'm looking through all my logs and going back further.

I did a quick test on my personal machine that run sql server. I ran a backup of the database...

I ran a DBCC CHECKALLOC(database) and DBBC CHECKCATALOG(database), both commands ran without any errors.

It has been a couple of backup since we started getting this error, if we restore one...

Thank you for the suggestion, I tried and it works pretty good.

Pretty clever.

It's a combination of different servers, production, test and dev. I'm new to this job and I'm learning what to expect from this systems but I know that at...

Ok, that sounds good. Putting in my own words to make sure I'm understanding, if my servers have a high PLE it's ok because their memory space is not...

I agree completely, we should have not excuses to "forget" backing up a database. I have to admit, I have done that exact same thing in the past and...

---What are the contents of your maintenance plan? Does it rebuild indexes base on a fragmentation threshold.

I'm using the default setting for the rebuild index task which generates the...

The job ran successfully. Thank you.

do I need to run this script after hours to prevent getting in the way of users?