3 questions

Hi -- I'm new to SQL and thus also new to SQL Server.
I'm working on a project that has data stored in 4 databases. I want to
create a 5th database for my work. I will need to retrieve data from those
other 4 databases -- usually creating tables in my 5th database. I want to
put together stored procedures to do this. I can extract data and create
tables within one database, but have no idea how to reach out to a different
one.
Eventually, in this project I will need to read the records, in order and
create a running calculation -- not a running sum. I can do this within VB
pretty easily, but I don't know if this can be done is a query. The
calculation is: (field 2, record n) =
(field 1, record n) * (1 - field 2, record n-1) + (field2,record n)
Finally, can anyone suggest a good book that might help me with some of
these types of questions?
I'd appreciate any help on any portion of the above!
Thanks,
ArtArt,
To access the tables in the other databases (assuming the same server) just
qualify the object using DATABASE.OWNER.OBJECT i.e., pubs.dbo.authors.
Books (SQL):
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/t...=glance&s=books
Joe Celko's SQL for Smarties (2005 ed)
by Joe Celko
http://www.amazon.com/exec/obidos/t...=books&n=507846
HTH
Jerry
"Art" <Art@.discussions.microsoft.com> wrote in message
news:D5386C63-4FEA-42A6-8958-A2CF67FCB726@.microsoft.com...
> Hi -- I'm new to SQL and thus also new to SQL Server.
> I'm working on a project that has data stored in 4 databases. I want to
> create a 5th database for my work. I will need to retrieve data from
> those
> other 4 databases -- usually creating tables in my 5th database. I want
> to
> put together stored procedures to do this. I can extract data and create
> tables within one database, but have no idea how to reach out to a
> different
> one.
> Eventually, in this project I will need to read the records, in order and
> create a running calculation -- not a running sum. I can do this within
> VB
> pretty easily, but I don't know if this can be done is a query. The
> calculation is: (field 2, record n) =
> (field 1, record n) * (1 - field 2, record n-1) + (field2,record n)
> Finally, can anyone suggest a good book that might help me with some of
> these types of questions?
> I'd appreciate any help on any portion of the above!
> Thanks,
> Art|||Jerry,
Thanks very much! For both answers.
Art
"Jerry Spivey" wrote:

> Art,
> To access the tables in the other databases (assuming the same server) jus
t
> qualify the object using DATABASE.OWNER.OBJECT i.e., pubs.dbo.authors.
> Books (SQL):
> The Guru's Guide to Transact-SQL
> by Ken Henderson
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Professional SQL Server 2000 Programming
> by Robert Vieira
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Joe Celko's SQL for Smarties (2005 ed)
> by Joe Celko
> http://www.amazon.com/exec/obidos/t...=books&n=507846
> HTH
> Jerry
> "Art" <Art@.discussions.microsoft.com> wrote in message
> news:D5386C63-4FEA-42A6-8958-A2CF67FCB726@.microsoft.com...
>
>|||>> I can extract data and create tables within one database, but have no
Use 3-part naming like database.owner.object
Perhaps if you post the DDLs, sample data & expected results, others could
give it a try. ( www.aspfaq.com/5006 ). In some cases, using a client side
programming language might be the option. In other cases, you might have to
use some looping construct like a cursor.
SQL Server Books Online should give you most of the basics on t-SQL.
Anith|||Thanks Anith,
I had been using a programming language, but was wondering if I might be
better off using SQL (assuming it's possible). Thanks again.
Art
"Anith Sen" wrote:

> Use 3-part naming like database.owner.object
>
> Perhaps if you post the DDLs, sample data & expected results, others could
> give it a try. ( www.aspfaq.com/5006 ). In some cases, using a client side
> programming language might be the option. In other cases, you might have t
o
> use some looping construct like a cursor.
>
> SQL Server Books Online should give you most of the basics on t-SQL.
> --
> Anith
>
>|||Art, you are in trouble. Let's get back to the basics of an RDBMS.
Rows are not records; fields are not columns; tables are not files;
your post is nonsense. But it tells us that you have no idea about
RDBMS, so your design is probably screw to hell and breakfast.
You seem to be doing attribute splitting on databases; Otherwise, it
would not make sense to mix them.|||"But it tells us that you have no idea about RDBMS"
Hey --CELKO--, keep your posts focused on the issue at hand, not the person
posting. The forum is here to help each other, not to put down people.
This a constant problem with you. Your input is valuable and appreciated,
but these kind of comments are not (at least by me).
Are there no moderators on this site?
"--CELKO--" wrote:

> Art, you are in trouble. Let's get back to the basics of an RDBMS.
> Rows are not records; fields are not columns; tables are not files;
> your post is nonsense. But it tells us that you have no idea about
> RDBMS, so your design is probably screw to hell and breakfast.
> You seem to be doing attribute splitting on databases; Otherwise, it
> would not make sense to mix them.
>

3 months after the layoff...

I spent 2 years of my life working on a successful migration from Access 97
to SQL Server 2000.
Redesign of the schemas. Redesign & rewrites of all their applications,
from VBA to .NET. All successful and ontime.
Then they laid off our entire department.
I just got a message from one of my former co-workers: Apparently, now that
they laid off all the programmers and SQL people, they no longer have anyone
that knows SQL Server, so the company called one of my former bosses on the
telephone (who also got laid off) and asked what it would take to stuff 170
GB back into MS Access.
<hand slapping forehead>
There are just not words.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiYour post made my day.
Send them your resume with an application to provide consulting services at
4 times your previous hourly rate. Move everything back to Access for them.
When they realize Access cant possibly handle the load, double your price
and move it back to SQL server again.
"Mike Labosh" <mlabosh_at_hotmail.com> wrote in message
news:OOQslkYWGHA.3800@.TK2MSFTNGP03.phx.gbl...
> I spent 2 years of my life working on a successful migration from Access
97
> to SQL Server 2000.
> Redesign of the schemas. Redesign & rewrites of all their applications,
> from VBA to .NET. All successful and ontime.
> Then they laid off our entire department.
> I just got a message from one of my former co-workers: Apparently, now
that
> they laid off all the programmers and SQL people, they no longer have
anyone
> that knows SQL Server, so the company called one of my former bosses on
the
> telephone (who also got laid off) and asked what it would take to stuff
170
> GB back into MS Access.
> <hand slapping forehead>
> There are just not words.
> --
>
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>
>|||> Send them your resume with an application to provide consulting services
> at
> 4 times your previous hourly rate. Move everything back to Access for
> them.
> When they realize Access cant possibly handle the load, double your price
> and move it back to SQL server again.
No, THAT post made my day. I think I could live on 488K / year :) Plus,
if you thought all the bizarreness you've seen me post before was
entertaining, just wait till I figure out a way to *successfully* put 170GB
back into access LOL!
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||Did they explicitly specify they need it done *successfully*? :)
ML
http://milambda.blogspot.com/|||Mike wrote on Thu, 6 Apr 2006 11:11:44 -0400:

> No, THAT post made my day. I think I could live on 488K / year :) Plus,
> if you thought all the bizarreness you've seen me post before was
> entertaining, just wait till I figure out a way to *successfully* put
> 170GB back into access LOL!
How about 86 mdb files - 85 with 2GB of data each, and 1 with linked tables
to the other 85 :P
Dan|||> How about 86 mdb files - 85 with 2GB of data each, and 1 with linked
> tables to the other 85 :P
Yup, that's precisely what they had before I arrived. I can hear Darth
Vader in the back of my brain: "The circle is now complete, Obi Wan..."
There is a certain masochistic part of me that is just ITCHING to redesign a
dumpster-full of .NET code into Access macros just to prove it can be done.
Think MS Press will publish my memoirs?
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||Now you've already mentioned enough reasons to just go and do it. If you
don't someone else on this NG will. :)
ML
http://milambda.blogspot.com/|||"Stuffing" 180 GB into an MS Access database is the easy part. It's
retreiving the data from MS Access that's the hard part.
"Mike Labosh" <mlabosh_at_hotmail.com> wrote in message
news:OOQslkYWGHA.3800@.TK2MSFTNGP03.phx.gbl...
>I spent 2 years of my life working on a successful migration from Access 97
>to SQL Server 2000.
> Redesign of the schemas. Redesign & rewrites of all their applications,
> from VBA to .NET. All successful and ontime.
> Then they laid off our entire department.
> I just got a message from one of my former co-workers: Apparently, now
> that they laid off all the programmers and SQL people, they no longer have
> anyone that knows SQL Server, so the company called one of my former
> bosses on the telephone (who also got laid off) and asked what it would
> take to stuff 170 GB back into MS Access.
> <hand slapping forehead>
> There are just not words.
> --
>
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>
>|||> Now you've already mentioned enough reasons to just go and do it. If you
> don't someone else on this NG will. :)
Terrific! They can be on the devteam. Tell me, do you have the guts to
work on a project with me, where we redesign God's entire universe as a
series of .txt files with .bat automation? hehe
I was the guy that out-argued any C++ programmer in any argument that went
like this: "You can't do [xyz] in VB"
Baloney. That's all the prompting I needed to do it. Huh? Graphics
programming in SQL? Done. So let's get moving on sending them a proposal
for an obscene amount of money :)
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei|||> "Stuffing" 180 GB into an MS Access database is the easy part. It's
> retreiving the data from MS Access that's the hard part.
Huh. I hadn't even thought of that. Just imagine the irony of one of the
server admins in PA, USA having to send an email to the help-desk in India
about how the file server right next to him is thrashing the RAID stack.
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2-way Merge Replication(PDA<->SqlServer2000)

I am working on Windows mobile platform using C#. I am using Merge Replication to do synchronization between SQL Server2000 and SQL Server 2005 Mobile edition and t is working fine.

The Server Tables are copied in the Client DB. It works fine with one way, i.e., server pushing data to Client Database (in PDA), but when i tried to update from PDA database, server keeps over writting PDA databse.

The requirement is that before adding our PDA database as subscriber,there are some tables with same name and structure as in Server with some records. After that i added it as subscriber and sycnchronized.The tables in the server are going to overwrite the records in PDA. My requirement is to not overrite the records but it should update the existing table.

Is it possible....Can Any one Help meeeeeeeeeeeee plzzzzzzzzzz.

Move to Sql Server Compact Edition. Thanks!

Zero Dai - MSFT

|||You must move the initial data to the server tables, or add initial data in code on the PDA after the first sync.|||

Hi all,

Thanks for the reply and Sorry for the delay.I have a new problem that,I alredy mentioned you i am using Sql Server 2000 as publisher.....In that i alreay Configured one Databse as Publisher....it is working fine and now i want to use another database as a publisher in the same server........the problem is this time it is not asking for Snapshot location while publishing the Database

Once we mentioned it is sufficient or wat to do.........to get Snapshot.exe file........I am assumed that the previous snapshot is sufficient and synchronized bt giving DB name and publisher name...But it is giving Native error:29061.

Another thing i did was,I disabled the Database as Publisher and try to publish from the first.This time it is asking for snapshot location but in that location it is not creating any snapshot.exe.......and not even Snapshot folder.wat to do.plz help meeeeeeeeeeeeeee.......

Thanks And Regards

Ayyappa.k

2nd Req: Series style function oddity in SP1

I'll try posting this again, since it garnered no reply the first time.
Greetings.
I found an odd issue when working with a series style in a line chart
in SP1. I was using my own function to determine the color of the
series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the
formula. My code is this:
Public Function PickColor(iResultSort As Integer) As String
Dim sColor As String
Select Case iResultSort
Case 0: sColor = "#000000" ' Black, Full
Case 3: sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
The ResultSort field is defined in SQL as an integer. What happened
on the chart is that the data line was drawn in the color expected,
but from the end of the line to the x axis, a black line was drawn.
If I change the code to use a String instead:
Public Function PickColor(sResultSort As String) As String
Dim sColor As String
Select Case sResultSort
Case "0": sColor = "#000000" ' Black, Full
Case "3": sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
then it draws as expected.
I would sort of like to know if there is something that I am missing
here that causes it to behave like this or if there is an issue with
the functionality.
I have the rdl and sample data as xml attached here, and can email
screenshots or whatever if desired.
Thanks.
Dale.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Chart Name="chart1">
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Fields!DPC.Value</Value>
</DataValue>
</DataValues>
<DataLabel />
<Style>
<BorderColor>
<Default>=Code.PickColor( Fields!ResultSort.Value
)</Default>
</BorderColor>
</Style>
<Marker>
<Type>Auto</Type>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>DataSet1</DataSetName>
<PointWidth>0</PointWidth>
<Type>Line</Type>
<Title />
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!DaysAfter.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!DaysAfter.Value</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!ResultSort.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!ResultSort.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Subtype>Plain</Subtype>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
</Chart>
</ReportItems>
<Style />
<Height>5.125in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="List_History ReadOnly">
<rd:DataSourceID>f2bd5a97-e7bc-444d-a3f9-b6f33e8fb5a7</rd:DataSourceID>
<DataSourceReference>List_History ReadOnly</DataSourceReference>
</DataSource>
</DataSources>
<Code>Public Function PickColor(iResultSort As Integer) As String
Dim sColor As String
Select Case iResultSort
Case 0: sColor = "#000000" ' Black, Full
Case 3: sColor = "#800000" ' Brown, Avg
End Select
PickColor = sColor
End Function
Public Function PickLineWidth(sResultSort As String) As String
Dim sWidth As String
Select Case sResultSort
Case 0: sWidth = "1.5pt" ' Thicker
Case Else: sWidth = "1pt" ' Normal
End Select
End Function
</Code>
<Width>6.625in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="DaysAfter">
<DataField>DaysAfter</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ResultSort">
<DataField>ResultSort</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="DPC">
<DataField>DPC</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>List_History ReadOnly</DataSourceName>
<CommandText>SELECT * FROM dbo.Dale</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<Description />
<rd:ReportID>1f236bff-9e92-4d02-a9b0-b41e2d7f6950</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
<SampleData>
<DataRow DaysAfter="34" ResultSort="0" DPC="4.07"/><DataRow
DaysAfter="65" ResultSort="0" DPC="4.07"/><DataRow DaysAfter="95"
ResultSort="0" DPC="4.07"/><DataRow DaysAfter="126" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="156" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="187" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="218" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="248" ResultSort="0"
DPC="4.07"/><DataRow DaysAfter="279" ResultSort="0"
DPC="4.07"/><DataRow ResultSort="0" DPC="4.07"/><DataRow
DaysAfter="34" ResultSort="1" DPC="3.06"/><DataRow DaysAfter="65"
ResultSort="1" DPC="3.06"/><DataRow DaysAfter="95" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="126" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="156" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="187" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="218" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="248" ResultSort="1"
DPC="3.06"/><DataRow DaysAfter="279" ResultSort="1"
DPC="3.06"/><DataRow ResultSort="1" DPC="3.06"/><DataRow
DaysAfter="34" ResultSort="3" DPC="8.59"/><DataRow DaysAfter="65"
ResultSort="3" DPC="11.32"/><DataRow DaysAfter="95" ResultSort="3"
DPC="14.78"/><DataRow DaysAfter="126" ResultSort="3"
DPC="15.42"/><DataRow DaysAfter="156" ResultSort="3"
DPC="16.04"/><DataRow DaysAfter="187" ResultSort="3"
DPC="16.33"/></SampleData>Please check this posting:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f33c29d0-dbdf-4509-b67c-e517c1959e64&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dale M." <Dale M.@.discussions.microsoft.com> wrote in message
news:350063B1-CBC5-47A0-88F4-933A9F1E864F@.microsoft.com...
> I'll try posting this again, since it garnered no reply the first time.
> Greetings.
> I found an odd issue when working with a series style in a line chart
> in SP1. I was using my own function to determine the color of the
> series. So I entered =Code.PickColor(Fields!ResultSort.Value) for the
> formula. My code is this:
> Public Function PickColor(iResultSort As Integer) As String
> Dim sColor As String
> Select Case iResultSort
> Case 0: sColor = "#000000" ' Black, Full
> Case 3: sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> The ResultSort field is defined in SQL as an integer. What happened
> on the chart is that the data line was drawn in the color expected,
> but from the end of the line to the x axis, a black line was drawn.
> If I change the code to use a String instead:
> Public Function PickColor(sResultSort As String) As String
> Dim sColor As String
> Select Case sResultSort
> Case "0": sColor = "#000000" ' Black, Full
> Case "3": sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> then it draws as expected.
> I would sort of like to know if there is something that I am missing
> here that causes it to behave like this or if there is an issue with
> the functionality.
> I have the rdl and sample data as xml attached here, and can email
> screenshots or whatever if desired.
> Thanks.
> Dale.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
>
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefini
tion"
>
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <RightMargin>1in</RightMargin>
> <Body>
> <ReportItems>
> <Chart Name="chart1">
> <ThreeDProperties>
> <Rotation>30</Rotation>
> <Inclination>30</Inclination>
> <Shading>Simple</Shading>
> <WallThickness>50</WallThickness>
> </ThreeDProperties>
> <Style>
> <BackgroundColor>White</BackgroundColor>
> </Style>
> <Legend>
> <Visible>true</Visible>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> <Position>RightCenter</Position>
> </Legend>
> <Palette>Default</Palette>
> <ChartData>
> <ChartSeries>
> <DataPoints>
> <DataPoint>
> <DataValues>
> <DataValue>
> <Value>=Fields!DPC.Value</Value>
> </DataValue>
> </DataValues>
> <DataLabel />
> <Style>
> <BorderColor>
> <Default>=Code.PickColor( Fields!ResultSort.Value
> )</Default>
> </BorderColor>
> </Style>
> <Marker>
> <Type>Auto</Type>
> <Size>6pt</Size>
> </Marker>
> </DataPoint>
> </DataPoints>
> </ChartSeries>
> </ChartData>
> <CategoryAxis>
> <Axis>
> <Title />
> <MajorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <Min>0</Min>
> <Visible>true</Visible>
> </Axis>
> </CategoryAxis>
> <DataSetName>DataSet1</DataSetName>
> <PointWidth>0</PointWidth>
> <Type>Line</Type>
> <Title />
> <CategoryGroupings>
> <CategoryGrouping>
> <DynamicCategories>
> <Grouping Name="chart1_CategoryGroup1">
> <GroupExpressions>
>
<GroupExpression>=Fields!DaysAfter.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Label>=Fields!DaysAfter.Value</Label>
> </DynamicCategories>
> </CategoryGrouping>
> </CategoryGroupings>
> <SeriesGroupings>
> <SeriesGrouping>
> <DynamicSeries>
> <Grouping Name="chart1_SeriesGroup1">
> <GroupExpressions>
>
<GroupExpression>=Fields!ResultSort.Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Label>=Fields!ResultSort.Value</Label>
> </DynamicSeries>
> </SeriesGrouping>
> </SeriesGroupings>
> <Subtype>Plain</Subtype>
> <PlotArea>
> <Style>
> <BackgroundColor>White</BackgroundColor>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </PlotArea>
> <ValueAxis>
> <Axis>
> <Title />
> <MajorGridLines>
> <ShowGridLines>true</ShowGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MajorGridLines>
> <MinorGridLines>
> <Style>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> </Style>
> </MinorGridLines>
> <MajorTickMarks>Outside</MajorTickMarks>
> <Min>0</Min>
> <Margin>true</Margin>
> <Visible>true</Visible>
> <Scalar>true</Scalar>
> </Axis>
> </ValueAxis>
> </Chart>
> </ReportItems>
> <Style />
> <Height>5.125in</Height>
> </Body>
> <TopMargin>1in</TopMargin>
> <DataSources>
> <DataSource Name="List_History ReadOnly">
>
<rd:DataSourceID>f2bd5a97-e7bc-444d-a3f9-b6f33e8fb5a7</rd:DataSourceID>
> <DataSourceReference>List_History ReadOnly</DataSourceReference>
> </DataSource>
> </DataSources>
> <Code>Public Function PickColor(iResultSort As Integer) As String
> Dim sColor As String
> Select Case iResultSort
> Case 0: sColor = "#000000" ' Black, Full
> Case 3: sColor = "#800000" ' Brown, Avg
> End Select
> PickColor = sColor
> End Function
> Public Function PickLineWidth(sResultSort As String) As String
> Dim sWidth As String
> Select Case sResultSort
> Case 0: sWidth = "1.5pt" ' Thicker
> Case Else: sWidth = "1pt" ' Normal
> End Select
> End Function
> </Code>
> <Width>6.625in</Width>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="DaysAfter">
> <DataField>DaysAfter</DataField>
> <rd:TypeName>System.Int32</rd:TypeName>
> </Field>
> <Field Name="ResultSort">
> <DataField>ResultSort</DataField>
> <rd:TypeName>System.Int32</rd:TypeName>
> </Field>
> <Field Name="DPC">
> <DataField>DPC</DataField>
> <rd:TypeName>System.Decimal</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>List_History ReadOnly</DataSourceName>
> <CommandText>SELECT * FROM dbo.Dale</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <LeftMargin>1in</LeftMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <rd:DrawGrid>true</rd:DrawGrid>
> <Description />
> <rd:ReportID>1f236bff-9e92-4d02-a9b0-b41e2d7f6950</rd:ReportID>
> <BottomMargin>1in</BottomMargin>
> <Language>en-US</Language>
> </Report>
> <SampleData>
> <DataRow DaysAfter="34" ResultSort="0" DPC="4.07"/><DataRow
> DaysAfter="65" ResultSort="0" DPC="4.07"/><DataRow DaysAfter="95"
> ResultSort="0" DPC="4.07"/><DataRow DaysAfter="126" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="156" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="187" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="218" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="248" ResultSort="0"
> DPC="4.07"/><DataRow DaysAfter="279" ResultSort="0"
> DPC="4.07"/><DataRow ResultSort="0" DPC="4.07"/><DataRow
> DaysAfter="34" ResultSort="1" DPC="3.06"/><DataRow DaysAfter="65"
> ResultSort="1" DPC="3.06"/><DataRow DaysAfter="95" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="126" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="156" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="187" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="218" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="248" ResultSort="1"
> DPC="3.06"/><DataRow DaysAfter="279" ResultSort="1"
> DPC="3.06"/><DataRow ResultSort="1" DPC="3.06"/><DataRow
> DaysAfter="34" ResultSort="3" DPC="8.59"/><DataRow DaysAfter="65"
> ResultSort="3" DPC="11.32"/><DataRow DaysAfter="95" ResultSort="3"
> DPC="14.78"/><DataRow DaysAfter="126" ResultSort="3"
> DPC="15.42"/><DataRow DaysAfter="156" ResultSort="3"
> DPC="16.04"/><DataRow DaysAfter="187" ResultSort="3"
> DPC="16.33"/></SampleData>
>

2nd lowest with tie

I am working with 3 tables: STUDENTS, GRADES, COURSES

Students GRADES COURSES

Jean 88 Algebra I

Rachel 55 Chemistry

Charlie 75 History

Bud 90 Algebra I

JD 62 Chemistry

Alton 96 History

Jean 81 History

Rachel 40 Algebra I

Jean 79 Chemistry

Charlie 64 Chemistry

Alton 83 Algebra I

Bud 70 Chemistry

I need to find only the second lowest grade among the scores where the student did not take enrolled for History.

thank you

Any comment is welcome

3 tables or 3 columns ?|||declare @.table table
(
Students varchar(10),
GRADES int,
COURSES varchar(10)
)
insert into @.table
select 'Jean', 88, 'Algebra I' union all
select 'Rachel', 55, 'Chemistry' union all
select 'Charlie', 75, 'History' union all
select 'Bud', 90, 'Algebra I' union all
select 'JD', 62, 'Chemistry' union all
select 'Alton', 96, 'History' union all
select 'Jean', 81, 'History' union all
select 'Rachel', 40, 'Algebra I' union all
select 'Jean', 79, 'Chemistry' union all
select 'Charlie', 64, 'Chemistry' union all
select 'Alton', 83, 'Algebra I' union all
select 'Bud', 70, 'Chemistry'

select top 1 *
from
(
select top 2 *
from @.table t
where not exists (select * from @.table x where x.COURSES = 'History' and x.Students = t.Students)
order by GRADES
) a
order by GRADES desc|||

I apologize and should have specify the tables structure. You may disregard my previous post. I am working with 3 tables: INVOICE, TELEVISION, INV_LINE_ITEM.

INVOICE Table TELEVISION Table INV_LINE_ITEM Table

InvoiceDt Type InvoiceNbrFK

InvoiceNbrPK Manufacturer SerialNumberFK

EmpIDFK size Quantity

TotalPrice SerialNumberPK LineNbr

I just want to find out only the invoice number that contains the second lowest total price among the invoices and where the type is not HDTV.

I wrote this query here but I am not so sure about it. Help

SELECT top 1 Invoicenbr, CONVERT(CHAR(25), invoicedt)AS 'Invoice Date',

CAST(min(totalprice) as char(10)) as 'Total Price'

FROM invoice

WHERE totalprice >

(SELECT min(totalprice)

FROM invoice

WHERE invoicenbr in

(SELECT invoicenbrFK

FROM inv_line_item

WHERE serialnumberFK not in

(SELECT serialnumber

FROM Television

WHERE serialnumber = serialnumberFK and type< >'hdtv')))

GROUP by totalprice, invoicenbr, invoicedt;;

|||

Am I right in thinking that you need the invoice with the second lowest price which does not include a line for a television of type HDTV.

In which case the variation on K H Tan's example is I believe:

SELECT TOP 1 InvoiceNbr,
CONVERT(CHAR(25), invoicedt)AS 'Invoice Date',
CAST(min(totalprice) as char(10)) as 'Total Price'
FROM (
SELECT TOP 2 *
FROM INVOICE
WHERE InvoiceNbr NOT IN (
SELECT LIN.InvoiceNbr
FROM INV_LINE_ITEM LIN
INNER JOIN TELEVISION TV
ON (LIN.SerialNumber = TV.SerialNumber ) AND
(TV.Type = 'hdtv')
)
ORDER BY TotalPrice
) A
ORDER BY TotalPrice DESC

I did not use the PK and FK suffixes as you did not have them in your sample SQL.

|||mermaid,

can you post the table structure with sample data and the result that you want similar to my 1st post it will be easier for us to help you|||

Hi,

Your example was a very great help. I added a few changes and I got the projection expected. Here is my final query:

SELECT TOP 1 I.InvoiceNbr,
CONVERT(CHAR(25), I.invoicedt)AS 'Invoice Date',
CAST(min(totalprice) as char(10)) as 'Total Price'
FROM (
SELECT TOP 2 *
FROM INVOICE
WHERE InvoiceNbr NOT IN (
SELECT LIN.InvoiceNbr
FROM INV_LINE_ITEM LIN
JOIN TELEVISION TV
ON (LIN.SerialNumber = TV.SerialNumber ) AND
(TV.Type = 'hdtv')
)
ORDER BY TotalPrice
) I
ORDER BY TotalPrice DESC

Thank you so much.

|||

Hi,

I work on the example posted by one of the user and got the right result. Thank you K H and I do appreciate your help.

2005Management Studio

We have SQL 2005 -- Yukon 9.00.852 running on one machine.

Couple of days ago it is working fine and I am using the Object explorer in Management studio. Know suddnly all the database are gone from object explorer and I only can not see the server name and no database under it.

How I can bring all the database backu in Object explort--management studio.

From command line I can access all the databases. They are up and running fine.

Please email me at consultant_5400@.yahoo.com.

Did you already try File->Connect Object Explorer?

Sayed Ibrahim Hashimi
www.sedodream.com
|||

Yes I try that , It did not work, I also try to register the server again and it also did not not work.

May be best option is to install Management studio only again. But we have one database on it.

Thanks

|||Did you check the error logs and tempdb size? In SQL2000, full tempdb would be a reason for databases not displaying in EM - perhaps this is the same in SQL2005? Just an idea...|||

Hi,

Please can you let me know if it is a temp database issue how to fix that.

I already restart the services, But still it is not showing us databases in EM.

2005 Walkthrough Database Needed.

How can I get Northwind into SQL Server 2005 Development?

In working through Visual Studio 2005 Pro Walkthroughs the next one needs Northwind. Is it straight forward to add in?

Here are step-by-step instruction to add the Northwind database to SQL Server 2005:Moving Data from SQL Server 2000 to SQL Server 2005|||

Many thanks for the reply.

Will give it a try during the day.

Just slightly puzzled why a MS Walkthrough does not show the included AdventureWorks but will try that too to get started.

Derek.

2005 URL ris:format=PDF not working

Using the new reporting services I am unable to get the report to go straight
to a pdf...I can select export and it goes fine...below is my url:
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
what am ai doing wrong?Is everything on one machine? Or are you using IE from one machine and RS is
on another?
I was just doing this myself (with CSV instead of PDF) and I found that the
global variable Globals!ReportServerUrl is putting in localhost instead of
the server name (I see below that you have localhost which is why I was
wondering if you are seeing the same issue). If I go to the server and use a
browser from there then my jump to URL works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> Using the new reporting services I am unable to get the report to go
> straight
> to a pdf...I can select export and it goes fine...below is my url:
> http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> what am ai doing wrong?|||yes I am on my development machine with the server and it does not work.
"Bruce L-C [MVP]" wrote:
> Is everything on one machine? Or are you using IE from one machine and RS is
> on another?
> I was just doing this myself (with CSV instead of PDF) and I found that the
> global variable Globals!ReportServerUrl is putting in localhost instead of
> the server name (I see below that you have localhost which is why I was
> wondering if you are seeing the same issue). If I go to the server and use a
> browser from there then my jump to URL works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> > Using the new reporting services I am unable to get the report to go
> > straight
> > to a pdf...I can select export and it goes fine...below is my url:
> >
> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >
> > what am ai doing wrong?
>
>|||Here is a working URL. The folder is called Demo. The report is called Sales
Order 2 Two parameters StartDate and EndDate
Note that parameters are case sensitive. The %20 is the encoding for space.
Rendering is the default so you can leave it off the line.
Try to match my pattern here and hopefully it will work for you. The user
will still have to click open, it will not automatically open
http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> yes I am on my development machine with the server and it does not work.
>
> "Bruce L-C [MVP]" wrote:
>> Is everything on one machine? Or are you using IE from one machine and RS
>> is
>> on another?
>> I was just doing this myself (with CSV instead of PDF) and I found that
>> the
>> global variable Globals!ReportServerUrl is putting in localhost instead
>> of
>> the server name (I see below that you have localhost which is why I was
>> wondering if you are seeing the same issue). If I go to the server and
>> use a
>> browser from there then my jump to URL works.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> > Using the new reporting services I am unable to get the report to go
>> > straight
>> > to a pdf...I can select export and it goes fine...below is my url:
>> >
>> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >
>> > what am ai doing wrong?
>>|||Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
What I am looking for is to simulate the report server actions of selecting
the PDF format and clicking the export link,
opens another window and its converted to the PDF format but already open to
the PDF viewer.
Then if the user wants to save it from there they can, butthe ofrmatting
seems more stable this way.
Is this not possible with the url?
"Bruce L-C [MVP]" wrote:
> Here is a working URL. The folder is called Demo. The report is called Sales
> Order 2 Two parameters StartDate and EndDate
> Note that parameters are case sensitive. The %20 is the encoding for space.
> Rendering is the default so you can leave it off the line.
> Try to match my pattern here and hopefully it will work for you. The user
> will still have to click open, it will not automatically open
> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> > yes I am on my development machine with the server and it does not work.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Is everything on one machine? Or are you using IE from one machine and RS
> >> is
> >> on another?
> >>
> >> I was just doing this myself (with CSV instead of PDF) and I found that
> >> the
> >> global variable Globals!ReportServerUrl is putting in localhost instead
> >> of
> >> the server name (I see below that you have localhost which is why I was
> >> wondering if you are seeing the same issue). If I go to the server and
> >> use a
> >> browser from there then my jump to URL works.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> > Using the new reporting services I am unable to get the report to go
> >> > straight
> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >
> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >
> >> > what am ai doing wrong?
> >>
> >>
> >>
>
>|||Export is working differently in RS 2005. Previously it gave you the
open/save dialog. Now it is opening it up in the browser. It seems like if
the export functionality can open it up in the browser then we should be
able to do it with the URL. I tried several things and cannot get it to
happen. I will use my MS contacts to see if there is a way to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> What I am looking for is to simulate the report server actions of
> selecting
> the PDF format and clicking the export link,
> opens another window and its converted to the PDF format but already open
> to
> the PDF viewer.
> Then if the user wants to save it from there they can, butthe ofrmatting
> seems more stable this way.
> Is this not possible with the url?
> "Bruce L-C [MVP]" wrote:
>> Here is a working URL. The folder is called Demo. The report is called
>> Sales
>> Order 2 Two parameters StartDate and EndDate
>> Note that parameters are case sensitive. The %20 is the encoding for
>> space.
>> Rendering is the default so you can leave it off the line.
>> Try to match my pattern here and hopefully it will work for you. The user
>> will still have to click open, it will not automatically open
>> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> > yes I am on my development machine with the server and it does not
>> > work.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Is everything on one machine? Or are you using IE from one machine and
>> >> RS
>> >> is
>> >> on another?
>> >>
>> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> that
>> >> the
>> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> instead
>> >> of
>> >> the server name (I see below that you have localhost which is why I
>> >> was
>> >> wondering if you are seeing the same issue). If I go to the server and
>> >> use a
>> >> browser from there then my jump to URL works.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> > Using the new reporting services I am unable to get the report to go
>> >> > straight
>> >> > to a pdf...I can select export and it goes fine...below is my url:
>> >> >
>> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >
>> >> > what am ai doing wrong?
>> >>
>> >>
>> >>
>>|||That would be Great!
THANKS!
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||any luck on this...?
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I've sent an email. No response yet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> any luck on this...?
> "Bruce L-C [MVP]" wrote:
>> Export is working differently in RS 2005. Previously it gave you the
>> open/save dialog. Now it is opening it up in the browser. It seems like
>> if
>> the export functionality can open it up in the browser then we should be
>> able to do it with the URL. I tried several things and cannot get it to
>> happen. I will use my MS contacts to see if there is a way to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
>> > Thanks, that works to get me a SAVEAS dialog with the pdf file
>> > perfectly!
>> >
>> > What I am looking for is to simulate the report server actions of
>> > selecting
>> > the PDF format and clicking the export link,
>> > opens another window and its converted to the PDF format but already
>> > open
>> > to
>> > the PDF viewer.
>> >
>> > Then if the user wants to save it from there they can, butthe
>> > ofrmatting
>> > seems more stable this way.
>> >
>> > Is this not possible with the url?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here is a working URL. The folder is called Demo. The report is called
>> >> Sales
>> >> Order 2 Two parameters StartDate and EndDate
>> >>
>> >> Note that parameters are case sensitive. The %20 is the encoding for
>> >> space.
>> >> Rendering is the default so you can leave it off the line.
>> >>
>> >> Try to match my pattern here and hopefully it will work for you. The
>> >> user
>> >> will still have to click open, it will not automatically open
>> >>
>> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> >> > yes I am on my development machine with the server and it does not
>> >> > work.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Is everything on one machine? Or are you using IE from one machine
>> >> >> and
>> >> >> RS
>> >> >> is
>> >> >> on another?
>> >> >>
>> >> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> >> that
>> >> >> the
>> >> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> >> instead
>> >> >> of
>> >> >> the server name (I see below that you have localhost which is why I
>> >> >> was
>> >> >> wondering if you are seeing the same issue). If I go to the server
>> >> >> and
>> >> >> use a
>> >> >> browser from there then my jump to URL works.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> >> > Using the new reporting services I am unable to get the report to
>> >> >> > go
>> >> >> > straight
>> >> >> > to a pdf...I can select export and it goes fine...below is my
>> >> >> > url:
>> >> >> >
>> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >> >
>> >> >> > what am ai doing wrong?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks!
"Bruce L-C [MVP]" wrote:
> I've sent an email. No response yet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> > any luck on this...?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Export is working differently in RS 2005. Previously it gave you the
> >> open/save dialog. Now it is opening it up in the browser. It seems like
> >> if
> >> the export functionality can open it up in the browser then we should be
> >> able to do it with the URL. I tried several things and cannot get it to
> >> happen. I will use my MS contacts to see if there is a way to do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> >> > Thanks, that works to get me a SAVEAS dialog with the pdf file
> >> > perfectly!
> >> >
> >> > What I am looking for is to simulate the report server actions of
> >> > selecting
> >> > the PDF format and clicking the export link,
> >> > opens another window and its converted to the PDF format but already
> >> > open
> >> > to
> >> > the PDF viewer.
> >> >
> >> > Then if the user wants to save it from there they can, butthe
> >> > ofrmatting
> >> > seems more stable this way.
> >> >
> >> > Is this not possible with the url?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Here is a working URL. The folder is called Demo. The report is called
> >> >> Sales
> >> >> Order 2 Two parameters StartDate and EndDate
> >> >>
> >> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> >> space.
> >> >> Rendering is the default so you can leave it off the line.
> >> >>
> >> >> Try to match my pattern here and hopefully it will work for you. The
> >> >> user
> >> >> will still have to click open, it will not automatically open
> >> >>
> >> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> >> > yes I am on my development machine with the server and it does not
> >> >> > work.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Is everything on one machine? Or are you using IE from one machine
> >> >> >> and
> >> >> >> RS
> >> >> >> is
> >> >> >> on another?
> >> >> >>
> >> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> >> that
> >> >> >> the
> >> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> >> instead
> >> >> >> of
> >> >> >> the server name (I see below that you have localhost which is why I
> >> >> >> was
> >> >> >> wondering if you are seeing the same issue). If I go to the server
> >> >> >> and
> >> >> >> use a
> >> >> >> browser from there then my jump to URL works.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> >> > Using the new reporting services I am unable to get the report to
> >> >> >> > go
> >> >> >> > straight
> >> >> >> > to a pdf...I can select export and it goes fine...below is my
> >> >> >> > url:
> >> >> >> >
> >> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >> >
> >> >> >> > what am ai doing wrong?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

2005 issues with BinaryWrite?

I have moved over some data from 2000 to SQL 2005. The data is the
same, but now some existing working code is not working with the
BinaryWrite method of Response.BinaryWrite in an ASP page.
In a field in a table that is ntext. It contains HTML data tags. ie.
<P><B>this is</b> etc... etc.. </P>
Before moving to 2005 the following classic ASP code worked (recordset
setup correctly):
dim mFieldSize, mBytes
mFieldSize = rs.Fields("keywords").ActualSize
mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
Response.BinaryWrite mBytes
now with the data in 2005 I get this error:
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another. Is this a coding error, or a type error
problem that I have to do differently with 2005?
If anyone knows of the solution to this problem please let me know.
Thanks
*** Sent via Developersdex http://www.codecomments.com ***Have you tried Response.Write instead of Response.BinaryWrite? It might be
that SQL 2005 is returning a variant datatype family of Unicode rather than
binary because the underlying data is Unicode (ntext).
Hope this helps.
Dan Guzman
SQL Server MVP
"E L" <smakawhat@.yahoo.com> wrote in message
news:uoLwI110GHA.1268@.TK2MSFTNGP02.phx.gbl...
>I have moved over some data from 2000 to SQL 2005. The data is the
> same, but now some existing working code is not working with the
> BinaryWrite method of Response.BinaryWrite in an ASP page.
> In a field in a table that is ntext. It contains HTML data tags. ie.
> <P><B>this is</b> etc... etc.. </P>
> Before moving to 2005 the following classic ASP code worked (recordset
> setup correctly):
> dim mFieldSize, mBytes
> mFieldSize = rs.Fields("keywords").ActualSize
> mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
> Response.BinaryWrite mBytes
> now with the data in 2005 I get this error:
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another. Is this a coding error, or a type error
> problem that I have to do differently with 2005?
> If anyone knows of the solution to this problem please let me know.
> Thanks
> *** Sent via Developersdex http://www.codecomments.com ***

2005 issues with BinaryWrite?

I have moved over some data from 2000 to SQL 2005. The data is the
same, but now some existing working code is not working with the
BinaryWrite method of Response.BinaryWrite in an ASP page.
In a field in a table that is ntext. It contains HTML data tags. ie.
<P><B>this is</b> etc... etc.. </P>
Before moving to 2005 the following classic ASP code worked (recordset
setup correctly):
dim mFieldSize, mBytes
mFieldSize = rs.Fields("keywords").ActualSize
mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
Response.BinaryWrite mBytes
now with the data in 2005 I get this error:
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another. Is this a coding error, or a type error
problem that I have to do differently with 2005?
If anyone knows of the solution to this problem please let me know.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***Have you tried Response.Write instead of Response.BinaryWrite? It might be
that SQL 2005 is returning a variant datatype family of Unicode rather than
binary because the underlying data is Unicode (ntext).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"E L" <smakawhat@.yahoo.com> wrote in message
news:uoLwI110GHA.1268@.TK2MSFTNGP02.phx.gbl...
>I have moved over some data from 2000 to SQL 2005. The data is the
> same, but now some existing working code is not working with the
> BinaryWrite method of Response.BinaryWrite in an ASP page.
> In a field in a table that is ntext. It contains HTML data tags. ie.
> <P><B>this is</b> etc... etc.. </P>
> Before moving to 2005 the following classic ASP code worked (recordset
> setup correctly):
> dim mFieldSize, mBytes
> mFieldSize = rs.Fields("keywords").ActualSize
> mBytes = rs.Fields("keywords").GetChunk(mFieldSize)
> Response.BinaryWrite mBytes
> now with the data in 2005 I get this error:
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another. Is this a coding error, or a type error
> problem that I have to do differently with 2005?
> If anyone knows of the solution to this problem please let me know.
> Thanks
> *** Sent via Developersdex http://www.developersdex.com ***

2005 features not working

I have both sql 2000 and sql2005 installed on a machine and with management
studio it seems to show the databases created in 2000 but does not seem to
have many of the new features of 2005. It seems as though it is not
operating against a SQL Server 2005 installation although 2005 is installed.
Just wondering if I would need to remove sql2000 for 2005 to operate with
full features?
thanks.
Paul G
Software engineer.
What new features are you referring to that you expect to see that you
don't? If you are talking about not being able to use some of the new
features make sure your db in 90 compatibility mode. If you upgrade a 2000
db it stays in 80 compat mode.
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>I have both sql 2000 and sql2005 installed on a machine and with management
> studio it seems to show the databases created in 2000 but does not seem to
> have many of the new features of 2005. It seems as though it is not
> operating against a SQL Server 2005 installation although 2005 is
> installed.
> Just wondering if I would need to remove sql2000 for 2005 to operate with
> full features?
> thanks.
> --
> Paul G
> Software engineer.
|||for example in viewing databases I did not see a section for schema in the
object explorer so could not add one. Also in following the instructions to
create a cube, I could not because a cube folder was not present after a new
solution was created in the project explorer. Also I noticed on the status
bar it lists the computer name followed by (8.0 RTM), does this mean it is
not the full feature version running? Also how do you switch it to the 90
compatable mode?
thanks
Paul G
Software engineer.
"Andrew J. Kelly" wrote:

> What new features are you referring to that you expect to see that you
> don't? If you are talking about not being able to use some of the new
> features make sure your db in 90 compatibility mode. If you upgrade a 2000
> db it stays in 80 compat mode.
> --
> Andrew J. Kelly SQL MVP
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>
>
|||Also note that you can have only one default (server name only) instance.
If your SQL 2000 instance is the default instance, then the installed SQL
2005 instance must be a named instance. You can connect to named instances
using '<server name>\<instance name>'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...[vbcol=seagreen]
> for example in viewing databases I did not see a section for schema in the
> object explorer so could not add one. Also in following the instructions
> to
> create a cube, I could not because a cube folder was not present after a
> new
> solution was created in the project explorer. Also I noticed on the
> status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running? Also how do you switch it to the 90
> compatable mode?
> thanks
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
|||Thanks for the information, I looked at the programs installed it lists
Microsoft SQL 2005 so think I have it installed.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> It means that the server (instance) you have connected to is SQL Server 2000. Perhaps you only
> upgraded the client tools?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
>
|||So do I need to create a new dbase out of management studio, so would this
work out of management studio query window,
using '<computer name>\<mssql 2005>'.
thanks.
Paul G
Software engineer.
"Dan Guzman" wrote:

> Also note that you can have only one default (server name only) instance.
> If your SQL 2000 instance is the default instance, then the installed SQL
> 2005 instance must be a named instance. You can connect to named instances
> using '<server name>\<instance name>'.
>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
>
|||> Thanks for the information, I looked at the programs installed it lists
> Microsoft SQL 2005 so think I have it installed.
That could still only be the client tools.
Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
Server", or both?
A
|||Hi here is what I have listed in the services section from the control panel,
SQL Server (SQLEXPRESS)-probably should remove this
SQL Server Active Directory Helper
SQL Server Analysis Services (MSSQLSERVER)
SQL Server Browser
SQL Server Integration Services
SQL Server Reporting Services (MSSQLSERVER)
SQL Server VSS Writer
MSSQLSERVER
SQLSERVERAGENT
I did not see a SQL Server by itself. Guess it does not specify the year
just from the service listing. Does this look like only the client may be
installed? Also I installed it off of the Visual Studio 2005 professional
addition, disk labeled SQL Server 2005 Developer edition. Thanks.
Paul G
Software engineer.
"Aaron Bertrand [SQL Server MVP]" wrote:

> That could still only be the client tools.
> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
> Server", or both?
> A
>
>
|||Hi thanks for the additional information. Do you know if I can install the
2005 SQL Server agent without effecting the 2000 server agent as I have
several jobs scheduled? Also looks like I do not have the database engine
installed 2005 as you noted. Does this come with the SQL Server 2005
Developer edition (guessing it does) and can it be installed along with the
2000 database engine without effecting the 2000 instance? If so not sure why
it was not installed, guess I may have not selected the proper installation
option.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
> service name):
> MSSQLSERVER
> SQLSERVERAGENT
> (In 2005, a service has both a long name and a short name. However, the tools you use will present
> the long name.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>
>
|||Hi I installed the SQL Svr Developer Edtn 2005 disk and have the following
selections for installation/repair
SQL Server Database Services
Analysis Services
Reporting Services
Notification Services
Integration Services
Workstation Components, Books online and Development tools.
Anyhow I was expecting to see SQL Server components but did not, do you know
if the SQL Server Database Services should install the database engine?
thanks.
Paul G
Software engineer.
"Tibor Karaszi" wrote:

> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>
> Yep. As per above, just install a new database engine instance.
>
> That would be my guess as well.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
>
>

2005 features not working

I have both sql 2000 and sql2005 installed on a machine and with management
studio it seems to show the databases created in 2000 but does not seem to
have many of the new features of 2005. It seems as though it is not
operating against a SQL Server 2005 installation although 2005 is installed.
Just wondering if I would need to remove sql2000 for 2005 to operate with
full features?
thanks.
--
Paul G
Software engineer.What new features are you referring to that you expect to see that you
don't? If you are talking about not being able to use some of the new
features make sure your db in 90 compatibility mode. If you upgrade a 2000
db it stays in 80 compat mode.
--
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>I have both sql 2000 and sql2005 installed on a machine and with management
> studio it seems to show the databases created in 2000 but does not seem to
> have many of the new features of 2005. It seems as though it is not
> operating against a SQL Server 2005 installation although 2005 is
> installed.
> Just wondering if I would need to remove sql2000 for 2005 to operate with
> full features?
> thanks.
> --
> Paul G
> Software engineer.|||for example in viewing databases I did not see a section for schema in the
object explorer so could not add one. Also in following the instructions to
create a cube, I could not because a cube folder was not present after a new
solution was created in the project explorer. Also I noticed on the status
bar it lists the computer name followed by (8.0 RTM), does this mean it is
not the full feature version running? Also how do you switch it to the 90
compatable mode?
thanks
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:
> What new features are you referring to that you expect to see that you
> don't? If you are talking about not being able to use some of the new
> features make sure your db in 90 compatibility mode. If you upgrade a 2000
> db it stays in 80 compat mode.
> --
> Andrew J. Kelly SQL MVP
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
> >I have both sql 2000 and sql2005 installed on a machine and with management
> > studio it seems to show the databases created in 2000 but does not seem to
> > have many of the new features of 2005. It seems as though it is not
> > operating against a SQL Server 2005 installation although 2005 is
> > installed.
> > Just wondering if I would need to remove sql2000 for 2005 to operate with
> > full features?
> > thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||> Also I noticed on the status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running?
It means that the server (instance) you have connected to is SQL Server 2000. Perhaps you only
upgraded the client tools?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
> for example in viewing databases I did not see a section for schema in the
> object explorer so could not add one. Also in following the instructions to
> create a cube, I could not because a cube folder was not present after a new
> solution was created in the project explorer. Also I noticed on the status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running? Also how do you switch it to the 90
> compatable mode?
> thanks
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>> What new features are you referring to that you expect to see that you
>> don't? If you are talking about not being able to use some of the new
>> features make sure your db in 90 compatibility mode. If you upgrade a 2000
>> db it stays in 80 compat mode.
>> --
>> Andrew J. Kelly SQL MVP
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >I have both sql 2000 and sql2005 installed on a machine and with management
>> > studio it seems to show the databases created in 2000 but does not seem to
>> > have many of the new features of 2005. It seems as though it is not
>> > operating against a SQL Server 2005 installation although 2005 is
>> > installed.
>> > Just wondering if I would need to remove sql2000 for 2005 to operate with
>> > full features?
>> > thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||Also note that you can have only one default (server name only) instance.
If your SQL 2000 instance is the default instance, then the installed SQL
2005 instance must be a named instance. You can connect to named instances
using '<server name>\<instance name>'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
> for example in viewing databases I did not see a section for schema in the
> object explorer so could not add one. Also in following the instructions
> to
> create a cube, I could not because a cube folder was not present after a
> new
> solution was created in the project explorer. Also I noticed on the
> status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running? Also how do you switch it to the 90
> compatable mode?
> thanks
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>> What new features are you referring to that you expect to see that you
>> don't? If you are talking about not being able to use some of the new
>> features make sure your db in 90 compatibility mode. If you upgrade a
>> 2000
>> db it stays in 80 compat mode.
>> --
>> Andrew J. Kelly SQL MVP
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >I have both sql 2000 and sql2005 installed on a machine and with
>> >management
>> > studio it seems to show the databases created in 2000 but does not seem
>> > to
>> > have many of the new features of 2005. It seems as though it is not
>> > operating against a SQL Server 2005 installation although 2005 is
>> > installed.
>> > Just wondering if I would need to remove sql2000 for 2005 to operate
>> > with
>> > full features?
>> > thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||> Thanks for the information, I looked at the programs installed it lists
> Microsoft SQL 2005 so think I have it installed.
That could still only be the client tools.
Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
Server", or both?
A|||What services (related to SQL Server) do you have. There is no doubt that you did connect to an SQL
Server 2000 instance. So either you only upgraded/installed the client tools, or you installed a new
instance but you still connect to the 2000 instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:1DFFDACB-423B-453C-A4C0-D2CA872B698C@.microsoft.com...
> Thanks for the information, I looked at the programs installed it lists
> Microsoft SQL 2005 so think I have it installed.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Also I noticed on the status
>> > bar it lists the computer name followed by (8.0 RTM), does this mean it is
>> > not the full feature version running?
>> It means that the server (instance) you have connected to is SQL Server 2000. Perhaps you only
>> upgraded the client tools?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
>> > for example in viewing databases I did not see a section for schema in the
>> > object explorer so could not add one. Also in following the instructions to
>> > create a cube, I could not because a cube folder was not present after a new
>> > solution was created in the project explorer. Also I noticed on the status
>> > bar it lists the computer name followed by (8.0 RTM), does this mean it is
>> > not the full feature version running? Also how do you switch it to the 90
>> > compatable mode?
>> > thanks
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> What new features are you referring to that you expect to see that you
>> >> don't? If you are talking about not being able to use some of the new
>> >> features make sure your db in 90 compatibility mode. If you upgrade a 2000
>> >> db it stays in 80 compat mode.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >> >I have both sql 2000 and sql2005 installed on a machine and with management
>> >> > studio it seems to show the databases created in 2000 but does not seem to
>> >> > have many of the new features of 2005. It seems as though it is not
>> >> > operating against a SQL Server 2005 installation although 2005 is
>> >> > installed.
>> >> > Just wondering if I would need to remove sql2000 for 2005 to operate with
>> >> > full features?
>> >> > thanks.
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >>
>> >>
>> >>
>>|||The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
service name):
MSSQLSERVER
SQLSERVERAGENT
(In 2005, a service has both a long name and a short name. However, the tools you use will present
the long name.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
> Hi here is what I have listed in the services section from the control panel,
> SQL Server (SQLEXPRESS)-probably should remove this
> SQL Server Active Directory Helper
> SQL Server Analysis Services (MSSQLSERVER)
> SQL Server Browser
> SQL Server Integration Services
> SQL Server Reporting Services (MSSQLSERVER)
> SQL Server VSS Writer
> MSSQLSERVER
> SQLSERVERAGENT
> I did not see a SQL Server by itself. Guess it does not specify the year
> just from the service listing. Does this look like only the client may be
> installed? Also I installed it off of the Visual Studio 2005 professional
> addition, disk labeled SQL Server 2005 Developer edition. Thanks.
> --
> Paul G
> Software engineer.
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> > Thanks for the information, I looked at the programs installed it lists
>> > Microsoft SQL 2005 so think I have it installed.
>> That could still only be the client tools.
>> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> Server", or both?
>> A
>>|||> Do you know if I can install the
> 2005 SQL Server agent without effecting the 2000 server agent as I have
> several jobs scheduled?
Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>Also looks like I do not have the database engine
> installed 2005 as you noted. Does this come with the SQL Server 2005
> Developer edition (guessing it does) and can it be installed along with the
> 2000 database engine without effecting the 2000 instance?
Yep. As per above, just install a new database engine instance.
>If so not sure why
> it was not installed, guess I may have not selected the proper installation
> option.
That would be my guess as well.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
> Hi thanks for the additional information. Do you know if I can install the
> 2005 SQL Server agent without effecting the 2000 server agent as I have
> several jobs scheduled? Also looks like I do not have the database engine
> installed 2005 as you noted. Does this come with the SQL Server 2005
> Developer edition (guessing it does) and can it be installed along with the
> 2000 database engine without effecting the 2000 instance? If so not sure why
> it was not installed, guess I may have not selected the proper installation
> option.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> service name):
>> MSSQLSERVER
>> SQLSERVERAGENT
>> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> present
>> the long name.)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> > Hi here is what I have listed in the services section from the control panel,
>> > SQL Server (SQLEXPRESS)-probably should remove this
>> > SQL Server Active Directory Helper
>> > SQL Server Analysis Services (MSSQLSERVER)
>> > SQL Server Browser
>> > SQL Server Integration Services
>> > SQL Server Reporting Services (MSSQLSERVER)
>> > SQL Server VSS Writer
>> > MSSQLSERVER
>> > SQLSERVERAGENT
>> > I did not see a SQL Server by itself. Guess it does not specify the year
>> > just from the service listing. Does this look like only the client may be
>> > installed? Also I installed it off of the Visual Studio 2005 professional
>> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >
>> >> > Thanks for the information, I looked at the programs installed it lists
>> >> > Microsoft SQL 2005 so think I have it installed.
>> >>
>> >> That could still only be the client tools.
>> >>
>> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> Server", or both?
>> >>
>> >> A
>> >>
>> >>
>> >>
>>|||> Anyhow I was expecting to see SQL Server components but did not, do you know
> if the SQL Server Database Services should install the database engine?
Yes, this is the database engine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:3ED5DEB6-8FDA-4E00-B814-EFEB0D4BBFDC@.microsoft.com...
> Hi I installed the SQL Svr Developer Edtn 2005 disk and have the following
> selections for installation/repair
> SQL Server Database Services
> Analysis Services
> Reporting Services
> Notification Services
> Integration Services
> Workstation Components, Books online and Development tools.
> Anyhow I was expecting to see SQL Server components but did not, do you know
> if the SQL Server Database Services should install the database engine?
> thanks.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled?
>> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>>
>> >Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance?
>> Yep. As per above, just install a new database engine instance.
>>
>> >If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> That would be my guess as well.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
>> > Hi thanks for the additional information. Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled? Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance? If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> >> service name):
>> >>
>> >> MSSQLSERVER
>> >> SQLSERVERAGENT
>> >>
>> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> >> present
>> >> the long name.)
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> >> > Hi here is what I have listed in the services section from the control panel,
>> >> > SQL Server (SQLEXPRESS)-probably should remove this
>> >> > SQL Server Active Directory Helper
>> >> > SQL Server Analysis Services (MSSQLSERVER)
>> >> > SQL Server Browser
>> >> > SQL Server Integration Services
>> >> > SQL Server Reporting Services (MSSQLSERVER)
>> >> > SQL Server VSS Writer
>> >> > MSSQLSERVER
>> >> > SQLSERVERAGENT
>> >> > I did not see a SQL Server by itself. Guess it does not specify the year
>> >> > just from the service listing. Does this look like only the client may be
>> >> > installed? Also I installed it off of the Visual Studio 2005 professional
>> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >> >
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >> >
>> >> >
>> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >> >
>> >> >> > Thanks for the information, I looked at the programs installed it lists
>> >> >> > Microsoft SQL 2005 so think I have it installed.
>> >> >>
>> >> >> That could still only be the client tools.
>> >> >>
>> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> >> Server", or both?
>> >> >>
>> >> >> A
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi, looks like for some reason the upgrade was blocked as I found the message
below during an installation attempt of the database engine. Also since this
is an upgrade wondering if it will remove sql 2000 or allow both to reside
and run on the same machine?
Name: Microsoft SQL Server 2000
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
--
Paul G
Software engineer.
"Tibor Karaszi" wrote:
> > Do you know if I can install the
> > 2005 SQL Server agent without effecting the 2000 server agent as I have
> > several jobs scheduled?
> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>
> >Also looks like I do not have the database engine
> > installed 2005 as you noted. Does this come with the SQL Server 2005
> > Developer edition (guessing it does) and can it be installed along with the
> > 2000 database engine without effecting the 2000 instance?
> Yep. As per above, just install a new database engine instance.
>
> >If so not sure why
> > it was not installed, guess I may have not selected the proper installation
> > option.
> That would be my guess as well.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
> > Hi thanks for the additional information. Do you know if I can install the
> > 2005 SQL Server agent without effecting the 2000 server agent as I have
> > several jobs scheduled? Also looks like I do not have the database engine
> > installed 2005 as you noted. Does this come with the SQL Server 2005
> > Developer edition (guessing it does) and can it be installed along with the
> > 2000 database engine without effecting the 2000 instance? If so not sure why
> > it was not installed, guess I may have not selected the proper installation
> > option.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
> >> service name):
> >>
> >> MSSQLSERVER
> >> SQLSERVERAGENT
> >>
> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
> >> present
> >> the long name.)
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
> >> > Hi here is what I have listed in the services section from the control panel,
> >> > SQL Server (SQLEXPRESS)-probably should remove this
> >> > SQL Server Active Directory Helper
> >> > SQL Server Analysis Services (MSSQLSERVER)
> >> > SQL Server Browser
> >> > SQL Server Integration Services
> >> > SQL Server Reporting Services (MSSQLSERVER)
> >> > SQL Server VSS Writer
> >> > MSSQLSERVER
> >> > SQLSERVERAGENT
> >> > I did not see a SQL Server by itself. Guess it does not specify the year
> >> > just from the service listing. Does this look like only the client may be
> >> > installed? Also I installed it off of the Visual Studio 2005 professional
> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
> >> >
> >> > --
> >> > Paul G
> >> > Software engineer.
> >> >
> >> >
> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >> >
> >> >> > Thanks for the information, I looked at the programs installed it lists
> >> >> > Microsoft SQL 2005 so think I have it installed.
> >> >>
> >> >> That could still only be the client tools.
> >> >>
> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
> >> >> Server", or both?
> >> >>
> >> >> A
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> Hi, looks like for some reason the upgrade was blocked as I found the
> message
> below during an installation attempt of the database engine. Also since
> this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
An upgrade will replace SQL Server 2000. Of you want to keep both, then
DON'T RUN AN UPGRADE.
A|||thanks for the information. We have several SQL 2000 licenses not being used
so guess I could install virtual pc on the machine and then install SQL2000
followed by SQL2005.
--
Paul G
Software engineer.
"Aaron Bertrand [SQL Server MVP]" wrote:
> > Hi, looks like for some reason the upgrade was blocked as I found the
> > message
> > below during an installation attempt of the database engine. Also since
> > this
> > is an upgrade wondering if it will remove sql 2000 or allow both to reside
> > and run on the same machine?
> An upgrade will replace SQL Server 2000. Of you want to keep both, then
> DON'T RUN AN UPGRADE.
> A
>
>|||> Also since this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
If you specify the same instance as your 2000 instance, it will upgrade. If you specify a new
instance name, it will leave the 2000 instance alone.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:5BAC66BC-D95B-4B8F-985F-94F18D19A115@.microsoft.com...
> Hi, looks like for some reason the upgrade was blocked as I found the message
> below during an installation attempt of the database engine. Also since this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
> Name: Microsoft SQL Server 2000
> Reason: Your upgrade is blocked. For more information about upgrade support,
> see the "Version and Edition Upgrades" and "Hardware and Software
> Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> Online.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled?
>> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>>
>> >Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance?
>> Yep. As per above, just install a new database engine instance.
>>
>> >If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> That would be my guess as well.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
>> > Hi thanks for the additional information. Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled? Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance? If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> >> service name):
>> >>
>> >> MSSQLSERVER
>> >> SQLSERVERAGENT
>> >>
>> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> >> present
>> >> the long name.)
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> >> > Hi here is what I have listed in the services section from the control panel,
>> >> > SQL Server (SQLEXPRESS)-probably should remove this
>> >> > SQL Server Active Directory Helper
>> >> > SQL Server Analysis Services (MSSQLSERVER)
>> >> > SQL Server Browser
>> >> > SQL Server Integration Services
>> >> > SQL Server Reporting Services (MSSQLSERVER)
>> >> > SQL Server VSS Writer
>> >> > MSSQLSERVER
>> >> > SQLSERVERAGENT
>> >> > I did not see a SQL Server by itself. Guess it does not specify the year
>> >> > just from the service listing. Does this look like only the client may be
>> >> > installed? Also I installed it off of the Visual Studio 2005 professional
>> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >> >
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >> >
>> >> >
>> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >> >
>> >> >> > Thanks for the information, I looked at the programs installed it lists
>> >> >> > Microsoft SQL 2005 so think I have it installed.
>> >> >>
>> >> >> That could still only be the client tools.
>> >> >>
>> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> >> Server", or both?
>> >> >>
>> >> >> A
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>