Bulk extract/export BLOB data?

Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
kit) that will bulk BLOB export data?
MortenTextcopy.exe might be what you need.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"hansiman" <hansi@.hotmail.com> wrote in message
news:7a8pp050vnkp7f1se31lpr9o6rljg2ie2h@.
4ax.com...
> Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
> kit) that will bulk BLOB export data?
> Morten

Bulk extract/export BLOB data?

Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
kit) that will bulk BLOB export data?
Morten
Textcopy.exe might be what you need.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"hansiman" <hansi@.hotmail.com> wrote in message
news:7a8pp050vnkp7f1se31lpr9o6rljg2ie2h@.4ax.com...
> Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
> kit) that will bulk BLOB export data?
> Morten

Bulk extract/export BLOB data?

Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
kit) that will bulk BLOB export data?
MortenTextcopy.exe might be what you need.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://weblogs.asp.net/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"hansiman" <hansi@.hotmail.com> wrote in message
news:7a8pp050vnkp7f1se31lpr9o6rljg2ie2h@.4ax.com...
> Is there a tool (like Bulk Image Insert (bii.exe) from sql resource
> kit) that will bulk BLOB export data?
> Morten

Built in report tool returns dollar symbol not pound symbol.

I can't be the only one to of noticed this but my local setting are all set to United Kingdom, but when using the in built reporting tool I always get dollar symbols.
The command I used to format the text box was the formatcurrency() express which states it will format the text in accordance with the settings in control panel. The only thing I can think of is that it is either using a system default setting (were on a domain with roaming profiles) or it uses the language as set on the SQL server (which I haven't checked yet).

Anyone else noticed this odd behavior or know where you type the expression pattern to make a custom currency format for UK?

I use a custom format entered in the Format code: box

￡#,##0.00

|||Yeah thats, the method I used in the end. Shame the formatcurrency() function doesn't do what it should out of the box.
Thank you. |||

Yep, I'd be interested to know why we can't default to local currency settings as with say Office programs...

Let me know if you find out :)

|||Yes, would be useful. I might google once I have some spare time. Just hope one of the developers of that section who might know passes over this.|||

You may want to read this: http://msdn2.microsoft.com/en-us/library/ms156493.aspx

The Report has a Language property which could be set to a static value, such as en-UK. Or you could set it to the current user's language by using an expression: =User!Language. Note: you can also override the report's language on individual textboxes by explicitly setting the textbox.Language property.

-- Robert

|||I can confirm that setting the language of the report does in fact fix the local symbol's. I never noticed this property as it is tucked away. To get to it you have to select it from the drop down menu in properties ( http://www.devstuff.eu/images/stories/msdn/ReportSelecter.JPG ). Then you can set report wide settings.

Interesting points about this :
Text boxes local settings does not override form default.|||Thanks guys.

Build reports using Report Designer using Models

Once a Model is created, is ther query builder the only tool that can be used
to create a report from the Model or can we use Report Designer to build
reports off a Model?
Thanks in advance!I guess I should have clarified I am work with the 2005 Beta version of
Reporting Services. If anyone has any idea, please let me know.
Thanks!
"clutch" wrote:
> Once a Model is created, is ther query builder the only tool that can be used
> to create a report from the Model or can we use Report Designer to build
> reports off a Model?
> Thanks in advance!