Hi Marcus,

Thanks. I am able to use script to change the setting. My question was why is the GUI option grayed out? Any thoughts? thanks.

Thank you Sameer.  Is there any work-arounds that you could suggest so that I could get the data (and all db objects) of the SQL 2005 and into SQL 2000?

Thanks

Frank

Noel,

Thanks for explaining this behavior.  I was unaware the the 'select' statement was considered one transaction.  I guess the behavior changed since it was introduced in version 7.0.  Anyway, your...

It will allow me to do the insert if I don't specify the @@DBTS function, but that does not get me what I need.  I need the unique value for...

* Please do the above table creation/code execution in sql 200 sp3.  This currently works in sql 7.0.

Could someone please run the below code and see if you get the same problem that I am getting with regard to the new_posting_key field is not displaying the updated...

I did try switiching the db compatability back to 7.0 and I'm still getting the same behavior.  This does not make sense....

Are you referring to compatability at the db side?  Change it back to sql 7.0?

Hi Noel,

I don't have any triggers and here is the code I'm executing:

insert into ft_work.dbo.rp_work

(

post_prefix,

post_no,

record_type,

proj_no,

emp_no,

form,

tran_date,

line,

post_date,

old_posting_key,

--invoice_key,

new_posting_key,

serv_code,

hrs,

rate,

distance,

workplace,

city,

[description],

amount,

product_no,

glacct,

prov_state,

enter_div,

tax_code,

emp_div,

sup_div,

std_rate,

std_cost,

expense_type,

prod_type_code,

multiplier,

totvatax,

admin_amt,

company,

prod_rev_code,

proj_rev_code,

div_rev_code,

serv_rev_code,

intco_type,

post_code,

reason_rev_code,

acct_date,

acct_year,

acct_period,

open_flag,

open_tran_date,

closed_tran_date,

tag,

postrev_id,

matrix_match,

with_company,

debit_admin,

credit_admin,

debit_vatax,

credit_vatax,

ledger_curr_code

)

select

posting_revenue.post_prefix,

posting_revenue.post_no,

posting_revenue.record_type,

posting_revenue.proj_no,

posting_revenue.emp_no,

posting_revenue.form,

posting_revenue.tran_date,

posting_revenue.line,

'07/19/2005',

--@dDateTime,

posting_revenue.posting_key,

--@vbBatchId,

@@DBTS,

posting_revenue.serv_code,

posting_revenue.hrs,

posting_revenue.rate,

posting_revenue.distance,

posting_revenue.workplace,

posting_revenue.city,

posting_revenue.[description],

posting_revenue.amount,

posting_revenue.product_no,

posting_revenue.glacct,

posting_revenue.prov_state,

posting_revenue.enter_div,

posting_revenue.tax_code,

posting_revenue.emp_div,

posting_revenue.sup_div,

posting_revenue.std_rate,

posting_revenue.std_cost,

posting_revenue.expense_type,

posting_revenue.prod_type_code,

posting_revenue.multiplier,

posting_revenue.totvatax,

isnull(posting_revenue.admin_amt,0),

posting_revenue.company,

posting_revenue.prod_rev_code,

posting_revenue.proj_rev_code,

posting_revenue.div_rev_code,

posting_revenue.serv_rev_code,

posting_revenue.intco_type,

posting_revenue.post_code,

posting_revenue.reason_rev_code,

posting_revenue.acct_date,

posting_revenue.acct_year,

posting_revenue.acct_period,

'N',

posting_revenue.acct_date,

posting_revenue.acct_date,

'N',

posting_revenue.timestamp,

'N',

posting_revenue.company,

0,

0,

0,

0,

project.ledger_curr_code

from posting_revenue,  project

where posting_revenue.post_prefix = 'CEN'

and posting_revenue.post_no = 241917

and posting_revenue.proj_no = project.proj_no