Mbrood,

Im facing similar kind of issue where a job is running for a very long time and when checked the process it shows that the waittype for the...

When the db's are detached & attached to SQL2K5 the compatability level for the db must be changed to 90. If not some of the new features will...

as you said if the script is taken for a user db and run it should not replace other logins and db access.

Well try one thing use the...

Hearty Congratulations STEVE....Good show....

Its delayed but you really deserve it. Keep going in providing more such solutions.

Cheers

Murali.a

Thank u all folks for your responses.

There were some active transaction that was running for a very long time could be due to that.

Murali.a

yes but it would be a very lesser amount, not that much to say an error like "Log is full. Backup the tran. log".

How to check this huge growth...

Jeff that's great man...I like the way you thought about ....

keep posting such stuffs man.....;)

Murali.a

Initially we thought of doing that but the server owner has not shown interest to continue with that...but is there a way to identify whether the mem-to-leave is fragmented or...

The same had the case with me and i have applied the fix to get use of my memory. I had fixed memory on sql to use 3gb and previously...

Ok. I have checked it before but that's no the case. It does use 4096 and the application uses the same size when checking with a trace.

I also doubt that...

Will check that..

But by disabling these setting will the warnings go.

adding to the above one.

Initially after enablilng awe and /3gb switches sql server was not taking beyond 2gb of memory, then we have applied a hotfixkb899761 and...

folks, thanks for all your response.

The above said server is a cluster one (active\Passive) Let me know if the above said can be tested out or is...

anything beyod 2gb would required awe to be enabled right?

Still no hint in resolving the above error. Let me know if any other updates about this.

Murali.a