Sorry, my fault: "SqWB- Sql Server Management Studio has encountered a user-defined breakpoint"- every time I try to connect to Database Engine. After pressing OK button SSMS closes.

Sorry for renewing this 2 month old post but I've just got same issue after installing SP1 on Sql Server 2K5. I mean after installation was completed and I rebooted machine I can not...

OK, thanks, I hope I've got it.

Sergey, thanks. I need to evaluate what is better for me- use your approach but maintain code manually (in case new fields will be added I need to add same number of...

From my busines point of view cursor variant is better because in case new columns will be added this variant will manage them automatically. Thanks

Aaron, thanks. I've already done with cursor and dynamic sql (almost your variant). Actually I try to avoid using cursors so I hoped for another decision (what I called "more...

Thanks, guys, for your responses.                                                                          Actually I've already added this switch and checked from TaskManager-Processes that sql server consumes more than 2G (I saw 2.7G). But now I confused with...

Thanks, this way works

I just tryed on Sql Server 2K (SP3)- same story (we have second RS), i.e. if function comprises direct "pure" url like "http://www.microsoft.com" everything is OK, but in case...

Thanks, man, for your response and help. Our RS is on Sql Server 2005 and I use BI Development Studio for Sql Server 2K5 also. Thanks

Sql server will do this trick. At least, for me it's working

Have no idea why is this but your way does not work for me (sorry). I mean when I build html string as you pointed RS does not recognize it...

OK, thanks, I'll try this way. I remember that when I've done this last time I did not create any custom function. Anyhow, thanks one more time

Cool. Where/how I need to point this? Thanks

Thanks guys. Probably BOL explanation is slightly confusing. For example, for TruncateOnly option there is "Causes any unused space in the data files to be released to the operating system",...