Can I Install Enterprise edition on Windows 2000 Server as in Small Business Ser

Hi.
We have Windows 2000 Small Business Server
In control panel/System the operating system is identified
as
Windows 2000 server service pack 4
Microsoft pages on System requirements for SQL Server
Enterprise edition says requires Windows 2000 Server
The operating system I have seems to be Windows 2000
Server even though it has some junk in it making it
Windows 2000 Small Business Server.
Question can i Install SQL Server 2000 Enterprise?
I need this because i need to use Indexed Views which do
not exist in Sql Server standard edition.
THe answer varies depending on whome i ask at Microsoft.
Apreciate any advice.Hi
There is no mention of SBS on the system requirements at
http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp
even though SQL Server comes with it!!
I have never tried installing this onto a specific SBS system, so can not be
100% but I am pretty sure that it is no different. If you do help/about
windows in Windows Explorer and it says Microsoft (R) Windows Version 5.0
then I don't think there would be any reason for it not to.
John
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>|||Please do not post the same message independently in different newsgroups, I
posted an answer in .setup.
--
Jacco Schalkwijk
SQL Server MVP
"Wayne Wilson" <anonymous@.discussions.microsoft.com> wrote in message
news:904101c43310$657e3600$a101280a@.phx.gbl...
> Hi.
> We have Windows 2000 Small Business Server
> In control panel/System the operating system is identified
> as
> Windows 2000 server service pack 4
> Microsoft pages on System requirements for SQL Server
> Enterprise edition says requires Windows 2000 Server
> The operating system I have seems to be Windows 2000
> Server even though it has some junk in it making it
> Windows 2000 Small Business Server.
> Question can i Install SQL Server 2000 Enterprise?
> I need this because i need to use Indexed Views which do
> not exist in Sql Server standard edition.
> THe answer varies depending on whome i ask at Microsoft.
> Apreciate any advice.
>

Can I change the text on the "View Report" button?

SSRS 2005
In the web form Report Viewer Control, is there a simple way to change the
text that appears on the "View Report" button?
I would like to either shorten the text or have it appear on two lines to
minimize the page width taken up by this button.
-- Chris
--
Chris, SSSIHello Chris,
As for the ReportViewer Control's "ViewButton", based on my research, it is
encapsulated as an "ViewReportButton" class which is an internal Type. I've
tried reference to this button instance from ReportViewer control's
Controls collection and change it Text, but that didn't work. I think it is
internally assigned the "View Report" text value. Actually since
Reportviewer is a well encapsulated webcontrol, there hasn't much options
for us to customize its individual settigns.
So far what I can get are the following two options if we want to provide a
custom parameterArea or button:
1. Still use the ReportViewer's built-in parameterArea and
ViewReportButton, however, we can only change the button's text by using
clent-side script(find the submit button and change its value), e.g:
==========================<script language="javascript">
function AdjustViewButton()
{
var div = document.getElementById("ReportViewer1");
elems = form1.getElementsByTagName("INPUT");
var i;
for(i=0;i<elems.length;i++)
{
if(elems[i].type == "submit" && elems[i].value == "View Report")
{
elems[i].value = "View";
}
}
}
.........................
<body onload="AdjustViewButton();" >
...............
=============================
2. Do not use the built-in parametersArea of the ReportViewer control(hide
it by setting ShowParameterPrompt=false), and provide our own UI(like label
and textbox ) to accept parameters from user, also add our own View Report
Button, and in the button's click event, we need to use custom code to add
parameters into ReportViewr.serverReport's parameters collection and render
the report.
Hope this helps some. If you have any other ideas, please feel free to let
me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Chris,
How are you doing on this issue, have you got any further idea or does my
last reply helps you a little? If there is any other information you
wonder, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for your reply and suggestions. It is not what I wanted to hear
;-) but I understand your proposals.
It would be nice if Microsoft could provide the ability to do such simple
customization through properties, etc. in the future.
It seems that the out of the box SRSS offering gets you going very quickly,
but very soon you also run into limitations and have to write custom code. It
is of course great that such custom code solutions are possible (it is very
flexible), but it also minimizes the productivity gains to be obtained with
SRSS. Just my 2 cents. ;-)
-- Chris
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Hello Chris,
> How are you doing on this issue, have you got any further idea or does my
> last reply helps you a little? If there is any other information you
> wonder, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your followup Chris,
Yes, I can understand your concern here since what you want to customize is
just a simple Text property of the Button and it will be much more
convenient if the ReportViewer control has provide such a property for
modify it directly.
Fortunately the ReportViewer control still provide some programmtic
approach here as workaround. Also, since this is the first version of the
component, the dev team may haven't considered all the possible scenarios.
So please trust me, our dev guys will surely improve it for sequential
release(also the reporting services) according to more and more community
user experience and feedback. Thus, any of your feedback and comments are
really important to us.
Please feel free to post your comments and request so that our product team
can hear more on such feature request:
http://connect.microsoft.com/feedback/default.aspx?SiteID=210
Again thanks for your posting and understanding!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

can I bind a Label control to a SqlDataSource to display one field from a table?

Hi,

What's the 'new' declarative way to fetch one field from a SQL table and display the result in a Label control?

I have a users table with a fullname field. I want to query the table and retrieve the fullname where the usertable.username = Session("loggedinuser")

I can make the SqlDataSource ok that has the correct Select query, but not sure how to bind the label to that.

thanks,
BruceThe only way I know of, and I hope there is a better way, but I don't know it is to put a formview control on the page. Bind the formview to the datasource, and place the label within the formview, then databind the label to the fullname column.|||Thanks Motley,

I did end up doing that approach. It works ok, just feels a little cumbersome..but maybe it's the correct way for now.

I just feel like there's a missing control that lets you easily bind to a singe output parameter from a query/stored procedure.

-Bruce|||I agree bruce, but unfortunely I lost my inventation to the meeting where the MS team discussed this|||If you're wanting to retrieve the value from a return (output) parameter - that is possible. Take a look at the SqlDataSource controls Selected event. In that event, after the select has taken place, you can retrieve the output paramter's value...

Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SqlDataSource1.Selected
Me.txtWhatEver.Text = e.Command.Parameters("parameterNameHere").Value
End Sub

This might help too... http://www.asp.net/QuickStart/util/srcview.aspx?path=~/aspnet/samples/data/RetValAndOutputParams.src

I do wish there were a way to retrieve data other than what can be returned in an output parameter... like a field in a DataRow for example. The data controls (like a FormView) are doing this somehow... so why can't I get access to that some functionality in code-behind?

Can I "freeze" the leftmost 2 columns when scrolling horizontally?

Hello,

I have a very wide report that uses a table control. I would like to "freeze" the two leftmost columns so that they remain visible when the user is scrolling horizontally (sideways). Is this possibe?

Thanks,

BCB

In RS2005, there is an option to "Header should remain visible while scrolling"
These can be found in your table or matrix groups' properties/options,
or as a whole table/matrix (not doing it by a group)

|||

Hi,

But that option just applies to up and down scrolling. I'm trying to keep the leftmost columns in view while I scroll a very wide report to the right. I've never found that the option you mentioned works for sideways scrolling.

|||

Select both entire columns of the table that you want to freeze by using the column selectors.

Then in the VS properties window, you should find a "FixedHeader" property at the bottom. Set it to True.

-- Robert

|||

Beautiful, Robert - thanks.

BCB

Can groups be set up within SQL Server 2000?

We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
JimYou cannot create groups at the server level but you can at the DB level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
We would like to create groups (like Windows OS Groups) strictly within SQL
Server. This would give us easier control over permissions of groups SQL
Server login accounts. Then we wouldn't have to maintain permissions on
many, many individual SQL Server logins.
I realize that we could give the same users permissions through Windows
"Local Users and Groups", but our current goal is to not give them Windows
user accounts--just SQL Server permissions.
Any ideas?
Thanks!
Jim|||I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>|||As long as it's a database role, yes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"Jim Moon" <please.reply@.group> wrote in message
news:ezNEXM9FGHA.3080@.TK2MSFTNGP10.phx.gbl...
I see what you mean--create a role, add user(s) to that role, and assign
permission on database objects.
Thank you, Tom!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:ejpLPG9FGHA.2040@.TK2MSFTNGP14.phx.gbl...
> You cannot create groups at the server level but you can at the DB level.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> "Jim Moon" <please.reply@.group> wrote in message
> news:uSBRYp8FGHA.3864@.tk2msftngp13.phx.gbl...
> We would like to create groups (like Windows OS Groups) strictly within
> SQL
> Server. This would give us easier control over permissions of groups SQL
> Server login accounts. Then we wouldn't have to maintain permissions on
> many, many individual SQL Server logins.
> I realize that we could give the same users permissions through Windows
> "Local Users and Groups", but our current goal is to not give them Windows
> user accounts--just SQL Server permissions.
> Any ideas?
> Thanks!
> Jim
>
>

Can a TextBox Height and Width be set dynamically?

SSRS 2005
I have a custom code assembly which I am using to control my textbox font
settings at run time. That works fine.
However I would also like to set the Location Left and Top and Size Width
and Height properties of my textboxes using functions in my custom code
assembly.
However no matter what I try I get this error message:
====================================== Property value is not valid.
=...[my function name]...cannot be parsed as a unit because it does not
contain numeric values. Examples of valid unit strings are "1pt" and ".5in".
======================================
I tried returning a string as indicated, a double value, etc. Nothing works.
Is this just a case where these properties cannot be set dynamically? That
seems to be the indication in this old forum post:
10/15/2004
"Text Box... Width"
"The height and width of a textbox are fixed at design time and cannot use
the database table schema to set them at runtime."
--
Chris, SSSITry this, have a parameter point to the code call.
=@.ParameterName
=-Chris
"Chris G." <ChrisG@.nospam.nospam> wrote in message
news:30911811-2F6D-454C-B44F-9F2F69ED11B5@.microsoft.com...
> SSRS 2005
> I have a custom code assembly which I am using to control my textbox font
> settings at run time. That works fine.
> However I would also like to set the Location Left and Top and Size Width
> and Height properties of my textboxes using functions in my custom code
> assembly.
> However no matter what I try I get this error message:
> ======================================> Property value is not valid.
> =...[my function name]...cannot be parsed as a unit because it does not
> contain numeric values. Examples of valid unit strings are "1pt" and
> ".5in".
> ======================================> I tried returning a string as indicated, a double value, etc. Nothing
> works.
> Is this just a case where these properties cannot be set dynamically? That
> seems to be the indication in this old forum post:
> 10/15/2004
> "Text Box... Width"
> "The height and width of a textbox are fixed at design time and cannot use
> the database table schema to set them at runtime."
> --
> Chris, SSSI|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
I do not understand Chris Connor's suggestion.
Can you clarify what he is suggesting that I do?
What does the =@.Parameter syntax signify?
Is he suggesting that I can call my custom code assmebly function this way,
or is he saying to assign values to TextBox Height and Width using report
parameters instead?
Please read my original post and provide whatever information you can.
Thanks!
-- Chris
-- Chris
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Chris,
I have posted a reply in your post "Can I obtain a reference to a report
item?" and hope that will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Wei,
This was my question in my prior reply, but you did not answer it:
"What does the =@.Parameter syntax signify?"
Can you please answer that question?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi Chris,
> I have posted a reply in your post "Can I obtain a reference to a report
> item?" and hope that will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights
>|||Hello Chris,
I am not sure about what does Chris Conner means but I assume he just
suggest to you to pass the Report Parameter to your code to check whether
you could modify the textbox layout.
But from your scenario, it seems could not been implement. So I replied and
would like to know whether you feel it helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Did you confirm that Chris Connor's suggestion works?
It seems to me that textbox height and width must be hard coded at design
time with a static value and that they can not be set programatically (either
using a custom assembly or a report parameter) at run time. This seems to be
a limitation in the product. Can you please confirm that this is a limitation
in the product?
Or do you have a way to accomplish this dynamic behavior?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I am not sure about what does Chris Conner means but I assume he just
> suggest to you to pass the Report Parameter to your code to check whether
> you could modify the textbox layout.
> But from your scenario, it seems could not been implement. So I replied and
> would like to know whether you feel it helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Chris,
Based on my research, since the Height and Width is readonly, you could not
set the value.
My suggestion is to use the XML web services.
You need to generate the RDL file by your self.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I understand what you are saying. Thank you for the reply.
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> Based on my research, since the Height and Width is readonly, you could not
> set the value.
> My suggestion is to use the XML web services.
> You need to generate the RDL file by your self.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Can a data region...

reference a parameter? For instance, I have a table control and in the detail field I have an expression.

=IIf(Parameters!Consignee.Value = True, "True","False")

But it doens't work.....any suggestions?

Michael

That should work - what happens when you try it? Did you make the data type Boolean?|||

I get "#Error" in the field.

All I did to get around this was to make a derived table in my main query that filters for the specific parameter, and then joined it back in appropriately. This made it a field instead of a parameter reference and it worked fine. Thanks for the response.

Michael