You can also use sp_execsql for this.

You can also consider the option to run a single query that will update all rows in a single pass (assuming it's possible).

I'll vote for that again here... just to be safe :).

I know Steve... what I hate abput it is that it takes 10 secs to do instead of 1 like it used to do in the old forum.

The redirect to...

Got beaten to the punch on this one (AS bug).

Thanks for all the quick fixes Steve.. and Steve... and Steve :D.

One more thing.  What happens when 10000s of concurrent users login / log out of the server and your profiler trace is running?

I doubt this has a serious impact but...

I second that, give us an option in our profile like for the topics to show (10,20,30,40,50) messages per page. 

Much more fun for us to use that way.

You can run this query to test it yourself :

SELECT

1 WHERE NOT(0 =...

Thank you Steve for the quick reply.  But this is not the question I asked :).

I meant that in the old version of the site I had 9600 posts, now...

Maybe a more appropriate place for this question :

How does the new points system work?  It used to be only the # of posts, but apparently something else counts...

That would be a great idea Steve.  Can you tell us how the new point system works?  Last time I checked, I only had 9600 posts or something like that.

Nah, I wish.... maybe in Katmai.  Anyone has access to those books online??  I have not installed the ctp yet!

Thanx for the quick turn around.  I was not throwing blame out to anyone... just that this was a reallllllly big annoyance for me... and a few more apparently.

As I said, while IT DOESN'T help for this case... that function has a lot of good info...

:).

Please do not cross-post :

http://www.sqlservercentral.com/Forums/Topic401505-4-1.aspx

:w00t:

While it doesn't help for this problem, it can certainly help in a similar situation : COLUMNPROPERTY() has a lot of usefull info.