quote:

---

I have the following:

DECLARE @Name varchar(200)

DECLARE @Text nVarchar(4000)

Can this be the problem?

---

Most definitely...

First let me say this. I HATE USER DATATYPES!

OK, now that I got that off my chest. 🙂 User datatypes are a nice easy way to model databases. Especially...

Look at the topic "Using EXPLICIT Mode" in BOL. Even though the syntax is very strange it works very well. Basically you have to know precisely what your XML needs...

Ouch... Well here is the method I use to alter triggers in bulk...

-- Add the triggers to a working table

IF NOT object_id('tempdb..#DisabledTriggers') IS NULL

DROP TABLE #DisabledTriggers...

OK, If I read what you want correctly I think the following will give you what you want.

DECLARE @xmldoc nvarchar(4000)

, @idoc int

SELECT @xmldoc = '<data>

<line...

Antares,

I've used it as an output variable when all I wanted to do was return a single picture (Binary field instead of text but works the same way). Once you...

If you are using SQL 2K you could also use a table variable depending on the size of the calculation tables.

Gary Johnson

DBA

Sr. DB Engineer

Umm... How about you create a table to hold some sort of batch id and then fill that table with the Inserted values from the trigger. Then have a job...

Well since I'm lazy I just restore a backup of my publisher and then run a script to drop the replication objects (Triggers/Views/SPs). I don't worry about the RowGuid fields...

Yes Merge Replication can do what you are talking about. Yes it will bloat your database size as it adds a rowguid field to each table and views/sps/triggers to the...

This is something I have always done with the front end. The main reason for this is that depending on the clients regional settings you may have the comman there...

tymberwyld,

Replication should still be an option. According to the following (pulled from MSDN)

A SQL Server client access license (CAL) or processor license is required on the SQL Server database...

One work around might be to copy the data from the calculation tables to a true temp table and do all your updates during the SP on the temp tables....

grasch, As Steve was alluding to, I think what you really need to do is something like the following.

CREATE TABLE #t

(

SeqNum ...

tymberwyld

Books online has some great examples on how to do this inside SQL Server. Having said that I would opt not to do the XML from inside SQL Server unless...