to eliminate any hardware related issues causing data-integrity compromise, you could try upgrading to sp4 and see if that resolves the issue ...however, googling revealed that heaps of other people...

at any rate, it is now a moot point - moo - since it just can't be done...

i think you should look at...

jasmina - please note that -

The altered column cannot be:

A computed column or used in a computed column.

A replicated column....etc..

are you sure you didn't mean to say user table instead of system ?!

also if you don't mind my asking - what table are you trying to update and why...

Chip - here's some info from the MSN site for pointers/guidance....

"Because a stale read or a lost write results in data storage that is not expected, a wide variety of...

Have you tried creating a separate column for the arabic data and setting the collation on it to - SQL_Latin1_General_Cp1256_CS_AS - or whatever the collation is ?!

as for configuring the...

Picking up where Lee left off...maybe the 2 methods he listed should be combined to use nested sprocs ?!?! - Hopefully - even though the range of parameters is 1...

maybe the quickest way would be to:

set rowcount 6500

Select Top 1 CustomerID From Customer order by CustomerID DESC

raj - your num_type_name and num_type_id cannot possibly be integers if the values in them are 'T1' & 'Type 1'...

also, if the number columns are integers, you seem to be...

Erik - the '' that I set was only the default...I don't even know what your procedure is going to do...I gave you a "general guideline"...you can set a default...

Erik - you could have a default value for your optional parameter and in your code can specify conditions based on the value of the parameter...

eg: you can have a...

you could search the site for articles....

here's one on setup and deployment that may help you...

2005 setup and deployment

you may also want to look at the INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS view to see if you could create one of your own....this view uses the sysreferences, sysindexes and the sysobjects tables...

Brian - I'm curious about what you mean by "Query Designer" - do you mean Query Analyzer or is it something else ?!

raj - sergei's questions are valid ones...why are you using string values in what seem to be integer columns ?!

also, could you pl. post the ddls of your 2 tables...specifically...