...and thanks for the feedback! 🙂

Did you test them with the code I gave you because it solves the two originals I posted just exactly as you stated the results should be.

You cannot use locking hints that way... period. 😉

Ummm.... ok... how do you know it's supposed to insert into MSArcLong in the database you have setup?

The only other thing I can think of is that the app has...

Ummmm.... can't you at least give it a try on your own?

Ah ha! I knew I had an example squirreled away somewhere. Of course, you can do it with a GUI using ADO and all that... but here's a...

No... the question is simple... you have a Word doc sitting in a directory somewhere... how do you load that file into a VARCHAR(Max) column (only one row, of course)...

Sure it is... you could do a running total of the length of each row +2 (for Cr/Lf) and key your export off that. See the URL below...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

yogesh.khaire (8/10/2008)

---

I have written the Following Trigger on MsArcLong.

and there is no error in it.

because it is executed when data inserted through Query analyser.

Create Trigger Test on MSArcLong

For Insert,Update

As

Insert...

--===== First Data Scenario

TRUNCATE TABLE #MyHead

INSERT INTO #MyHead

(Row_ID,Promo_ID,[Desc])

SELECT '1','1','desc1' UNION ALL

SELECT '2','1','desc2' UNION ALL

SELECT '3','2','desc3' UNION ALL

...

Beer, Pool, Beer, work on house, Beer, work on garden, Beer, ride motorcycle, Beer, talk with good friends, Beer, fishing, Beer, answer questions on the forum, Beer, more pool, Beer,...

If it's been 2 years since the move and everything else is moving smartly, then it could be that the code for the reports just wasn't written is a scalable...

I believe the question is how to load the Word file into the VARCHAR(MAX) element.

And, yes, I agree... it's probably better to store the name of the file in a...

bakerbill (8/9/2008)

---

Leaving MS was not Bill's decision to make. He was given the scope and resources to succeed, but he could not deliver. His mistakes eventually became too costly to...

Waseem Jaleel (7/21/2008)

---

once u complete attach/rename, u need to fix the users for the db, as there will be an SID mismatch since you have moved it to a...