maybe you can go back to your original msdb -> start sql server -> use emergency mode on msdb -> try some checkdb?

there is a great stored proc: sp_lock2 maybe it will help you ?

you can it from: http://support.microsoft.com/kb/255596

you are using AWE on this 32bit box - in this case task manager has some "nice features" that dont shows all of the memory that sql server is using....

using dbcc updateusage helps ? it shouldn't. there were some problems with counting allocations but on sql server 2000! 2005/2008 are running good. the only way it can be a...

so ...

1) any data write goes to the memory

2) during updating non-indexed column witch wasn't included by any index - there is no size growth/page split

3) during updating non-indexed column...

Hi Kwisatz78,

once upon a time with my colleagues we were trying to check the differences between fixed size db files and default database settings. We were loading something about 20GB...

maybe you can create a configuration table with proper schema? I think it can be better then global variables (easier to mange and more relational).

As Animal Magic said - problem is in security setting in report's data source. This is quite complex but we can look at this in these way:

if you are maintaing...

As a consultant ive seen a lot of environments - some of them were using sql, other were using windows and some both types of authentication. Like other people said...

hi shine,

you told us that the configuration of these two servers are exactly the same. In previous posts someone mentioned about IO problem. I think it's quite posibble. You can...