" the load balancer (an F5 appliance) was configured to do round robin routing amongst 40 web serveres and as such would rarely be able to hit the same server...

Probably it works well because correct order_id and order information is inserted into the tables. Then SP returns order_id into the code, assigns it to the session variable. At this...

"This behaviour is expected when PK-FK constraints are not defined correctly. "

There is no FK actually. There is only PK order_id and SP inserts into this table only to get...

Hi Beth,

You cannot convert, I had to rewrite everything. It took me two days with testing to finish it and move from SQL Server 2000 to SQL Server 2005....

Yes,

I used script task and it worked. Never use ActiveX anymore...

Yes,

the person who made a table used a clastered index. I would make just one primary key and use three other columns as foreign keys. But he used a combination...

Andras,

I read that. I run rebuid for the index that was recommended to be rebuilt and it didn't help, it still suggested me to rebuild it in the reports. Index...

I just fixed it. I found an answer here http://www.sqlservercentral.com/articles/Advanced+Querying/tamethosestringspart9/637/

SELECT @last_name = REPLACE( @last_name, '''', '''''')

Karen,

You are right, I figured it out, that was exactly the case. Thanks!

I found an answer myself. In the reports use only SQL server user authentication for datasources, never ever Windows because it's so screwed...

Thank you very much, everything works wonderfully! I just finished that report!

Somebody else sent me this. "

The temporary tables are session based, meaning that if you and I run that same report, we will have our own temp tables and...

So it doesn't answer my question. If I have reporting services and report there that uses a stored procedure that creates a temporary table with the static name let's say...

Thanks. I'm just worried about time. Would it take more time for the report to run if I replace table variables with temporary tables? Also table variable is local and...

This is what our instructor in class and Microsoft say: "re-write them". We also moved dts packages to SQL 2005 and scheduled them. Now some of them fails to run and somebody's...