The delimiter (,) and text qualifier (") are two different things in the flat file destination definition. The flat file destination definition should have the final say in what it...

Shot in the dark: In your flat file destination definition, have you specified the text qualifier (usually ' or ")?

I have successfully used DiskKeeper...

INTO is an optional keyword....

I have an update on this issue...

Just before I left for the holiday, I was able to see, using profiler, that the trigger was firing which left my mind in...

OK, that's a step in the right direction. I can see now that it is firing. Can I get it record what the values are for the variables? All it...

Well, that doesn't work either. Is there possibly an issue with having two triggers on the same table that may be causing the issue?

Is there a way to see what...

Jason Selburg (7/3/2008)

---

Anyway, are you intending on updating all records with the same HCODE (multiple records) or only the single record updated or inserted. If the latter, then you need...

nary (7/3/2008)

---

Try to segregate IF (UPDATE(DDELIVERED) OR UPDATE(DMOVEIN) OR UPDATE(DMOVEOUT)) to 3 IF conditions , as i have same kind of triggers in my environment where i use different...

I used FOR since that was how the examples were written. Plus the documentation says, "AFTER is the default when FOR is the only keyword specified."

It seems like it would...

This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

In the Workgroup column on the row for RAM, the limit is clearly stated...

I'm not certified and don't need it. I landed my newest job based on experience, which is more valuable than a piece of paper. I had actually considered certification with...

Great article and thanks for taking the time to write it. I'm not necessarily "seasoned" but after six years with SQL Server, this still sheds a bit of light on...

GSquared (7/2/2008)

---

I missed it because of the typo in sp_attachdb. Thought it might be intentional, but was wrong.

As an aside, Microsoft recommends against that specific method. They say...

I don't see a data sources folder. I think the data sources were created in each folder.