asked on

sql message error when press on save button

the following message display when press on save button in the application

Transaction aborted when accessing versioned row in table 'dbo.inserted' in database 'wf10taa'. Requested versioned row was not found. Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.

No changes made to database.

UPDATE cutheader SET cutno = 9702326, issuedate = '6-27-2013 0:0:0.000', duedate = '10-20-2013 0:0:0.000', completiondate = '7-18-2013 0:0:0.000', total = 29800, closed = 'Y', userid = 'medina1', user_date = '11-19-2013 16:36:36.555', style_header = '13ZH6737373', color_header = 'BLACK', ms_type = NULL, warehouse = 'PS', productionid = 0 WHERE cutno = 9702326

this happen only in one terminal from other place it allow to save
i tried restart and it does not help
i have access to SQL database
the sql is running on windows server 2000 i think its MY SQL

what its mean "Your tempdb is probably out of space"? how i can fix this?

please advice
thanks
Gvilbis

SOLUTION

Daniel Wilson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gvilbis

ASKER

how do i increase the size of tempdb? is it has to be done on the machine where the SQL is running? if yes how it could be that it happen on one terminal only?

Thanks
Gvilbis

SOLUTION

Daniel Wilson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gvilbis

ASKER

i am the person who responsible to that machine
i have SQL studio manager installed, what action to take?

thanks
gvilbis

ASKER CERTIFIED SOLUTION

Daniel Wilson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial