Hi Matthew

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ObjectDisposedException: Cannot access a disposed object.

Object name: 'Invalid attempt to call Read when the stream is closed.'.

System.ObjectDisposedException:...

Hi David

Thanks for your feedback.

So, I should goon with my source data structure? Independent of the snowflake in this case? There are not too many rows in this complete structure...

Hi Vaibhav

SQL Server Compact does not support things like linked servers. If your table doesn't contain too many rows, load them into a DataTable, set the rows as modified and...

You can find Profiler in menu -> Tools -> SQL Profiler. Have a look for events "SQL:BatchCompleted" and "RPC:BatchCompleted".

For triggers read this article:

CREATE TRIGGER

Greets

Flo

Cross post...

http://www.sqlservercentral.com/Forums/Topic836828-361-1.aspx

Hi

You can use SQL Profiler to trace your table. Another option would be a trigger.

Greets

Flo

Hi

Do you really not have any criteria you provide from your outside table1 into your sub-query?

Did you check your...

Hi

Please provide some more detailed information how you handle your data deletion. Do you work with a cursor?

Greets

Flo

Congrats Screw!

And thanks for all your time to do those tests 🙂

Greets

Flo

C# Screw (11/18/2009)

---

Florian Reischl (11/18/2009)

---

Hi C# Screw

Good point, maybe try this instead of the StringBuilder:

string[] parts = s.Split(new char[] { ' ', '\t' });

return string.Join(" ", parts);

But I think the...

Paul White (11/18/2009)

---

Flo - thank you so much for the Tui billboard :laugh:

I should have known you'd get your revenge! Man, that made me snigger out loud at my...

Hi C# Screw

Good point, maybe try this instead of the StringBuilder:

string[] parts = s.Split(new char[] { ' ', '\t' });

return string.Join(" ", parts);

But I think the char-loop based solutions will...

Good morning Paul!

Well, now I have to say this to you:

I don't know how much you are working with C#, but...

C# Screw, try to call him "Michael" or "Michael Meierruth". "Old Hand" is his state depending on the count of posts here - like "SSC Rookie" in your case. 😉

C# Screw (11/18/2009)

---

I could post the assembly as CREATE ASSEMBY <assembly bits>

Then others could test - but I am worried to do so its asking people to install a dll

that...