Have re-installed SP2

and now all is working as should be.

WOW.. So simple.

So much searching around and no answer.

Thanks

No I did not install any service pack after installing RS

We already have SP2 installed.

Is it worth re-installing SP2?

The current build is 9.00.3068.00SP2Standard Edition

have you tried BGINFO

http://technet.microsoft.com/en-gb/sysinternals/bb897557.aspx

Lists all Pc or server hardware details and OS details.

You have the memory available and assuming you not running any other applications on the server I would be tempted to assign a fixed memory amount of 2GB to each...

Hope this helps

Memory – 2GB

Model – ProLiant DL360 G4

Processor –3.80Ghz Xeon

Win 2k SP4

SQL 2k Standard

our infrastructure team are thinking of upgrading to 4Gig of ram,

Though not sure what benefits...

The only errors i see is:

SQL Server could not spawn process_loginread thread.

WARNING: Failed to reserve contiguous memory of Size= 262144.

Buffer Distribution: Stolen=8090 Free=9161 Procedures=3735

...

Thanks for the advise but I already have work arounds, and infact if i do a select * from View from a query window then all works but it does...

I have recreated the view as an administrator but it still times out with errors

Again if ran under a particular account it runs fine.

But we need this run under all...

Hi Erich

I should have said.

On the SQL server we have also updated to oracle 10g Client

But no drivers was installed and I remember reading somewhere that 10g drivers also...

Abhijit

Thanks for the reply but please can you explain how to modify and recreate the view,

Sorry should have said i am a newby LOL

Time: 05/28/2008 13:19:47.245

KB Number: KB921896

Machine: AP38-0029

OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)

Package Language: 1033 (ENU)

Package Platform: x86

Package SP Level: 2

Package Version: 3042

Command-line parameters...

Funny you should say that as that is the reason i am upgrading from the RTM release.

maintanance plan wizard is corrupt and jobs are now failing.

I believe SP2 and adding...

LOL,

Many thanks for your help, I am awaiting a response from the user as to what they are hoping to achieve with this.

Yes they do,

Think I will have to remove the trigger for now and get the developers to look into this.

Unless you can spot any think else that could be so...

Ha, getting there,

Yes there is a trigger, when i create the same table without the trigger then all is ok.

But not with the trigger?

USE [infocarenotts-test]

GO

/****** Object: Trigger [dbo].[trg_UpdateProcessedData] ...