I hope they fix it soon. The credits I believe are unnecessary to return (since they do not count for anything) but the answer shuold be changed to the right...

I would go with the staging table approach (temp table). That gives you the most control and could give you a good 'patten' based approach to your ETL problem. I...

Agreed. Screen (web) scraping is bad, very fragile solution and most often generates ugly and unmaintainable code.

Try to contact the content provider and see if they can offer you...

He probably means caching or building 'summary' tables (or materialized views)...

...or maybe some Admin that fixed the starting tag...

Hehe. Maybe someone closed that open ended <table> (if that was the problem)...

RGR'us: Thanx. But then it is browser independant, both Firefox and IE deals with it the same way (your quote is inside my message (my prior quote)). I have never...

Just a quick correction. Latin_General_CI_AS does not exist but Latin1_General_CI_AS exist in SQL Server 2005 but it is not new and has existed since SQL Server 2000 (when collations became more granular...

Just a quick correction. Latin_General_CI_AS does not exist but Latin1_General_CI_AS exist in SQL Server 2005 but it is not new and has existed since SQL Server 2000 (when collations became more granular...

Hello,

For 'login failure' not much is being traced by the profiler if the user tries to use SQL Authentication... Anyone knows a way of tracking more information for that event? IP address...

Yes, but by 'both' he probably meant using only multi statement Stored Procedures in T-SQL (just using .NET by calling the SPs) compared to using .NET objects to do multiple single T-SQL statements.

Even if...

Okay, then I think we understood the poster in two different ways.

The references you gave described only the .NET way of handling transactions. While I think the poster meant having...

I would like to get some clarification of this. How can you say that ADO.NET transactions are more effective then transactions in pure T-SQL? Are you saying that, for example,...

Excerpt from the first lines on the PSEEC homepage:

PsExec is a light-weight telnet-replacement that lets you execute processes on other systems, complete with full interactivity for console applications, without having...

You didn't read the link about PSEXEC I wrote, did you?