I created temp table, 1 row for testing and the code to show you that you can do the update with larg data if you using NVARCHAR(MAX)!

Maybe you should post...

Steve I think you need more moderators to clean the posts in wrong sections!

You can test here!

CREATE TABLE #TESTING

(

ID INT,

TEXTING NVARCHAR(MAX)

);

GO

INSERT INTO #TESTING

SELECT 1, 'YOUR LONG TEXT MAYBE HERE!';

DECLARE @TEXT AS NVARCHAR(MAX)

DECLARE @ID AS INT

SET @ID = 1

SET @TEXT = ' bLLA BLLA...

ok ... try declaration as NVARCHAR(MAX)!

Simple ...NO! - I don't have...

I agree with you Lynn Petis ...but better will be like this:

SQL Server 2000

Administration

General

...

Did you install indivitualy in 3 machines or just in one ...so...

Why not to see the forum more simple organized...I agree...not bad idea!?

😉

hmmm interesting info here ... what about Identity columns if you want to reseed ... or check the identity value ...do we have any other possibility such as DBCC checkident...

:hehe: I told you ganeshmuthuvelu

that someone will do like magic man ...now here is Jeff amazing code generator!

:w00t:

No question here ...Steve delete it! :hehe:

Jeff Moden (12/27/2008)

---

Just for grins, here's the CTE version without TOP...

;WITH

cteTally AS

(

SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS N

FROM Master.sys.SysColumns

)

SELECT DATEADD(dd,(t.n)*14,'20090102') AS BiFriday

...

kha_ang (12/27/2008)

---

Hi Dugi,

Thanks for your response. Please bear with me as I am new to this.

1) what service(s) to leave it ON and how?

2) input a "." as the...

interesting variable value ...at first when I saw your sample data it shows me the logic that max_value - min_value = allowed_value but the last record doesn't have this logic!

we...

Make sure that your services are running or just put the dot as servernamen ( . ) and try!

let me know what next!?