Luis Cazares (9/9/2015)

---

You just accumulate the row counts. Be sure to initialize your variable to zero to avoid getting a null value.

while

process a chunk

set...

@jeff:

Sure, there are 90 million rows, which I have load to two corresponding tables. If one fails, the other shouldn't be loaded as well.

I think about doing this...

I tried to remove the sequence as well. But the problem is still not solved.

It is weird, as I tried to reproduced the issue with a simplified sample, but was...

ScottPletcher (9/4/2015)

---

Does the log table have an identity column? Did you try removing that column and see if the table is still locked? Typically multiple tasks should be...

I will consider it on the next solution. Current solution is nearly...

spaghettidba (9/4/2015)

---

Possible solutions:

1) Don't log from the stored procedures. Use a different connection from the application.

2) Log to a table variable and dump the logs to the permanent log table...

yes - Its not only one report but all reports which are looking fine on another server. I simply deployed these reports to the new ssrs installation. so I think...

yes

I have tested it with firefox and ie and from differed os. No difference..

Actually, performing loops and tests in other languages is much easier. T-SQL is not that great a language in regards to either performance or feature sets. T-SQL's main advantage is...

Regarding the datatype discussion:

I think it's a great idea to copy data to staging tables using a varchar datatype in the first step. You can check the datatypes in the...

Meanwhile I found out, if I start internet explorer "as Administrator", it works. If I just doubleclick ie I have the described problem.

So, I think, the cause is found.

Thank...

Yes I am. It's Windows 7, perhaps this is the cause?

No, there isn't.. 😉

try this:

-- creating testdata

if object_id('tempdb..#datetab') is not null

drop table #datetab

create table #datetab(

datecol datetime

)

insert into #datetab (datecol) values ('20091203')

insert into #datetab (datecol) values ('20091203')

insert into...