When using the FOR XML method described in the post by feeza_ibrahim (third post on page 1 of this topic) make sure the column does not contain other than preceding...

Hi Kyle,

at the end of your article you state : "There is not an equivalent to Truncate in T-SQL"

Maybe I missed something but what's wrong with the round function (with...

ALZDBA (9/8/2008)

---

just curious: Do you have "auto shrink" enabled for this database ?

(Bad practise ! If you actually need a shrink operation, you'd be better off doing it in a...

Sorry, no execution plans, probably they will be (very) different but even if they were the same...

Thank you for your reaction

Ninja's_RGR'us (9/5/2008)

---

1st of all, autp update is triggered after a huge % of the data has been changed (5% or 20%)... not before that... so you...

Seems almost exactly the same problem as the one I posted about this afternoon

http://www.sqlservercentral.com/Forums/Topic564531-65-1.aspx

Can you track if anything is happening? is p.e. the rowcount of the destination table going...

First select the "execute sql task" , then select the input file (using ctrl) and add the workflow.

The arrows always starts at the task you selected first. If you select...

chris.surfleet (7/17/2008)

---

I'm not getting any line numbers reported at all actually, I get the error almost instantly. I've looked through the first few lines and can't see anything that should...

usman.tanveer (7/10/2008)

---

Hi,

I have a DTS package in sql server 2000. When i try to open this package it gives me an error. "DTS Package Error--- Invalid Class String"..........

Any...

nikhil8960 (7/8/2008)

---

I have some global variables which are set at run time in DTS packages. Now I want to use those variables in my execute SQLtask to set some local...

Meanwhile I found the answer on the release notes of WIN XP SP3 (http://download.microsoft.com/download/c/d/8/cd8cc719-7d5a-40d3-a802-e4057aa8c631/relnotes.htm)

Scripting

If you change the regional and language options to a different setting from those used...

katemcginnis (5/7/2008)

---

I have a Parent DTS (A) which has as one of its steps an execute package task which in turn calls a second DTS (B). I'm trying to...