Drawing line at last record

Hi.
I have a table containing two groups and a detail area.My report has multiple pages.I want to draw line after the last record on every page.I think that expression will be written in record's bottom expression area.How can I choose the last record in every page.Or is there another way to do this.Could you help me please?why wont u draw a line on page footer? when u draw a line on page footer it will diplay on the bottom of each page.|||Thanks but it didn't work
I drawed horizontal line across the page footer.
But there is several blank rows between the last record and the line in page footer.And this is never looking good.If you have another idea about this please share with me.

Download Reporting Services for SQL 2000?

We have license for SQL 2000 but all I can find on the Microsoft download
page was the 120-days trial for Reporting Service and SP1, SP2.
http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
Is there a place to download the release version instead of the 120 days
trial?
Thanks!
AlbertAlbert,
See
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
for the information you need.
As far as I am aware there is no download option for a non-time
limited version of RS2000.
Andrew Watt
MVP - InfoPath
On Thu, 6 Oct 2005 09:35:07 -0700, Albert
<Albert@.discussions.microsoft.com> wrote:
>We have license for SQL 2000 but all I can find on the Microsoft download
>page was the 120-days trial for Reporting Service and SP1, SP2.
>http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
>Is there a place to download the release version instead of the 120 days
>trial?
>Thanks!
>Albert|||Thanks a lot!
Albert
"Andrew Watt [MVP - InfoPath]" wrote:
> Albert,
> See
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx#XSLTsection132121120120
> for the information you need.
> As far as I am aware there is no download option for a non-time
> limited version of RS2000.
> Andrew Watt
> MVP - InfoPath
> On Thu, 6 Oct 2005 09:35:07 -0700, Albert
> <Albert@.discussions.microsoft.com> wrote:
> >We have license for SQL 2000 but all I can find on the Microsoft download
> >page was the 120-days trial for Reporting Service and SP1, SP2.
> >
> >http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> >
> >Is there a place to download the release version instead of the 120 days
> >trial?
> >
> >Thanks!
> >
> >Albert
>|||If you are an MSDN Subscriber, you should be able to download it through the
MSDN Subscriber downloads. It's stored under Server -> SQL Server -> SQL
Server 2000 -> SQL Server 2000 Reporting Services. You can also download SP
1 and 2 from the same place.
It might depend on what subscription level you are on, but if your company
is a subscriber, check it out.
Kaisa M. Lindahl
"Albert" <Albert@.discussions.microsoft.com> wrote in message
news:7509ED44-FE5C-4BBA-B22E-7143B9EAE224@.microsoft.com...
> We have license for SQL 2000 but all I can find on the Microsoft download
> page was the 120-days trial for Reporting Service and SP1, SP2.
> http://www.microsoft.com/downloads/details.aspx?familyid=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en#instructions
> Is there a place to download the release version instead of the 120 days
> trial?
> Thanks!
> Albert

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/d...displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!
Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/d...displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!
|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>
|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patches
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when trying
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:
> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> > I've been trying to download the cumulative hotfix in article 904660
> > (patches
> > to build 8.00.2162). However, the link on the page is not fiding the file
> > to
> > download:
> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >
> > Does anyone know where I can download the 904660 cumulative patch? Thanks!
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>> Hotfix 2162 has been removed.
>> A cumulative hotfix package is available for SQL Server 2000 Service Pack
>> 4
>> build 2162
>> http://support.microsoft.com/kb/904660/en-us
>> CSS (formerly PSS) is working on the replacement hotfix.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
>> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>> > I've been trying to download the cumulative hotfix in article 904660
>> > (patches
>> > to build 8.00.2162). However, the link on the page is not fiding the
>> > file
>> > to
>> > download:
>> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
>> >
>> > Does anyone know where I can download the 904660 cumulative patch?
>> > Thanks!
>>|||Aha! I see what you mean now. I usually skip that very first section, becuase
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:
> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
> > Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> > trying to use. It leads to a page with the following message: "The
> > download
> > you requested is unavailable. If you continue to see this message when
> > trying
> > to access this download, go to the "Search for a Download" area on the
> > Download Center home page." I can't find it anywhere else. I guess I
> > simply
> > need to stop pursuing it.
> >
> > "Geoff N. Hiten" wrote:
> >
> >> Hotfix 2162 has been removed.
> >>
> >> A cumulative hotfix package is available for SQL Server 2000 Service Pack
> >> 4
> >> build 2162
> >> http://support.microsoft.com/kb/904660/en-us
> >>
> >> CSS (formerly PSS) is working on the replacement hotfix.
> >>
> >> --
> >> Geoff N. Hiten
> >> Senior Database Administrator
> >> Microsoft SQL Server MVP
> >>
> >>
> >>
> >> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> >> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> >> > I've been trying to download the cumulative hotfix in article 904660
> >> > (patches
> >> > to build 8.00.2162). However, the link on the page is not fiding the
> >> > file
> >> > to
> >> > download:
> >> > http://www.microsoft.com/downloads/details.aspx?familyid=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en
> >> >
> >> > Does anyone know where I can download the 904660 cumulative patch?
> >> > Thanks!
> >>
> >>
> >>
>
>

Dowload for 8.00.2162?

I've been trying to download the cumulative hotfix in article 904660 (patche
s
to build 8.00.2162). However, the link on the page is not fiding the file to
download:
http://www.microsoft.com/downloads/...&displaylang=en
Does anyone know where I can download the 904660 cumulative patch? Thanks!Hotfix 2162 has been removed.
A cumulative hotfix package is available for SQL Server 2000 Service Pack 4
build 2162
http://support.microsoft.com/kb/904660/en-us
CSS (formerly PSS) is working on the replacement hotfix.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
> I've been trying to download the cumulative hotfix in article 904660
> (patches
> to build 8.00.2162). However, the link on the page is not fiding the file
> to
> download:
> http://www.microsoft.com/downloads/...&displaylang=en
> Does anyone know where I can download the 904660 cumulative patch? Thanks!|||Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
trying to use. It leads to a page with the following message: "The download
you requested is unavailable. If you continue to see this message when tryin
g
to access this download, go to the "Search for a Download" area on the
Download Center home page." I can't find it anywhere else. I guess I simply
need to stop pursuing it.
"Geoff N. Hiten" wrote:

> Hotfix 2162 has been removed.
> A cumulative hotfix package is available for SQL Server 2000 Service Pack
4
> build 2162
> http://support.microsoft.com/kb/904660/en-us
> CSS (formerly PSS) is working on the replacement hotfix.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:50F41014-B465-41D4-8A55-EF4EDE02CC4A@.microsoft.com...
>
>|||Read the actual article before clicking on the download link. The page
tells you the hotfix has been removed.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...[vbcol=seagreen]
> Thanks, Geoff. Unfortunately, the link you provided is the same one I'm
> trying to use. It leads to a page with the following message: "The
> download
> you requested is unavailable. If you continue to see this message when
> trying
> to access this download, go to the "Search for a Download" area on the
> Download Center home page." I can't find it anywhere else. I guess I
> simply
> need to stop pursuing it.
> "Geoff N. Hiten" wrote:
>|||Aha! I see what you mean now. I usually skip that very first section, becuas
e
usually it doesn't contain much meat. Sorry for the confusion. Thanks for
your help!
"Geoff N. Hiten" wrote:

> Read the actual article before clicking on the download link. The page
> tells you the hotfix has been removed.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brian Laws" <BrianLaws@.discussions.microsoft.com> wrote in message
> news:71326F1E-CDCE-49DE-83CF-8C223AB2DCA3@.microsoft.com...
>
>

Doubt regarding PFS

Does SQL Server use PFS to check whether a page is allocated or not if the
table has a clustered index.
Regards
BalajiPFS is used for determining if there is enough free space on the page for
the row but only on Heaps.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:C5E97806-A784-4B47-9746-EA01C5A3F84A@.microsoft.com...
> Does SQL Server use PFS to check whether a page is allocated or not if the
> table has a clustered index.
> Regards
> Balaji

Double quotes in error messages!

I have a problem when trying to display an error message from sql server 2005 on a web page with an alert (javascript command).

The Sql server 2005 returns a message like:

Insert statement conflicted with foreign key constraint "bla bla". The conflict occured indatabase "databasename", table "tablename", column 'columnname'.

In sql server 2000 the error message is the same except all names (constraint, database, table) is in single quotation marks; just like the columnname in the above example.

Is it a configurable issue on the sql server. I would prefer not to solve this issue on a number of different web pages!

Thanks in advance.

Futte

hi,

you should set this:

SET QUOTED_IDENTIFIER { ON | OFF }

When on, then identifiers can be delimited by double quotation marks.

Regards,

Janos

|||

I all ready tried that without any luck.......

I want to avoid the double quotation marks.

Thanks though

Futte

|||

If you wish to 'embed' single quotes in your message, you need to double them up -use two single quotes in each place of one single quote.)

Try this:

SELECT 'This is my ''message'' with quotes.'

|||

I think my question might be a little misunderstood.

My question is not about query syntax in sql regarding single or double quotation marks or two single quotation marks.

It's about the error message sql server is returning. I suddenly experienced that after upgrading sql server from 2000 to 2005 the response from sql 2005 contained double quotation marks around all object names except for one; namely the column name:

2000:

Insert statement conflicted with foreign key constraint 'constraint name'. The conflict occurred in database 'database name', table 'table name', column 'column name'.

2005:

Insert statement conflicted with foreign key constraint "constraint name". The conflict occurred in database "database name", table "table name", column 'column name'.

This is a problem when displaying the error message on a web page with javascript (alert). So if it's a configurable issue on the sql server where is it set? Otherwise I have to handle this error message somewhere else replacing the double quotes with single quotes.

Kind Regards

Futte

|||

Thanks for the clarification. I better understand the situation.

As far as I am aware, there is no user configurable setting to alter the presentation of the error message.

Double Quote in database record

In my asp.net page when I run a query against the database the datagrid get populated with only the records that starts with the first letter for example A good day. But none of the records that starts like this "A fine day" or "A nice day" displays in the datagrid. I tried to replace the Double Quote but it still returns only the records without " quotes. My query looks like this:

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel] <> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like @.ArticleHeading) ORDER BY [Articles].[ArticleHeading]"

You need to do the replace on both the column AND the value you are comparing, otherwise they will never be equal.
eg.

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel]<> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like REPLACE(@.ArticleHeading),'chr(34)') ORDER BY [Articles].[ArticleHeading]"|||

I tried it but still it does not produce the right results.

My code:

Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel] <> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like (REPLACE(@.ArticleHeading, 'chr(34)', ''))) ORDER BY [Articles].[ArticleHeading]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand

dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dbParam_articleHeading As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_articleHeading.ParameterName = "@.ArticleHeading"
dbParam_articleHeading.Value = Request.QueryString("Alphabet")& "%"
dbParam_articleHeading.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_articleHeading)

|||What are you trying to do with: REPLACE([Articles].[ArticleHeading], 'chr(34)', '') ?|||Some records starts with a double qoute and a need to list all for example that starts with A but that needs to include something like "A nice day"|||

Using a sql query I manage to get the right results but what do I need to do in asp.net to get the right results. My SQL code that replaces the ":

SELECT *
FROM Articles
WHERE (REPLACE(ArticleHeading, '"', '') LIKE 'A%')
ORDER BY ArticleHeading

|||

Change:

REPLACE([Articles].[ArticleHeading], 'chr(34)', '')

To:

REPLACE([Articles].[ArticleHeading], chr(34), '')

dose not SQL-Server has Array data-type?

hi,
in SQL Server Books Online in sp_executesql page thay have this example:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level',
N'@.level tinyint',
@.level = 35
i need to accomplish a similar task, but with un-predictable (may be dozens
of) numbers of parameters.
so, instead of doing something like this (with much more than two
parameters):
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level or
job_lvl = @.level2',
N'@.level tinyint , @.level2 tinyint',
@.level = 35
,@.level2 = 32
i want to do something like this:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl in ( @.level ) ',
N'@.level ?? ',
@.level = 35,32
which does not work ,of course......
any ideas?
thanks,
edo
See if this helps:
http://vyaskn.tripod.com/passing_arr...procedures.htm
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"edo" <ewilde@.nana.co.il> wrote in message
news:efwHDCdhEHA.556@.tk2msftngp13.phx.gbl...
hi,
in SQL Server Books Online in sp_executesql page thay have this example:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level',
N'@.level tinyint',
@.level = 35
i need to accomplish a similar task, but with un-predictable (may be dozens
of) numbers of parameters.
so, instead of doing something like this (with much more than two
parameters):
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level or
job_lvl = @.level2',
N'@.level tinyint , @.level2 tinyint',
@.level = 35
,@.level2 = 32
i want to do something like this:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl in ( @.level ) ',
N'@.level ?? ',
@.level = 35,32
which does not work ,of course......
any ideas?
thanks,
edo

dose not SQL-Server has Array data-type?

hi,
in SQL Server Books Online in sp_executesql page thay have this example:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level',
N'@.level tinyint',
@.level = 35
i need to accomplish a similar task, but with un-predictable (may be dozens
of) numbers of parameters.
so, instead of doing something like this (with much more than two
parameters):
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level or
job_lvl = @.level2',
N'@.level tinyint , @.level2 tinyint',
@.level = 35
,@.level2 = 32
i want to do something like this:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl in ( @.level ) ',
N'@.level '? ',
@.level = 35,32
which does not work ,of course......
any ideas?
thanks,
edoSee if this helps:
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"edo" <ewilde@.nana.co.il> wrote in message
news:efwHDCdhEHA.556@.tk2msftngp13.phx.gbl...
hi,
in SQL Server Books Online in sp_executesql page thay have this example:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level',
N'@.level tinyint',
@.level = 35
i need to accomplish a similar task, but with un-predictable (may be dozens
of) numbers of parameters.
so, instead of doing something like this (with much more than two
parameters):
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl = @.level or
job_lvl = @.level2',
N'@.level tinyint , @.level2 tinyint',
@.level = 35
,@.level2 = 32
i want to do something like this:
execute sp_executesql
N'select * from pubs.dbo.employee where job_lvl in ( @.level ) ',
N'@.level '? ',
@.level = 35,32
which does not work ,of course......
any ideas?
thanks,
edo

Domain Groups For Clustering Service ?? SQL Server 2005

When I install the Cluster with Version of SQL 2005 CTP September ...
After the Service Accounts (Clusters) page,
Domain Groups For Clustering Service Page appears.
How Can i configure this page...there is no information about it on BOL of
SQL 2005
In my opinion , fill them with New SQL Groups is created when SQL Server
Installs such as
SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName
and SQLServer2005MSFTESQLUser$InstanceName.
But in this Phase, those group was not created automatically...
So, I try to generate those groups Manually, but Failed...with error message
like "One or more domain groups could not be verified ..."
And i Try to use Domain Admins...but Failed with same error messages...
i found about BOL directions in "Setup\help\1033" folder like follows
(
For each clustered service in the instance of SQL Server that you are
installing, enter the domain and group name in the format
<DomainName>\<GroupName>, subject to the following guidelines:
The domain and group names must already exist. If necessary, ask your domain
administrator for the names of existing domain groups, or to create domain
groups for your failover cluster.
The account under which SQL Server Setup is running must have privileges to
add accounts to the domain groups.
Each service should use a different domain group.
The SQL Server domain groups should not be shared with any other application.
Note that SQL Server accounts will not be removed from the groups if SQL
Server is uninstalled or if the accounts are changed. A domain administrator
must ensure that all unwanted accounts are removed following removal of SQL
Server.
)
So, I made three domain groups and put into builtin Administratos group.
and then proceed ahead.
Failed with same error messages...
help me...!!!
"JEYAI"?? ??? ??:

> When I install the Cluster with Version of SQL 2005 CTP September ...
> After the Service Accounts (Clusters) page,
> Domain Groups For Clustering Service Page appears.
> How Can i configure this page...there is no information about it on BOL of
> SQL 2005
> In my opinion , fill them with New SQL Groups is created when SQL Server
> Installs such as
> SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName
> and SQLServer2005MSFTESQLUser$InstanceName.
> But in this Phase, those group was not created automatically...
> So, I try to generate those groups Manually, but Failed...with error message
> like "One or more domain groups could not be verified ..."
> And i Try to use Domain Admins...but Failed with same error messages...
|||You need to manually add the service accounts you specify during setup into
the groups before running setup (if you're having this issue - you shouldn't
really have to do this). I had the exact same issue and manually adding the
service account to them worked fine. Generally there will be 3 groups
(SQLServer/Agent + FullText). If you use the same service account for the
services then just add that to each of the 3 domain groups you create.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
news:79B54E21-BEB4-43E9-9880-7EAFE0FD5F92@.microsoft.com...[vbcol=seagreen]
>i found about BOL directions in "Setup\help\1033" folder like follows
> (
> For each clustered service in the instance of SQL Server that you are
> installing, enter the domain and group name in the format
> <DomainName>\<GroupName>, subject to the following guidelines:
> The domain and group names must already exist. If necessary, ask your
> domain
> administrator for the names of existing domain groups, or to create domain
> groups for your failover cluster.
>
> The account under which SQL Server Setup is running must have privileges
> to
> add accounts to the domain groups.
>
> Each service should use a different domain group.
>
> The SQL Server domain groups should not be shared with any other
> application.
>
> Note that SQL Server accounts will not be removed from the groups if SQL
> Server is uninstalled or if the accounts are changed. A domain
> administrator
> must ensure that all unwanted accounts are removed following removal of
> SQL
> Server.
> )
> So, I made three domain groups and put into builtin Administratos group.
> and then proceed ahead.
> Failed with same error messages...
> help me...!!!
> "JEYAI"? ? ?:
|||Thanks Jasper,
Following your directions,
I made three domain groups named as SQLUsers,AgentUsers,FTUsers
and put them into Built in Administrators group.
and then put the Service Account named as SQLService and administrator
account into three new groups.
But, in the page of Domain Groups For Clustering Service ,
Same Error message occured...
What did i miss ?
"Jasper Smith"?? ??? ??:

> You need to manually add the service accounts you specify during setup into
> the groups before running setup (if you're having this issue - you shouldn't
> really have to do this). I had the exact same issue and manually adding the
> service account to them worked fine. Generally there will be 3 groups
> (SQLServer/Agent + FullText). If you use the same service account for the
> services then just add that to each of the 3 domain groups you create.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
> news:79B54E21-BEB4-43E9-9880-7EAFE0FD5F92@.microsoft.com...
>
>
|||The readme file describes this.
In section 3.5.15, there are descriptions of Security Groups and Domain
Controllers.
Microsoft SQL Server September 2005 Community Technology Preview
http://download.microsoft.com/downlo...up_issues_238p
Sincerely,
Anthony Thomas
"JEYAI" <JEYAI@.discussions.microsoft.com> wrote in message
news:5B999CCC-1E77-4F3D-B52B-E34DC95752BA@.microsoft.com...[vbcol=seagreen]
> Thanks Jasper,
> Following your directions,
> I made three domain groups named as SQLUsers,AgentUsers,FTUsers
> and put them into Built in Administrators group.
> and then put the Service Account named as SQLService and administrator
> account into three new groups.
> But, in the page of Domain Groups For Clustering Service ,
> Same Error message occured...
> What did i miss ?
> "Jasper Smith"? ? ?:
into[vbcol=seagreen]
shouldn't[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
domain[vbcol=seagreen]
privileges[vbcol=seagreen]
SQL[vbcol=seagreen]
of[vbcol=seagreen]
group.[vbcol=seagreen]
BOL[vbcol=seagreen]
Server[vbcol=seagreen]
SQLServer2005MSSQLUser$InstanceName,SQLServer2005S QLAgentUser$InstanceName[vbcol=seagreen]
messages...[vbcol=seagreen]

Does the webforms Report Viewer Control have a maximum width?

SSRS 2005
I have set the width of the Report Viewer Control in my page like this:
<rsweb:ReportViewer ... Width="100%" ... </rsweb:ReportViewer>
Which does what I want...it resizes the width of the control as the page
(browser) is made wider. However I noticed that on a high resolution display,
once the Report Viewer Control gets to a width of about 960 pixels, it no
longer widens as the page is made wider. It stays static at about 960 pixels
wide.
1. Was the control developed this way for a specific reason?
2. Am I doing something wrong?
3. Is there a way to have the control be as wide as the page is?
--
Chris, SSSIHello Chris,
Glad to see you again. How are you doing?
As for the webform ReportViewer widith property, it does support "100%"
relative size which can make the reportviewer control dynamically resize to
fit its parent container's width.
For your case ,you found that the reportViewer control stop stretching when
the width reach the 960px, I think it is likely a environment or project
specify issue. I've tested the webform reportViewer control on a machine
with 1280X1024 screen size and the reportViewer can correctly stretch to
the maximum wnidows size(in browser).
I think you can test in some other page or project with a simple page and
reportViewer control to see whether this problem occur among all the
conditions. Here is my test reportViewer's template:
====================<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt"
Height="400px" ProcessingMode="Remote" Width="100%">
<ServerReport ReportPath="/ReportProj1/GroupReport" />
</rsweb:ReportViewer>
====================
I think you can check the following things on your local side:
1. check whether you've any code in the page that will modify/limit the
width of the reportviewer control
2. Whether you can statically set the ReportViewr control's width to a
value maxmum to 960px , like Width="1100px"
3. You can also try programmtically set the "100%" width to see whether it
works, e.g.:
=========protected void Page_Load(object sender, EventArgs e)
{
ReportViewer1.Width = Unit.Percentage(100);
}
===========
Please feel free to let me know if you got any new finding or any thing
else we can help.
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.|||Hi Chris,
How are you doing on this issue, have you got any new progress or does the
information in my last reply helps you some?
If there is anything else we can help, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Steven,
Thank for your quick reply to my post.
I have not had a chance to try your suggestions yet.
I will post back as soon as I know more.
--
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Hi Chris,
> How are you doing on this issue, have you got any new progress or does the
> information in my last reply helps you some?
> If there is anything else we can help, please feel free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thank for your reply Chris,
Please feel free to let me know when you need any further helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steve,
I created a simple page as you suggested and the Report Viewer Control does
size beyond 960 px wide. I tested on a display with 1600x1200 resolution.
The app uses a master page created by someone else, so I have to look deeper
into the code to see if someone set something with a width limit that is
causing my problem.
Thanks!
-- Chris
--
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Thank for your reply Chris,
> Please feel free to let me know when you need any further helps.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Chris,
Glad that you've got some progress.
Please feel free to let me know if you finally figure out the problem.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.