how to make the different layout for different export format.

Dear All,
I want to know whether the Reporting Service can implement the
different layout for different export format. e.g. When I get the html
report, I do not need to show condition(paramter) on report. but When I
export the excel report, I want to show the condition(parameter). Can I get
the export format information in reports?
best regards
yazheng_wangThe reports have to be consistent between renderers....
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"yazheng wang" <yazheng wang@.discussions.microsoft.com> wrote in message
news:D3F52C78-3886-47E8-92F5-A0C70D9980BB@.microsoft.com...
> Dear All,
> I want to know whether the Reporting Service can implement the
> different layout for different export format. e.g. When I get the html
> report, I do not need to show condition(paramter) on report. but When I
> export the excel report, I want to show the condition(parameter). Can I
> get
> the export format information in reports?
>
> best regards
> yazheng_wangsql

How to make ship list

Dear all, I have a request to make a shipment list.
The shipment is listed by 3 columns in horizontal direction.
ex.
Original ship sn :
ship001
ship002
ship003
ship004
ship005
ship006
Ship List Report format :
ship001......ship002......ship003
ship004......ship005......ship006
How should I do in reporting services?
Should I use List, Table, or Matrix '!
please help!
thanks.You could use a List control and set the Layout\Columns property of the
report body to 3? (The Preview tab doesn't display this correctly though;
you will have it export it PDF to see it correctly).
Mark
"sam" <sam@.discussions.microsoft.com> wrote in message
news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> Dear all, I have a request to make a shipment list.
> The shipment is listed by 3 columns in horizontal direction.
> ex.
> Original ship sn :
> ship001
> ship002
> ship003
> ship004
> ship005
> ship006
> Ship List Report format :
> ship001......ship002......ship003
> ship004......ship005......ship006
> How should I do in reporting services?
> Should I use List, Table, or Matrix '!
> please help!
> thanks.|||I have the same PB.
is it possible to have a multicolumn subreport ?
when i used nested multicolumn in my report, the other column are not display!
any idea '
regards
"MCC" wrote:
> You could use a List control and set the Layout\Columns property of the
> report body to 3? (The Preview tab doesn't display this correctly though;
> you will have it export it PDF to see it correctly).
> Mark
> "sam" <sam@.discussions.microsoft.com> wrote in message
> news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > Dear all, I have a request to make a shipment list.
> > The shipment is listed by 3 columns in horizontal direction.
> > ex.
> > Original ship sn :
> > ship001
> > ship002
> > ship003
> > ship004
> > ship005
> > ship006
> >
> > Ship List Report format :
> > ship001......ship002......ship003
> > ship004......ship005......ship006
> >
> > How should I do in reporting services?
> > Should I use List, Table, or Matrix '!
> > please help!
> > thanks.
>
>|||Another related question..
What if I want to place shipment header on the top of the page?
I cannot place any objects across the multi-columns report body.
Any suggestions or ideas for me ?
thanks
"MCC" wrote:
> You could use a List control and set the Layout\Columns property of the
> report body to 3? (The Preview tab doesn't display this correctly though;
> you will have it export it PDF to see it correctly).
> Mark
> "sam" <sam@.discussions.microsoft.com> wrote in message
> news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > Dear all, I have a request to make a shipment list.
> > The shipment is listed by 3 columns in horizontal direction.
> > ex.
> > Original ship sn :
> > ship001
> > ship002
> > ship003
> > ship004
> > ship005
> > ship006
> >
> > Ship List Report format :
> > ship001......ship002......ship003
> > ship004......ship005......ship006
> >
> > How should I do in reporting services?
> > Should I use List, Table, or Matrix '!
> > please help!
> > thanks.
>
>|||While in SSRS and the report is exported to PDF, the rows are not 3 across.
the records go down the top then down again.
"sam" wrote:
> Another related question..
> What if I want to place shipment header on the top of the page?
> I cannot place any objects across the multi-columns report body.
> Any suggestions or ideas for me ?
> thanks
> "MCC" wrote:
> > You could use a List control and set the Layout\Columns property of the
> > report body to 3? (The Preview tab doesn't display this correctly though;
> > you will have it export it PDF to see it correctly).
> >
> > Mark
> >
> > "sam" <sam@.discussions.microsoft.com> wrote in message
> > news:A33C9698-2C6C-4BF8-A387-D6BCC2AACB81@.microsoft.com...
> > > Dear all, I have a request to make a shipment list.
> > > The shipment is listed by 3 columns in horizontal direction.
> > > ex.
> > > Original ship sn :
> > > ship001
> > > ship002
> > > ship003
> > > ship004
> > > ship005
> > > ship006
> > >
> > > Ship List Report format :
> > > ship001......ship002......ship003
> > > ship004......ship005......ship006
> > >
> > > How should I do in reporting services?
> > > Should I use List, Table, or Matrix '!
> > > please help!
> > > thanks.
> >
> >
> >sql

how to make select query to access view in other server

Dear All,

i am making small web application using asp.net, C# ,sql2000.

i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.
that is how to make select query to access view in other server

Please help

thanks

You have to add you second server to linked servers (server objects-> linked servers-> right click new linked server) and next in your query use server name in table name like:

select * from [server].[database].dbo.[tablename]

or use open query

Select * from OPENQUERY([servername],'SELECT * from [database].dbo.[tablename]')

second is faster but use it only if your query will hit only data on second server.

Thanks

sql

how to make select query to access view in other server

Dear All,

i am making small web application using asp.net, C# ,sql2000.

i want a about regarding how to access view or table from other server to local server. i have base database where there is a view which need to access in my database of local server.
that is how to make select query to access view in other server
Please help

thanks

there are many ways to access other server.database.table

(a) Configure LinkedServer

b)OPENDATASOURCE

(c) OpenQuery

read about this in BOL

Madhu

how to make report parameter value change dynamic when run time?

Dear all,

i have 2 parameter [startDate] [endDate].
startDate will basic on the day run report to get the start date from system(follow the store procedure) as below.

CREATE PROCEDURE [dbo].[CFSRep_spGetLastWeekMonDate]
AS
BEGIN
DECLARE @.dtStart DATETIME
-- SET @.dtStart = GetDate() --Set Date to Todays Date
--Set Start Date to 6 days before. If its a Sunday it will get this weeks Monday Date, else any day before will get the past weeks Monday Date
SELECT @.dtStart = dateadd(dd, -6, Getdate())
WHILE (datepart(dw, @.dtStart) != 2) --While its not Day 2 (Monday)
BEGIN
SELECT @.dtStart = dateadd(dd, -1, @.dtStart) --Set the Start Date to a day before
END

SET @.dtStart = CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, @.dtStart))) --Set the time to 00:00:00 AM

SELECT @.dtStart as LastWeekFirstDay
--

END
GO


endDate will get the date after the startDate is process. let say the answer as below.
SELECT DATEADD(dd, 4, @.startDate) as endDate

when i get the startDate = 30th Jan 2006, then the endDate = 3rd Feb 2006

then when i preview report, and i change the parameter of the date on start date to 23rd Jan 2006 but the endDate still the same 3rd Feb 2006.

anyway for me to refesh the endDate to 27th Jan 2006?

Hi Terence,

first of all you can use visual basic functions like Today etc. to get the startdate. In case of that you must not go to the database.

then you can try the following steps:

1. define 2 parameters (startdate + enddate)

2. in the enddate-dataset define a parameter @.startDate and set it to =Parameters!StartDate.Value.

3. make your 'SELECT DATEADD(dd, 4, @.startDate) as endDate' statement.

Now the reportservice should set in the endate-parameter the startdate-param +4 days.

hope this will work for you

sql

How to make multiple-valued in one parameter in Query Builder?

Dear all,

I have a problem over here, hope to get some good advices from you guys.

I use Query Builder in VS2005 where you could see some tables on top, queries on the middle and resultset on the bottom windows.

I have a statement like below:

SELECT...WHERE Booking.BookingType IN (@.Type1, @.Type2, @.Type3, @.Type4, @.Type5)...

However, I found out that there are too many parameters, I wish to have only ONE parameters in the list of IN() operator. Is there any way to do it? Thanks!

I would suggest giving a look to Jens Suessmeyer's SPLIT function; the definition of this function can be found here:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=419984&SiteID=17

You ought to be able to code up your lists as comma separated strings and create a query that

looks something like this:

Code Snippet

SELECT...

from Booking

join split (@.yourParm, ',')

on Booking.BookingType = splitValue

Another alternative is to pass your argument as XML and use SQL Servers XML ability to interpret the XML argument.

Another question: Are you trying to make a parameter similar to a multi-value parameter that is available in Reporting Services? If the answer to that question is "YES" then you need to understand that feature is only available in Reporting Services and is not in general available to Transact SQL.

|||

If you are trying to reduce the number of parameters, just remove them from inside the paretheses.

In fact, if you are ONLY testing for a single parameter, use equals instead of IN (...) -it may be a bit more efficient.

|||

Actually, what I wish to have is putting a list of values in the @.Param programmatically in my code, thus, I wish to have one single @.Param instead of multiple @.Param(s) in SQL. I used Query Builder GUI to build my SQL query in VS2005, however, I couldn't find way to just put one @.Param and set multiple values in it.

For e.g.

SELECT * FROM Booking WHERE Type IN ( @.Param );

C# Code:

....DataTable1.GetData("Lab, Meeting, Course");

Is this possible to do this?

Thanks!

|||

There is no direct way to do something like

Code Snippet

SELECT * FROM Booking WHERE Type IN ( @.Param );

in which @.param contains data such as 'Lab, Meeting, Course'. Again, I would suggest using the SPLIT function to accomplish your objective.

How to log any activity

Dear friends,
I'm working on an entity relationship diagram about a mice farm.
Let's say we have a very very basic diagram like this:

MOUSE "is in" CAGE

For example, this gives

Mouse "n1500" is in cage "AAA"
Mouse "n1501" is in cage "BBB"

One operator can take one mouse and put it into another cage, for
example the first line becomes

Mouse n1500 is in cage CCC

Now, I was asked to track any movement... I ask myself: do I need to
add

OPERATOR "moves" MOUSE

so that I have

Operator "John" moves Mouse "n1500" on "Monday 3rd, 2007" at "5 PM"
from "AAA" to "CCC"?

or this kind of logging is provided some way by SQL server?

Thanx a lot for any hint.Not automatically.

You could add a trigger and an audit table to your database, so that every time a record is inserted updated, the pertinent data would be logged to the audit table.

ref Using TRIGGERS to add an audit trail to a table (http://www.xtremevbtalk.com/showthread.php?t=217047)

Note that the example shown doesn't audit the data which was changed, but that is easy to add.

Note: Since you're asking specifically about SQL Server, I'm moving this thread there (to the SQL Server Forum).

How to load any file into FTP server through Javascript.

Dear all,
Iam with a small problem.
I want to access to FTP server through Html page by entering a username
and password.In the same html page I have to slect a file through
browse button and load it into FTP server.
PLz help me with the code also.
All this should be in Javascript.
Any help is appreciated...
Thanks a lot...~!~!~!
Bye
Hi
If this is ASP then you can use one of the products mentioned on
http://www.aspfaq.com/show.asp?id=2189.
This is not really an XML or SQL Server question so posting in a more
appropriate group may be an idea!
John
"vinodh" <vinodh.singh@.gmail.com> wrote in message
news:1126834578.588797.184610@.f14g2000cwb.googlegr oups.com...
> Dear all,
>
> Iam with a small problem.
> I want to access to FTP server through Html page by entering a username
> and password.In the same html page I have to slect a file through
> browse button and load it into FTP server.
> PLz help me with the code also.
> All this should be in Javascript.
> Any help is appreciated...
>
> Thanks a lot...~!~!~!
> Bye
>

How to load any file into FTP server through Javascript.

Dear all,
Iam with a small problem.
I want to access to FTP server through Html page by entering a username
and password.In the same html page I have to slect a file through
browse button and load it into FTP server.
PLz help me with the code also.
All this should be in Javascript.
Any help is appreciated...
Thanks a lot...~!~!~!
ByeHi
If this is ASP then you can use one of the products mentioned on
http://www.aspfaq.com/show.asp?id=2189.
This is not really an XML or SQL Server question so posting in a more
appropriate group may be an idea!
John
"vinodh" <vinodh.singh@.gmail.com> wrote in message
news:1126834578.588797.184610@.f14g2000cwb.googlegroups.com...
> Dear all,
>
> Iam with a small problem.
> I want to access to FTP server through Html page by entering a username
> and password.In the same html page I have to slect a file through
> browse button and load it into FTP server.
> PLz help me with the code also.
> All this should be in Javascript.
> Any help is appreciated...
>
> Thanks a lot...~!~!~!
> Bye
>

How to load a talbe in SQL?

Dear dBforums memebers:

I want to know how to load a table in SQL*Plus environment.

I created a table called author(author_name char(30) ). Instead of using single INSERT statement. I want to load table with a datafile, or a script file.

Could someone tell me the procedure which will load a table using data file or a script file. My friend told me that SQL*Loader may do the job, but i couldn't find information on oracle website regrading this matter.

Can anyone can give me some suggestions. I appreciate your help:)

if possible, please show me a a detailed example, or web sources.

sjgrad03
12-20-03Your friend was correct, SQL*Loader is the right tool. See documentation at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/part2.htm#436160

In order to access the documentation, you must login to the Oracle Technet web site. If you don't login, the URL will hang.

How to launch programatically a SSIS package?

Dear all,

I wrote this post others times but the answer did not satisfied so that I'd like to know if really anyone has ever used or experienced with this possibility. No by .Net language rather than Vb 6.0 or ASP or even instanciacing DMO library.

According this link http://support.microsoft.com/?kbid=817248 it seems possible but I haven't idea if possible keeping in mind that it has been made by yourself no for others... So that, I mean, these assemblies comes along with Sql Server 2005 installation.

Thanks a lot for your support,

It is much simpler than the interop path described in that KB article. Just reference the typelibrary in DTS.DLL and use Application & Package classes from there.|||

Hi Michael,

What do you mean? From VB 6.0? Can you explain better?

Thanks a lot

|||

Enric,

I wrote an answer to this question on another thread that you started.

Please see http://forums.microsoft.com/MSDN/showpost.aspx?postid=408720&siteid=1

Best Regards,

PJ

|||

Yes, I know and I beg you pardon for your time dedicated for me in this post.

Such anwser half-satisfied so that I'm looking further explanations.

|||

enric12879 wrote:

Hi Michael,

What do you mean? From VB 6.0? Can you explain better?

Thanks a lot

The KB article describes how to build the typelibrary from managed code, but SSIS already has a native typelibrary and native COM objects that you can use directly from VB 6.

I don't have VB 6.0 around, so I can't send the detailed instructions, but VB can call any COM object. You add the typelibrary to the Project/Reference dialog, and then you can use any COM object from this typelibrary. The typelibrary lives in Program Files\Microsoft SQL Server\9.0\DTS\Binn\Dts.Dll.

|||

I've taken that file but when I try to register by regsvr32 fails.

Error in loadlibrary("c:\windows\system32\dts.dll")

Sql25k is installed on another server and VB in another one. Maybe the problem is there.

|||

enric12879 wrote:

Sql25k is installed on another server and VB in another one. Maybe the problem is there.

Yes, it is definetely a problem. To run the package, you need much more than DTS.DLL - the SSIS needs to be installed on the machine where the package is executed (both for technical and licensing issues).

If you want to run the package on client, install full SSIS on this machine. You don't need to register DTS.DLL - it should already be registered.

If you want to execute the package on server from a program running on another machine, the simplest way to do this is via Agent. Create a SQL Agent Job that will run the package (via UI on server machine, but you can also do it programmatically). Then invoke this job from your client code.

I'm not Agent expert, so I'm not sure what is the best way to communicate with Agent from VB - obviously you can connect to SQL Server using ADO and call Agent stored procedure; but DMO may also work.

|||

Hi Michael,

Thanks for your quick response. We current have got a vb application which is always running and checking up a specified filesystem. If there to find files it fires a DTS on the contraty it follows listening... Sql Agent functionality doesn't serve for our purposes but you are saying that I install SSIS in my workstation but how? Is it possible to install only SSIS features?

I think understand the SSIS data model now. DTS.DLL is then a COM object which can be called from Vb 6.0 and give you access to any SSIS whereas the rest ones are simply assemblies.

repldts.dll

\Program Files\Microsoft SQL Server\80\COM

C0M ?

DTS.dll

\Program Files\Microsoft SQL Server\90\DTS\Binn

C0M ?

Microsoft.SQLServer.ManagedDTS.dll

\Program Files\Microsoft SQL Server\90\SDK\Assemblies

.NET

Microsoft.SQLServer.DTSRuntimeWrap.dll

\Program Files\Microsoft SQL Server\90\SDK\Assemblies

.NET

Microsoft.SqlServer.DTSPipelineWrap.dll

\Program Files\Microsoft SQL Server\90\SDK\Assemblies

.NET

Our idea is to avoid .Net languages for to build a new solution. I know that it's stupid and silly but I can't decide regarding budget and that stuff...

Thanks again for your comments,

|||Where do you want the package to actually run - on the machine where your code runs (client), or on another machine (server)?
If on client, install SSIS - run SQL 2005 setup, check SSIS checkbox, you don't have to install SQL Server and other components. You do need a license for this machine however.
If on server - use the Agent. You don't need to create a schedule, so you are not restricted by Agent's scheduling capabilities. You will just use it as a remote service for running SSIS packages on demand. You will start the packages from the client.
BTW, the choices and recommendations above don't depend on whether you are using native or managed languages.|||

Hi again,

SSIS packages are stored in the server (msdb...)

I don't understand how after to define a job you can do that it is awared whether exists a file or not in a path

I meant, we've got a fixed path:

E:\..\..\..\SERVER\DTS\

And from there a folder for each ASP application or whatever. Each old DTS is fired when VB service find a .nul file or .TXT sended from a JCL from HOST, via FTP, email, etc..

Up to the moment I've done a SSIS which run another SSIS using a script task with .net.

Maybe a SSIS always running and checking for that structure and firing SSIS from himself? It's sound odd.

|||I don't understand where each code runs. It does not matter where the package is stored, like .EXE file it can be stored in one place, but runs where you execute it.

You write that you run child SSIS package from Script Task - this obviously happens on server, where SSIS is already installed. Why don't you run your VB code on the same machine?

How to launch a SSIS package from VB or whatever

Dear all,

I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.

Issue comes from the moment that we’ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.

Thanks in advance for any info regarding this,

Hey there Enric,

I'm no expert in SSIS.. but I AM reading the Wrox book "Professional SQL Server 2005 Integration Services" which has a chapter on using SSIS with external applications.

If you get the book just look at chapter 17 and you'll find the info you need.

OR you could go to Wrox.com and download the sample code for chapter 17. It contains sample VB to call an SSIS package.

Basically you have to use the Microsoft.SqlServer.Dts.DtsClient namespace...

You import that namespace and use it to connect to the package...

Imports Microsoft.SqlServer.Dts.DtsClient

Then use an DtsCommand to execute the the package.

I don't want to post Wrox's sample code here (don't want no trouble) but if you search in books online for DtsCommand you should find stuff....

Its a bit silly calling an SSIS package with a DtsCommand isn't it?

Very confusing..

PJ

|||

The reason for the false naming is that the product was well into the development cycle when the decision was made to change the name from DTS to SSIS. That decision was actually made around Q3 2004, almost 4 years after development started.

At that late stage in the game it was considered too much of a job to go through and change all the code from DTS* to SSIS*. Its a shame but can't be helped.

Do as all techies do...blame the marketing department :)

-Jamie

|||

On Books online at

http://msdn2.microsoft.com/en-us/library/aa337077.aspx

there's an extensive coverage on how to run SSIS packages remotely.

You may need to be a bit seasoned developer to go through it and run it though, as the documentation is not a step-by-step instruction.

Rgds,

How to launch a SSIS package from VB or whatever

Dear all,

I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.

Issue comes from the moment that we’ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.

Thanks in advance for any info regarding this,

Hey there Enric,

I'm no expert in SSIS.. but I AM reading the Wrox book "Professional SQL Server 2005 Integration Services" which has a chapter on using SSIS with external applications.

If you get the book just look at chapter 17 and you'll find the info you need.

OR you could go to Wrox.com and download the sample code for chapter 17. It contains sample VB to call an SSIS package.

Basically you have to use the Microsoft.SqlServer.Dts.DtsClient namespace...

You import that namespace and use it to connect to the package...

Imports Microsoft.SqlServer.Dts.DtsClient

Then use an DtsCommand to execute the the package.

I don't want to post Wrox's sample code here (don't want no trouble) but if you search in books online for DtsCommand you should find stuff....

Its a bit silly calling an SSIS package with a DtsCommand isn't it?

Very confusing..

PJ

|||

The reason for the false naming is that the product was well into the development cycle when the decision was made to change the name from DTS to SSIS. That decision was actually made around Q3 2004, almost 4 years after development started.

At that late stage in the game it was considered too much of a job to go through and change all the code from DTS* to SSIS*. Its a shame but can't be helped.

Do as all techies do...blame the marketing department :)

-Jamie

|||

On Books online at

http://msdn2.microsoft.com/en-us/library/aa337077.aspx

there's an extensive coverage on how to run SSIS packages remotely.

You may need to be a bit seasoned developer to go through it and run it though, as the documentation is not a step-by-step instruction.

Rgds,

How to know how many databasefields or formulas in one textbox...?

Dear Kabu,
Can you show me how to know how many databasefields or formulas in one textbox when you read the report from VB via CrystalDesigner?.. and can you reply me as soon as possible please ?
ThanksDo you want to know how many formulae are used in the Crystal Report?|||Hi , Madhi
When you design, you can drag some fields or some formulas into just only 1 textbox(a empty textbox), OK? My problem is that I want to know how many fields or formulas name in that textbox when you open it from CrystalDesigner , not at design time.
Thanks.|||I dont think this is possible. Why do you want this?

How to know a server is running on a specified port?

Dear all,
How to know that whether a server is running on a specified port?
For example, server A is running on port 1888. For a client, how to know
this?
Thanks,
GordonHi ,
Easy way is to check the SQL Server Error Log.
Thanks
Hari
MCDBA
"Gordon" <sdgwedh@.hotmail.com> wrote in message
news:#fyAagwyDHA.2620@.TK2MSFTNGP09.phx.gbl...

quote:

---

> Dear all,
> How to know that whether a server is running on a specified port?
> For example, server A is running on port 1888. For a client, how to know
> this?
> Thanks,
> Gordon
>

---

|||You can check :
1. SQL Errorlog
2. NT application log
3. Run netstat -an
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks. But my question is for a client, how to know this.
A client doesn't have permission to check the items you list.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:nX$xzv9yDHA.3532@.cpmsftngxa07.phx.gbl...

quote:

---

> You can check :
> 1. SQL Errorlog
> 2. NT application log
> 3. Run netstat -an
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>

---

|||Hey Gordon,
Our MDAC 2.6 and greater clients will send a UDP packet to the server to
determine what port the server's listening on as long as it's a Named
Instance.
Otherwise, the NT admin or SQL Admin would have to tell the client what
port they're listening on. Typically, if you were to roll out an
application that was listening on an alternate port, you would either
instruct the clients how to connect or configure an alias for them. The
only other way a client could find this information out would be to port
scan the remote machine.
265808 INF: How to Connect to an SQL Server 2000 Named Instance with the
http://support.microsoft.com/?id=265808
286303 INF: Behavior of SQL Server 2000 Network Library During Dynamic Port
http://support.microsoft.com/?id=286303
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.