preconfigure port number while command line installing

Hi,

I want set a specific port number of SQL Server(express) during installation not by Configuration Manager after install.
Is it possible?

hi,

probably becouse of the multi instances support of SQL Server up to version 2000, which introduced the SQL Server Resolution Service listening on UDP 1434, now SQLBrowser, this feature has been removed from the configurable settings..

but you can interact via SMO as well, but probably after your installer has finished..

regards

Posting an entire XML document to SQL Server

How do I post an entire XML document to SQL Server in a such a way that when
it gets posted, I can process it with a Stored Procedure?
My specific application is using BizTalk 2004 to send an entire document to
SQL Server without using the "updategram" schema. I just want to send an
entire document via a BizTalk 2004 SQL Send Port.
Thanks,
Mike Jansen
Sr. Software Developer
Prime ProData, Inc.
North Canton, Ohio USA
(mjansen) (at) (primepro-com)
In SQL Server 2000, define your stored proc with a parameter of type NTEXT
or TEXT and use your favorite provider to pass the XML (in an encoding that
is compatible with either Unicode (NTEXT) or your server code page (TEXT)).
Best regards
Michael
"Mike Jansen" <mjansen_nntp@.mail.com> wrote in message
news:uinFg5SvEHA.4020@.TK2MSFTNGP10.phx.gbl...
> How do I post an entire XML document to SQL Server in a such a way that
> when
> it gets posted, I can process it with a Stored Procedure?
> My specific application is using BizTalk 2004 to send an entire document
> to
> SQL Server without using the "updategram" schema. I just want to send an
> entire document via a BizTalk 2004 SQL Send Port.
> Thanks,
> Mike Jansen
> Sr. Software Developer
> Prime ProData, Inc.
> North Canton, Ohio USA
> (mjansen) (at) (primepro-com)
>

Postcode radius searching

Hi - I know this isn't really a specific SQL Server question but I
can't think of a better forum.

I want to implement a more sophisticated UK postcode search on a site
- "LIKE 'NW%'" etc, is not bringing back good enough results.

A feature that would allow me to ask: "give me all outward postcodes
in a 30 mile radius of NW10" would be ideal.

Has anyone had to do this before? - any advice on how much
appreciated. Some of the postcode products available don't really
seem to offer this feature.

NHThanks for the links - I'll follow them up.

NH|||Nazir wrote:
> Hi - I know this isn't really a specific SQL Server question but I
> can't think of a better forum.
> I want to implement a more sophisticated UK postcode search on a site
> - "LIKE 'NW%'" etc, is not bringing back good enough results.
> A feature that would allow me to ask: "give me all outward postcodes
> in a 30 mile radius of NW10" would be ideal.
> Has anyone had to do this before? - any advice on how much
> appreciated. Some of the postcode products available don't really
> seem to offer this feature.

There is a system called Address Point which associates a OS grid ref with
each Delivery point (full post code + street number). This is, I suppose,
how MultiMap works. Whether you could adapt this system just to deal with
the outward portion of the postcode I am not sure.

Kennedy

possible to define more than one sender addresses?

Hi,
is it possible to define more than one "From" sender addresses in ms
reporting services?
i would like to send an specific report to customer with a different from
email adress.
all other reports should use the default "from" sender address.
is that possible?
thx & regards,
edSorry this is not possible. You can set the Reply-To address however.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edwin Renner" <edwin.renner@.eunet.co.at> wrote in message
news:uFPZULq9FHA.4076@.tk2msftngp13.phx.gbl...
> Hi,
> is it possible to define more than one "From" sender addresses in ms
> reporting services?
> i would like to send an specific report to customer with a different from
> email adress.
> all other reports should use the default "from" sender address.
> is that possible?
> thx & regards,
> ed
>
>