Get Next Number: frustrating

Showing posts with label frustrating. Show all posts

Friday, March 23, 2012

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
MichaelWhat are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
--
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/|||Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
--
http://milambda.blogspot.com/|||Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
--
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
--
Michel Lévy
Communauté Francophone des Professionnels FoxPro
Pour un développement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a écrit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/

Frustrating: Can't get to Provider Options in SQL 2005 Express?

What are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/|||Hi,
I'm trying to get to the provider options screen in SQL2K5 Management
Studio, however I am unable to find it anywhere. This is really
frustrating... Here is what I am trying to do:
1.. In SQL Mgmt Studio, connect to the SQL Server Database Engine and go
to Server Objects->Linked Server->Providers in the Object Explorer.
2.. Right-click on a provider and select Properties.
However, all I can see when I right-click is "Refresh" ... How can I access
the provider options? Is this a limitation of the Express database? Is there
a stored proc I can use?
Thanks,
Michael|||What are you trying to achieve?
Look at the sp_addlinkedserver system procedure.
"Thou shall lear to type. Clicking is the work of the Devil."
-- undisclosed apostle
;)
ML
http://milambda.blogspot.com/|||Thanks, but I have already used sp_addlinkedserver.
I am trying to set the "allow inprocess" provider options... according to
research in the NG's and BOL (see "Linked Server Properties (Provider
Options Page)"), this is set from a dialog that I am unable to access. I
can't see it when adding a new linked server, editing an existing one, or
right-clicking on the provider in Management Studio.
Any ideas?
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:99625079-C5D6-430C-89AB-8AD8421A2731@.microsoft.com...
> What are you trying to achieve?
> Look at the sp_addlinkedserver system procedure.
> "Thou shall lear to type. Clicking is the work of the Devil."
> -- undisclosed apostle
> ;)
>
> ML
> --
> http://milambda.blogspot.com/

Frustrating: Can't get to Provider Options in SQL 2005 Express

Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
http://milambda.blogspot.com/Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
Michel Lvy
Communaut Francophone des Professionnels FoxPro
Pour un dveloppement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a crit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/

Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

(I have retyped it from a printout, so it may not be 100%. DOCID is supposed to increment from 1. DREF1 is a system-unique id, that takes up from where the last batch left off, and is a string prefixed by "MP")

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent
Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'
' Add your code here
'
Dim dref as String
ndx = ndx + 1
Row.DOCID = ndx
dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)
Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent
Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'
' Add your code here
'
Dim dref as String
ndx = ndx + 1
Row.DOCID = ndx
dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)
Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

sql

Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent
Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'
' Add your code here
'
Dim dref as String
ndx = ndx + 1
Row.DOCID = ndx
dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)
Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

Frustrating SubQuery Won't Total

Can someone help me determine why my subquery below is not totaling. Without
having to dig to deeply into the logic and data, I am hoping that seeing the
working/non working versions together might reveal something obvious. I have
removed the other selected columns from the main query.
I have tried using distinct and grouping in the subquery and using grouping
in the outer query to no avail.
Version 1 'unexpected' result with syntax is as it would be normally in the
query
TaxablePremium
--
1000.00
2000.00
Version 2 expected result with the FKs that would be passed from the outer
query assigned
TaxablePremium
--
3000.00
SELECT distinct
/* SubQuery version 1 - syntax is as it would be normally in the query*/
(SELECT SUM(QuotePremium.Premium)
FROM QuotePremium
INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
QuoteTaxPremium.QuotePremiumID
WHERE (QuoteLine.InvoiceID = ILI1.InvoiceId)
AND (QuoteTaxPremium.TaxLineID in(InvoiceLineItemTax.taxlobId))
) as TaxablePremium
/* SubQuery version 2- FKs that would be passed from the outer query are
assigned */
(SELECT SUM(QuotePremium.Premium)
FROM QuotePremium
INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
QuoteTaxPremium.QuotePremiumID
WHERE (QuoteLine.InvoiceID = 5947) AND (QuoteTaxPremium.TaxLineID IN
(4298, 4353)))
AS TaxablePremium
FROM InvoiceLineItem ILI1
INNER JOIN InvoiceLineItemTax ON ILI1.ID =
InvoiceLineItemTax.InvoiceLineItemID
INNER JOIN TaxLOB ON InvoiceLineItemTax.TaxLOBID = TaxLOB.ID
INNER JOIN Tax ON TaxLOB.TaxID = Tax.ID
INNER JOIN Invoice ON ILI1.InvoiceID = Invoice.ID
INNER JOIN Office Office1 ON Invoice.InsuredID = Office1.ID
INNER JOIN InvoiceType ON Invoice.InvoiceTypeID = InvoiceType.ID
INNER JOIN Office Office2 ON Tax.RegulatoryAuthorityID = Office2.ID
WHERE (InvoiceLineItemTax.FilingPartyType = 'A')
AND (Invoice.IsFutureTransaction = 0) AND (Invoice.APTaxBalance <> 0)
AND (ILI1.IsContraDistribution = 0) AND (ILI1.LineItemAccountingType = 2)
AND (ILI1.Balance <> 0) AND (NOT (Invoice.AMSPostDate IS NULL))
AND (Office2.ID = @.ReglAuthId) AND (Tax.ID = @.TaxId)
AND (Invoice.InvoiceNumber =@.InvNbr1)Mike
If you show us a table structute with sample data we'd probably suggest
something.
In the first query you JOIN InvoiceID to ILI1.InvoiceId and here is I think
a problem. Try to look at your tables more carefully to see what is going
on when you're trying to JOIN them and to assign values.
"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:OZtxqQY7FHA.3752@.tk2msftngp13.phx.gbl...
> Can someone help me determine why my subquery below is not totaling.
> Without having to dig to deeply into the logic and data, I am hoping that
> seeing the working/non working versions together might reveal something
> obvious. I have removed the other selected columns from the main query.
> I have tried using distinct and grouping in the subquery and using
> grouping in the outer query to no avail.
> Version 1 'unexpected' result with syntax is as it would be normally in
> the query
> TaxablePremium
> --
> 1000.00
> 2000.00
> Version 2 expected result with the FKs that would be passed from the outer
> query assigned
> TaxablePremium
> --
> 3000.00
>
> SELECT distinct
> /* SubQuery version 1 - syntax is as it would be normally in the query*/
> (SELECT SUM(QuotePremium.Premium)
> FROM QuotePremium
> INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
> INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
> QuoteTaxPremium.QuotePremiumID
> WHERE (QuoteLine.InvoiceID = ILI1.InvoiceId)
> AND (QuoteTaxPremium.TaxLineID in(InvoiceLineItemTax.taxlobId))
> ) as TaxablePremium
> /* SubQuery version 2- FKs that would be passed from the outer query are
> assigned */
> (SELECT SUM(QuotePremium.Premium)
> FROM QuotePremium
> INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
> INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
> QuoteTaxPremium.QuotePremiumID
> WHERE (QuoteLine.InvoiceID = 5947) AND (QuoteTaxPremium.TaxLineID IN
> (4298, 4353)))
> AS TaxablePremium
> FROM InvoiceLineItem ILI1
> INNER JOIN InvoiceLineItemTax ON ILI1.ID =
> InvoiceLineItemTax.InvoiceLineItemID
> INNER JOIN TaxLOB ON InvoiceLineItemTax.TaxLOBID = TaxLOB.ID
> INNER JOIN Tax ON TaxLOB.TaxID = Tax.ID
> INNER JOIN Invoice ON ILI1.InvoiceID = Invoice.ID
> INNER JOIN Office Office1 ON Invoice.InsuredID = Office1.ID
> INNER JOIN InvoiceType ON Invoice.InvoiceTypeID = InvoiceType.ID
> INNER JOIN Office Office2 ON Tax.RegulatoryAuthorityID = Office2.ID
> WHERE (InvoiceLineItemTax.FilingPartyType = 'A')
> AND (Invoice.IsFutureTransaction = 0) AND (Invoice.APTaxBalance <> 0)
> AND (ILI1.IsContraDistribution = 0) AND (ILI1.LineItemAccountingType = 2)
> AND (ILI1.Balance <> 0) AND (NOT (Invoice.AMSPostDate IS NULL))
> AND (Office2.ID = @.ReglAuthId) AND (Tax.ID = @.TaxId)
> AND (Invoice.InvoiceNumber =@.InvNbr1)
>|||"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:OZtxqQY7FHA.3752@.tk2msftngp13.phx.gbl...
> Can someone help me determine why my subquery below is not
totaling. Without
> having to dig to deeply into the logic and data, I am hoping that
seeing the
> working/non working versions together might reveal something
obvious. I have
> removed the other selected columns from the main query.
> I have tried using distinct and grouping in the subquery and using
grouping
> in the outer query to no avail.
> Version 1 'unexpected' result with syntax is as it would be
normally in the
> query
> TaxablePremium
> --
> 1000.00
> 2000.00
> Version 2 expected result with the FKs that would be passed from
the outer
> query assigned
> TaxablePremium
> --
> 3000.00
>
> SELECT distinct
> /* SubQuery version 1 - syntax is as it would be normally in the
query*/
> (SELECT SUM(QuotePremium.Premium)
> FROM QuotePremium
> INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
> INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
> QuoteTaxPremium.QuotePremiumID
> WHERE (QuoteLine.InvoiceID = ILI1.InvoiceId)
> AND (QuoteTaxPremium.TaxLineID
in(InvoiceLineItemTax.taxlobId))
> ) as TaxablePremium
> /* SubQuery version 2- FKs that would be passed from the outer
query are
> assigned */
> (SELECT SUM(QuotePremium.Premium)
> FROM QuotePremium
> INNER JOIN QuoteLine ON QuotePremium.QuoteLineID = QuoteLine.ID
> INNER JOIN QuoteTaxPremium ON QuotePremium.ID =
> QuoteTaxPremium.QuotePremiumID
> WHERE (QuoteLine.InvoiceID = 5947) AND
(QuoteTaxPremium.TaxLineID IN
> (4298, 4353)))
> AS TaxablePremium
> FROM InvoiceLineItem ILI1
> INNER JOIN InvoiceLineItemTax ON ILI1.ID =
> InvoiceLineItemTax.InvoiceLineItemID
> INNER JOIN TaxLOB ON InvoiceLineItemTax.TaxLOBID = TaxLOB.ID
> INNER JOIN Tax ON TaxLOB.TaxID = Tax.ID
> INNER JOIN Invoice ON ILI1.InvoiceID = Invoice.ID
> INNER JOIN Office Office1 ON Invoice.InsuredID = Office1.ID
> INNER JOIN InvoiceType ON Invoice.InvoiceTypeID = InvoiceType.ID
> INNER JOIN Office Office2 ON Tax.RegulatoryAuthorityID =
Office2.ID
> WHERE (InvoiceLineItemTax.FilingPartyType = 'A')
> AND (Invoice.IsFutureTransaction = 0) AND (Invoice.APTaxBalance <>
0)
> AND (ILI1.IsContraDistribution = 0) AND
(ILI1.LineItemAccountingType = 2)
> AND (ILI1.Balance <> 0) AND (NOT (Invoice.AMSPostDate IS NULL))
> AND (Office2.ID = @.ReglAuthId) AND (Tax.ID = @.TaxId)
> AND (Invoice.InvoiceNumber =@.InvNbr1)
>
Mike Harbinger,
Without a fully reproducible script to test with
(http://www.aspfaq.com/etiquette.asp?id=5006), it is difficult to
say for sure.
However, I do spot something interesting.
Query 1:

>AND (QuoteTaxPremium.TaxLineID in(InvoiceLineItemTax.taxlobId))
This seems a bit unusual at first glance. Why specify IN (the
shortcut for <this> OR <that> OR <the other> ) when there is but one
column named? I would have thought it should just be:
AND (QuoteTaxPremium.TaxLineID = InvoiceLineItemTax.taxlobId)
And then I see:
Query 2:

> WHERE (QuoteLine.InvoiceID = 5947)
> AND (QuoteTaxPremium.TaxLineID IN (4298, 4353)))
> AS TaxablePremium
This is supposed to be the equivalent of Query 1, only with literals
assigned. Except that two literals are assigned in the IN() list.
In Query 1, only 1 value will be present.
This makes Query 1 slightly different from what is implied in the
construction of the IN() in Query 2.
Is it enough of a difference to be causing the problem in question?
My apologies, but I can't say for sure.
Sincererely,
Chris O.|||Uri
Thank you for your prompt reply.
Below is the data from my earlier sample post.
I have omitted only those columns that are not
material to this portion of the result set.
What we have is an invoice that contains an
insurance premium amount and a tax amount. I am
trying to show a specific premium which is subject
to a specific tax.
That would be indicated by an invoice that has
a tax amount (ILI1) and a premium (QuotePremium)
joined on TaxLOB and Tax.
Path to tax via premium amount:
Invoice\QuoteLine\QuotePremium\QuoteTaxP
remium\TaxLOB\Tax
Path to tax via tax amount:
Invoice\InvoiceLineItem (as ILI1)\InvicelineItemTax\TaxLOB\Tax
Table- QuoteLine
ID InvoiceID
20370 5947
20369 5947
Table- QuotePremium
ID QuoteLineID Premium
19865 20370 1000
19864 20369 2000
Table- QuoteTaxPremium
ID QuotePremiumID TaxLineID
181069 19865 4298
181070 19864 4353
InvoiceLineItemTax.InvoiceLineItemID
50405
50405
InvoiceLineItemTax.TaxLOBID
4298
4353
Table- TaxLOB
ID TaxID
4298 54
4353 54
Tax.ID
54
54
Invoice.ID
5947
5947
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23QmpQJZ7FHA.3200@.TK2MSFTNGP11.phx.gbl...
> Mike
> If you show us a table structute with sample data we'd probably suggest
> something.
>
> In the first query you JOIN InvoiceID to ILI1.InvoiceId and here is I
> think a problem. Try to look at your tables more carefully to see what is
> going on when you're trying to JOIN them and to assign values.
>
> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
> news:OZtxqQY7FHA.3752@.tk2msftngp13.phx.gbl...
>|||Chris
Actually the IN was recently added in debugging and didn't affect anything.
It originally was '='
There are 2 records in the test data because there are 2 when the query is
run resulting in the
2 premium amounts (1,000 and 2,000). What I don't understand is why the SUM
is not totalling
no matter how many records there are. Perhaps I don't fully understand how
the function works.
My apologies for not following protocol and thank you for passing along that
link. I was reluctant to bother you with the entire script and was hoping I
had missed something fairly obvious. In order for me to replicate the data
set I would have to dump many tables and force you to to deal with FK
constraints. I was not aware you would be willing to deal with all that. I
am reviewing the link to see if I can properly ge the data togehter.
Many thanks for your time on this!!
Mike
"Chris2" <rainofsteel.NOTVALID@.GETRIDOF.luminousrain.com> wrote in message
news:372dnfkES4z6ih3enZ2dnUVZ_s6dnZ2d@.co
mcast.com...
> "Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
> news:OZtxqQY7FHA.3752@.tk2msftngp13.phx.gbl...
> totaling. Without
> seeing the
> obvious. I have
> grouping
> normally in the
> the outer
> query*/
> in(InvoiceLineItemTax.taxlobId))
> query are
> (QuoteTaxPremium.TaxLineID IN
> Office2.ID
> 0)
> (ILI1.LineItemAccountingType = 2)
> Mike Harbinger,
> Without a fully reproducible script to test with
> (http://www.aspfaq.com/etiquette.asp?id=5006), it is difficult to
> say for sure.
> However, I do spot something interesting.
> Query 1:
>
> This seems a bit unusual at first glance. Why specify IN (the
> shortcut for <this> OR <that> OR <the other> ) when there is but one
> column named? I would have thought it should just be:
> AND (QuoteTaxPremium.TaxLineID = InvoiceLineItemTax.taxlobId)
>
> And then I see:
> Query 2:
>
> This is supposed to be the equivalent of Query 1, only with literals
> assigned. Except that two literals are assigned in the IN() list.
> In Query 1, only 1 value will be present.
> This makes Query 1 slightly different from what is implied in the
> construction of the IN() in Query 2.
> Is it enough of a difference to be causing the problem in question?
> My apologies, but I can't say for sure.
>
> Sincererely,
> Chris O.
>|||"Mike Harbinger" <MikeH@.Cybervillage.net> wrote in message
news:%23edXata7FHA.2012@.TK2MSFTNGP14.phx.gbl...
>
> "Chris2" <rainofsteel.NOTVALID@.GETRIDOF.luminousrain.com> wrote in
message
> news:372dnfkES4z6ih3enZ2dnUVZ_s6dnZ2d@.co
mcast.com...
<snip>
> Chris
> Actually the IN was recently added in debugging and didn't affect
anything.
> It originally was '='
> There are 2 records in the test data because there are 2 when the
query is
> run resulting in the
> 2 premium amounts (1,000 and 2,000). What I don't understand is
why the SUM
> is not totalling
> no matter how many records there are. Perhaps I don't fully
understand how
> the function works.
> My apologies for not following protocol and thank you for passing
along that
> link. I was reluctant to bother you with the entire script and was
hoping I
> had missed something fairly obvious. In order for me to replicate
the data
> set I would have to dump many tables and force you to to deal with
FK
> constraints. I was not aware you would be willing to deal with all
that. I
> am reviewing the link to see if I can properly ge the data
togehter.
> Many thanks for your time on this!!
> Mike
Mike,
Please don't hestitate to force me to deal with the necessities of
your database! :)
As for dumping several tables, we only need a few key rows pere
table, with the data embedded in INSERT statements.
With a script along the lines of . . .
CREATE TABLE . . .
CREATE TABLE . . .
INSERT . . .
INSERT . . .
EXPECTED RESULTS . . .
QUERY/STORED PROC/ETC. . . .
ACTUAL RESULTS . . .
DROP TABLE . . .
DROP TABLE . . .
Anyone here can copy and paste a script like the above into QA or
Express Manager (or even OSQL!), and away we go with trying to fix
your problem instead of trying to figure out the answers for any of
a number of intermediary questions that are necessary to reaching a
solution.
Sincerely,
Chris O.

Frustrating Reporting Services problem. New machine fails to deploy reports to report serv

Hi All,
I got a new machine. On my old machine, I had no problem using VS
.Net to deploy Report Projects to our Report Server.
On my new machine, I installed IIS, installed VS .Net, enabled
ASP.Net, performed a Report Designer installation of Reporting
Services.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.
I found the following USENET thread that describes my problem, but I'm
not sure the solution there is the same for me:
http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
All help appreciated.
Thanks a lot,
ChuckCan you navigate to the report manager?
http://MyRServerName/Reports
That is a good troubleshooting step.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> Hi All,
> I got a new machine. On my old machine, I had no problem using VS
> .Net to deploy Report Projects to our Report Server.
> On my new machine, I installed IIS, installed VS .Net, enabled
> ASP.Net, performed a Report Designer installation of Reporting
> Services.
> After I create my report in VS .Net and try to deploy it, I get the
> following error message:
> A connection could not be made to the report server
> http://MyRServerName/ReportServer
> I am a local admin of the machine that the report server is on and I
> have no problem navigating to http://MyRServerName/ReportServer using
> Internet Explorer.
> I found the following USENET thread that describes my problem, but I'm
> not sure the solution there is the same for me:
> http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> All help appreciated.
> Thanks a lot,
> Chuck|||Try running this from command prompt -
rsconfig -c -s127.0.0.1 -dreportserver -aSql -usa -p(your sa password)
"Jeff A. Stucker" wrote:
> Can you navigate to the report manager?
> http://MyRServerName/Reports
> That is a good troubleshooting step.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Chuck Boyce" <info@.chuckboycetechnology.com> wrote in message
> news:47f5db87.0411301304.7db26ad0@.posting.google.com...
> > Hi All,
> >
> > I got a new machine. On my old machine, I had no problem using VS
> > .Net to deploy Report Projects to our Report Server.
> >
> > On my new machine, I installed IIS, installed VS .Net, enabled
> > ASP.Net, performed a Report Designer installation of Reporting
> > Services.
> >
> > After I create my report in VS .Net and try to deploy it, I get the
> > following error message:
> >
> > A connection could not be made to the report server
> > http://MyRServerName/ReportServer
> >
> > I am a local admin of the machine that the report server is on and I
> > have no problem navigating to http://MyRServerName/ReportServer using
> > Internet Explorer.
> >
> > I found the following USENET thread that describes my problem, but I'm
> > not sure the solution there is the same for me:
> >
> > http://groups.google.com/groups?hl=en&lr=&threadm=uqNZ0EsCEHA.3408%40tk2msftngp13.phx.gbl&rnum=14&prev=/groups%3Fq%3D%2522a%2Bconnection%2Bcould%2Bnot%2Bbe%2Bmade%2Bto%2Bthe%2Breport%2Bserver%2522%26start%3D10%26hl%3Den%26lr%3D%26selm%3DuqNZ0EsCEHA.3408%2540tk2msftngp13.phx.gbl%26rnum%3D14
> >
> > All help appreciated.
> >
> > Thanks a lot,
> >
> > Chuck
>
>|||I can navigate to http://MyRServerName/Reports using Internet
Explorer. However, the problem remains that I cannot deploy a report
using VS .Net on my new computer.
After I create my report in VS .Net and try to deploy it, I get the
following error message:
A connection could not be made to the report server
http://MyRServerName/ReportServer
I am a local admin of the machine that the report server is on and I
have no problem navigating to http://MyRServerName/ReportServer using
Internet Explorer.

Frustrating nulls with average

I have a field of values of which any can be null. I can deal with these pretty easily in all cases but the average function. I need to be able to take an average that ignores null values.
So for example if I have 5, 7, null, 5 , 7 I want the average to be 6 not 4.8.You need to count the records where {table.that_field}<>''.

Create a running total, let's say 'count_not_null':

Select field to summarize;
Type of summaries: 'count'.
Evaluate: use a formula: {table.that_field}<>''
Reset it if you need.

Then create a formula Average:

sum({table.field})/{#count_not_null}|||Thanks. I figured it would be something like that...but I just couldn't figure out the angle of attack. Works great.|||Can anyone offer a solution for the same problem except when trying to calculate median?

Frustrating Newbie Parameter Question

Is it possible to create a parameter where a NULL value returns ALL records
and entering a value returns the filtered data? I am filtering a date field
"ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end user a
choice of filtering the dataset with a paramater or leaving it blank and
returning records with all years.
There must be an easy way to do this. I am aware of placing an iif
statement in the dataset paramater
(i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
Parameters!Parameter1.Value)),
but if the parameter is empty, how will this return ALL records? I am
confused and would appreciate any help.
My query looks like this...
SELECT OrderDetail.*
FROM OrderDetail
WHERE (fkCategoryID = 4) AND (ConvYear = ?)
Thanks!Two points, unless you have to use a filter, don't (hard for me to tell if
you are using a filter or not). A filter first retrieves all the data
defined in the dataset and then filters it. So for instance with what you
have below, you should use that query as the definition for your dataset.
Also note that for a query parameter you use @.whateveryouwanttocallit if you
are going against SQL Server and ? if going against oledb or odbc datasourc.
OK, the trick here is to use like. Then for your parameters have an All that
returns a %. To test this out first try have your labels and values be a
list that you input on the report parameters screen (you can also use a
Union query to do this as well). What I like about this solution is you
don't have to use the generic query screen plus you don't lose having a
field list. Anyway, give it a try.
SELECT OrderDetail.* FROM OrderDetail WHERE (fkCategoryID =4) AND (ConvYear like ?)
Bruce L-C
"Brian" <bcovington@.hotmail.com> wrote in message
news:%23vYpB7znEHA.2024@.TK2MSFTNGP09.phx.gbl...
> Is it possible to create a parameter where a NULL value returns ALL
records
> and entering a value returns the filtered data? I am filtering a date
field
> "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end user
a
> choice of filtering the dataset with a paramater or leaving it blank and
> returning records with all years.
> There must be an easy way to do this. I am aware of placing an iif
> statement in the dataset paramater
> (i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
> Parameters!Parameter1.Value)),
> but if the parameter is empty, how will this return ALL records? I am
> confused and would appreciate any help.
> My query looks like this...
> SELECT OrderDetail.*
> FROM OrderDetail
> WHERE (fkCategoryID = 4) AND (ConvYear = ?)
> Thanks!
>
>
>
>|||This works great! Would this be a good solution if I wanted say 5 optional
parameters in a report, or is the LIKE clause too slow? I have about 20,000
records to search on, but the report isn't run very often.
Also, I have seen others discuss using dynamic SQL with iff statements to
obtain the same results. Would this possibly be a more efficient solution
than the LIKE clause?
Thanks,
Brian
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23qKTNF0nEHA.1152@.TK2MSFTNGP10.phx.gbl...
> Two points, unless you have to use a filter, don't (hard for me to tell if
> you are using a filter or not). A filter first retrieves all the data
> defined in the dataset and then filters it. So for instance with what you
> have below, you should use that query as the definition for your dataset.
> Also note that for a query parameter you use @.whateveryouwanttocallit if
> you
> are going against SQL Server and ? if going against oledb or odbc
> datasourc.
> OK, the trick here is to use like. Then for your parameters have an All
> that
> returns a %. To test this out first try have your labels and values be a
> list that you input on the report parameters screen (you can also use a
> Union query to do this as well). What I like about this solution is you
> don't have to use the generic query screen plus you don't lose having a
> field list. Anyway, give it a try.
> SELECT OrderDetail.* FROM OrderDetail WHERE (fkCategoryID => 4) AND (ConvYear like ?)
> Bruce L-C
> "Brian" <bcovington@.hotmail.com> wrote in message
> news:%23vYpB7znEHA.2024@.TK2MSFTNGP09.phx.gbl...
>> Is it possible to create a parameter where a NULL value returns ALL
> records
>> and entering a value returns the filtered data? I am filtering a date
> field
>> "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end user
> a
>> choice of filtering the dataset with a paramater or leaving it blank and
>> returning records with all years.
>> There must be an easy way to do this. I am aware of placing an iif
>> statement in the dataset paramater
>> (i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
>> Parameters!Parameter1.Value)),
>> but if the parameter is empty, how will this return ALL records? I am
>> confused and would appreciate any help.
>> My query looks like this...
>> SELECT OrderDetail.*
>> FROM OrderDetail
>> WHERE (fkCategoryID = 4) AND (ConvYear = ?)
>> Thanks!
>>
>>
>>
>|||I prefer the method I showed you because it is soooo much easier to develop,
you get the list of fields, you can use the normal query designer. Whether
it is slow or not depends on the database you are going against. If it is
SQL Server 2000 and you have 20,000 records it won't even breath hard.
20,000 is nothing. I suggest trying it this way, if performance is a problem
you can always go to dynamic sql.
Bruce L-C
"Brian" <bcovington@.hotmail.com> wrote in message
news:eb2du30nEHA.2024@.TK2MSFTNGP09.phx.gbl...
> This works great! Would this be a good solution if I wanted say 5
optional
> parameters in a report, or is the LIKE clause too slow? I have about
20,000
> records to search on, but the report isn't run very often.
> Also, I have seen others discuss using dynamic SQL with iff statements to
> obtain the same results. Would this possibly be a more efficient solution
> than the LIKE clause?
> Thanks,
> Brian
>
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23qKTNF0nEHA.1152@.TK2MSFTNGP10.phx.gbl...
> > Two points, unless you have to use a filter, don't (hard for me to tell
if
> > you are using a filter or not). A filter first retrieves all the data
> > defined in the dataset and then filters it. So for instance with what
you
> > have below, you should use that query as the definition for your
dataset.
> >
> > Also note that for a query parameter you use @.whateveryouwanttocallit if
> > you
> > are going against SQL Server and ? if going against oledb or odbc
> > datasourc.
> >
> > OK, the trick here is to use like. Then for your parameters have an All
> > that
> > returns a %. To test this out first try have your labels and values be a
> > list that you input on the report parameters screen (you can also use a
> > Union query to do this as well). What I like about this solution is you
> > don't have to use the generic query screen plus you don't lose having a
> > field list. Anyway, give it a try.
> > SELECT OrderDetail.* FROM OrderDetail WHERE (fkCategoryID
=> > 4) AND (ConvYear like ?)
> >
> > Bruce L-C
> >
> > "Brian" <bcovington@.hotmail.com> wrote in message
> > news:%23vYpB7znEHA.2024@.TK2MSFTNGP09.phx.gbl...
> >> Is it possible to create a parameter where a NULL value returns ALL
> > records
> >> and entering a value returns the filtered data? I am filtering a date
> > field
> >> "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end
user
> > a
> >> choice of filtering the dataset with a paramater or leaving it blank
and
> >> returning records with all years.
> >>
> >> There must be an easy way to do this. I am aware of placing an iif
> >> statement in the dataset paramater
> >> (i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = " +
> >> Parameters!Parameter1.Value)),
> >> but if the parameter is empty, how will this return ALL records? I am
> >> confused and would appreciate any help.
> >>
> >> My query looks like this...
> >>
> >> SELECT OrderDetail.*
> >> FROM OrderDetail
> >> WHERE (fkCategoryID = 4) AND (ConvYear = ?)
> >>
> >> Thanks!
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>|||Bruce,
Your time was very much appreciated. Thank you!
Brian
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ueS7sG1nEHA.3216@.tk2msftngp13.phx.gbl...
>I prefer the method I showed you because it is soooo much easier to
>develop,
> you get the list of fields, you can use the normal query designer. Whether
> it is slow or not depends on the database you are going against. If it is
> SQL Server 2000 and you have 20,000 records it won't even breath hard.
> 20,000 is nothing. I suggest trying it this way, if performance is a
> problem
> you can always go to dynamic sql.
> Bruce L-C
> "Brian" <bcovington@.hotmail.com> wrote in message
> news:eb2du30nEHA.2024@.TK2MSFTNGP09.phx.gbl...
>> This works great! Would this be a good solution if I wanted say 5
> optional
>> parameters in a report, or is the LIKE clause too slow? I have about
> 20,000
>> records to search on, but the report isn't run very often.
>> Also, I have seen others discuss using dynamic SQL with iff statements to
>> obtain the same results. Would this possibly be a more efficient
>> solution
>> than the LIKE clause?
>> Thanks,
>> Brian
>>
>>
>> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23qKTNF0nEHA.1152@.TK2MSFTNGP10.phx.gbl...
>> > Two points, unless you have to use a filter, don't (hard for me to tell
> if
>> > you are using a filter or not). A filter first retrieves all the data
>> > defined in the dataset and then filters it. So for instance with what
> you
>> > have below, you should use that query as the definition for your
> dataset.
>> >
>> > Also note that for a query parameter you use @.whateveryouwanttocallit
>> > if
>> > you
>> > are going against SQL Server and ? if going against oledb or odbc
>> > datasourc.
>> >
>> > OK, the trick here is to use like. Then for your parameters have an All
>> > that
>> > returns a %. To test this out first try have your labels and values be
>> > a
>> > list that you input on the report parameters screen (you can also use a
>> > Union query to do this as well). What I like about this solution is you
>> > don't have to use the generic query screen plus you don't lose having a
>> > field list. Anyway, give it a try.
>> > SELECT OrderDetail.* FROM OrderDetail WHERE
>> > (fkCategoryID
> =>> > 4) AND (ConvYear like ?)
>> >
>> > Bruce L-C
>> >
>> > "Brian" <bcovington@.hotmail.com> wrote in message
>> > news:%23vYpB7znEHA.2024@.TK2MSFTNGP09.phx.gbl...
>> >> Is it possible to create a parameter where a NULL value returns ALL
>> > records
>> >> and entering a value returns the filtered data? I am filtering a date
>> > field
>> >> "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end
> user
>> > a
>> >> choice of filtering the dataset with a paramater or leaving it blank
> and
>> >> returning records with all years.
>> >>
>> >> There must be an easy way to do this. I am aware of placing an iif
>> >> statement in the dataset paramater
>> >> (i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear = "
>> >> +
>> >> Parameters!Parameter1.Value)),
>> >> but if the parameter is empty, how will this return ALL records? I am
>> >> confused and would appreciate any help.
>> >>
>> >> My query looks like this...
>> >>
>> >> SELECT OrderDetail.*
>> >> FROM OrderDetail
>> >> WHERE (fkCategoryID = 4) AND (ConvYear = ?)
>> >>
>> >> Thanks!
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >
>> >
>>
>|||We've used a statement in the where clause like :
where (ssn.Item_Number = IsNull(@.Stock_Code, ssn.Item_Number))
which returns all items if the sp parameter is null of uses the parameter
value to filter.
Julian
"Brian" <bcovington@.hotmail.com> wrote in message
news:uJyf4T1nEHA.132@.TK2MSFTNGP09.phx.gbl...
> Bruce,
> Your time was very much appreciated. Thank you!
> Brian
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ueS7sG1nEHA.3216@.tk2msftngp13.phx.gbl...
> >I prefer the method I showed you because it is soooo much easier to
> >develop,
> > you get the list of fields, you can use the normal query designer.
Whether
> > it is slow or not depends on the database you are going against. If it
is
> > SQL Server 2000 and you have 20,000 records it won't even breath hard.
> > 20,000 is nothing. I suggest trying it this way, if performance is a
> > problem
> > you can always go to dynamic sql.
> >
> > Bruce L-C
> >
> > "Brian" <bcovington@.hotmail.com> wrote in message
> > news:eb2du30nEHA.2024@.TK2MSFTNGP09.phx.gbl...
> >> This works great! Would this be a good solution if I wanted say 5
> > optional
> >> parameters in a report, or is the LIKE clause too slow? I have about
> > 20,000
> >> records to search on, but the report isn't run very often.
> >>
> >> Also, I have seen others discuss using dynamic SQL with iff statements
to
> >> obtain the same results. Would this possibly be a more efficient
> >> solution
> >> than the LIKE clause?
> >>
> >> Thanks,
> >>
> >> Brian
> >>
> >>
> >>
> >>
> >> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> news:%23qKTNF0nEHA.1152@.TK2MSFTNGP10.phx.gbl...
> >> > Two points, unless you have to use a filter, don't (hard for me to
tell
> > if
> >> > you are using a filter or not). A filter first retrieves all the data
> >> > defined in the dataset and then filters it. So for instance with what
> > you
> >> > have below, you should use that query as the definition for your
> > dataset.
> >> >
> >> > Also note that for a query parameter you use @.whateveryouwanttocallit
> >> > if
> >> > you
> >> > are going against SQL Server and ? if going against oledb or odbc
> >> > datasourc.
> >> >
> >> > OK, the trick here is to use like. Then for your parameters have an
All
> >> > that
> >> > returns a %. To test this out first try have your labels and values
be
> >> > a
> >> > list that you input on the report parameters screen (you can also use
a
> >> > Union query to do this as well). What I like about this solution is
you
> >> > don't have to use the generic query screen plus you don't lose having
a
> >> > field list. Anyway, give it a try.
> >> > SELECT OrderDetail.* FROM OrderDetail WHERE
> >> > (fkCategoryID
> > => >> > 4) AND (ConvYear like ?)
> >> >
> >> > Bruce L-C
> >> >
> >> > "Brian" <bcovington@.hotmail.com> wrote in message
> >> > news:%23vYpB7znEHA.2024@.TK2MSFTNGP09.phx.gbl...
> >> >> Is it possible to create a parameter where a NULL value returns ALL
> >> > records
> >> >> and entering a value returns the filtered data? I am filtering a
date
> >> > field
> >> >> "ConvYear" (i.e. 2001, 2002, 2003,etc..) and I want to give the end
> > user
> >> > a
> >> >> choice of filtering the dataset with a paramater or leaving it blank
> > and
> >> >> returning records with all years.
> >> >>
> >> >> There must be an easy way to do this. I am aware of placing an iif
> >> >> statement in the dataset paramater
> >> >> (i.e. =iif(Parameters!Parameter1.Value = "",""," WHERE odConvYear ="
> >> >> +
> >> >> Parameters!Parameter1.Value)),
> >> >> but if the parameter is empty, how will this return ALL records? I
am
> >> >> confused and would appreciate any help.
> >> >>
> >> >> My query looks like this...
> >> >>
> >> >> SELECT OrderDetail.*
> >> >> FROM OrderDetail
> >> >> WHERE (fkCategoryID = 4) AND (ConvYear = ?)
> >> >>
> >> >> Thanks!
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Excellent tip! The visual designer messes up statements like:
(@.ItemNo Is Null OR ItemNumber = @.ItemNo)sql

Frustrating Installation Error

I was installing SQL Server on my machine and during installation my PC
freezed. It happens frequently on my machine as my bad luck sticks frequenctly to my side. So i tried after
restarting to install it again and since then i always get the same
error message:
"An error occurred while creating one or more registry entries. Please
see C:\WINDOWS\sqlstp.log for details. The problem could be caused by a
low registry quota condition"
I have tried to clean the registry during the installation bt chosing "advanced options" -> "Rebuild registry" and i don't know what else i could
do to solve this issue. I'd like to remark that i also deleted the SQL Server keys from Registry as suggested from Microsoft to delete default and special named instances.

I also deleted every thing under %TEMP%; I even installed third pary registry tools to clean the registry such as RegistryFix, Registry Mechanic and AMUST.

Finally, i'm using Windows XP Professional SP2.

Any help?

The log file lists the following:

14:22:27 Begin Setup
14:22:27 8.00.194
14:22:27 Mode = Normal
14:22:27 ModeType = NORMAL
14:22:27 GetDefinitionEx returned: 0, Extended: 0x0
14:22:27 ValueFTS returned: 1
14:22:27 ValuePID returned: 1
14:22:27 ValueLic returned: 0
14:22:27 System: Windows NT WorkStation
14:22:27 SQL Server ProductType: Developer Edition [0x3]
14:22:27 Begin Action: SetupInitialize
14:22:27 End Action SetupInitialize
14:22:27 Begin Action: SetupInstall
14:22:27 Reading
Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
14:22:27 CommonFilesDir=C:\Programme\Gemeinsame Dateien
14:22:27 Windows Directory=C:\WINDOWS\
14:22:27 Program Files=C:\Programme\
14:22:27 TEMPDIR=C:\WINDOWS\TEMP\
14:22:27 Begin Action: SetupInstall
14:22:27 digpid size : 256
14:22:27 digpid size : 164
14:22:27 Begin Action: CheckFixedRequirements
14:22:27 Platform ID: 0xf000000
14:22:27 Version: 5.1.2600
14:22:27 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.2900.2805
14:22:27 End Action: CheckFixedRequirements
14:22:27 Begin Action: ShowDialogs
14:22:27 Initial Dialog Mask: 0x83000f7, Disable Back=0x1
14:22:27 Begin Action ShowDialogsHlpr: 0x1
14:22:27 Begin Action: DialogShowSdWelcome
14:22:28 End Action DialogShowSdWelcome
14:22:28 Dialog 0x1 returned: 1
14:22:28 End Action ShowDialogsHlpr
14:22:28 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
14:22:28 Begin Action ShowDialogsHlpr: 0x2
14:22:28 Begin Action: DialogShowSdMachineName
14:22:30 ShowDlgMachine returned: 1
14:22:30 Name = COOSA, Type = 0x1
14:22:30 Begin Action: CheckRequirements
14:22:30 Processor Architecture: x86 (Pentium)
14:22:30 Service Pack: 512
14:22:30 ComputerName: COOSA
14:22:30 User Name: admin
14:22:30 IsAllAccessAllowed returned: 1
14:22:30 OS Language: 0x401
14:22:30 End Action CheckRequirements
14:22:30 This combination of Package and Operating System allows a full
product install.
14:22:30 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:30 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:30 Topology Type : 1, Return Value : 0
14:22:30 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:30 PN_EnumerateEx returned : 0
14:22:30 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:30 PN_StartScan [0x1b040c0] returned : 0
14:22:30 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:30 No more items in enumeration.
14:22:30 ReleaseSetupTopology
14:22:30 Named instance limit: 100, quota: 0
14:22:30 End Action DialogShowSdMachineName
14:22:30 begin ShowDialogsUpdateMask
14:22:30 nFullMask = 0x83000f7, nCurrent = 0x2, nDirection = 0
14:22:30 Updated Dialog Mask: 0xbf00037, Disable Back = 0x1
14:22:30 Dialog 0x2 returned: 0
14:22:30 End Action ShowDialogsHlpr
14:22:30 ShowDialogsGetDialog returned: nCurrent=0x4,index=2
14:22:30 Begin Action ShowDialogsHlpr: 0x4
14:22:30 Begin Action: DialogShowSdInstallMode
14:22:36 ShowDlgInstallMode returned: 1
14:22:36 InstallMode : 0x1
14:22:36 End Action DialogShowSdInstallMode
14:22:36 begin ShowDialogsUpdateMask
14:22:36 nFullMask = 0xbf00037, nCurrent = 0x4, nDirection = 1
14:22:36 Updated Dialog Mask: 0xbf40037, Disable Back = 0x1
14:22:36 Dialog 0x4 returned: 1
14:22:36 End Action ShowDialogsHlpr
14:22:36 ShowDialogsGetDialog returned: nCurrent=0x10,index=4
14:22:36 Begin Action ShowDialogsHlpr: 0x10
14:22:36 Begin Action: DialogShowSdRegisterUserEx
14:22:42 End Action DialogShowSdRegisterUserEx
14:22:42 Dialog 0x10 returned: 1
14:22:42 End Action ShowDialogsHlpr
14:22:42 ShowDialogsGetDialog returned: nCurrent=0x20,index=5
14:22:42 Begin Action ShowDialogsHlpr: 0x20
14:22:42 Begin Action: DialogShowSdLicense
14:22:43 End Action DialogShowSdLicense
14:22:43 Dialog 0x20 returned: 1
14:22:43 End Action ShowDialogsHlpr
14:22:43 ShowDialogsGetDialog returned: nCurrent=0x40000,index=18
14:22:43 Begin Action ShowDialogsHlpr: 0x40000
14:22:43 Begin Action: DialogShowSdCliSvr
14:22:43 DisplaySystemPreReq
14:22:45 ShowDlgClientServerSelect returned: 1
14:22:45 Type : 0x2
14:22:45 End Action DialogShowSdCliSvr
14:22:45 begin ShowDialogsUpdateMask
14:22:45 nFullMask = 0xbf40037, nCurrent = 0x40000, nDirection = 1
14:22:45 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:45 Dialog 0x40000 returned: 1
14:22:45 End Action ShowDialogsHlpr
14:22:45 ShowDialogsGetDialog returned: nCurrent=0x80000,index=19
14:22:45 Begin Action ShowDialogsHlpr: 0x80000
14:22:45 Begin Action: DialogShowSdInstanceName
14:22:45 Begin Action: ShowDlgInstanceName
14:22:47 End Action: ShowDlgInstanceName
14:22:47 ShowDlgInstanceName returned : 1
14:22:47 InstanceName : MSSQLSERVER
14:22:47 CreateSetupTopology(COOSA), Handle : 0x1b04098, returned : 0
14:22:47 CreateSetupTopology returned : 0, Handle : 0x1b04098
14:22:47 Topology Type : 1, Return Value : 0
14:22:47 ST_GetPhysicalNode returned : 0, PNHandle : 0x1b040c0
14:22:47 PN_EnumerateEx returned : 0
14:22:47 PN_GetSQLStates returned : 0, SqlStates : 0x80000000
14:22:47 PN_StartScan [0x1b040c0] returned : 0
14:22:47 PN_GetNext [0x1b040c0] returned : 18, Handle: [0x0]
14:22:47 No more items in enumeration.
14:22:47 ReleaseSetupTopology
14:22:47 End Action DialogShowSdInstanceName
14:22:47 begin ShowDialogsUpdateMask
14:22:47 nFullMask = 0xbfc0037, nCurrent = 0x80000, nDirection = 1
14:22:47 Updated Dialog Mask: 0xbfc0037, Disable Back = 0x1
14:22:47 Dialog 0x80000 returned: 1
14:22:47 End Action ShowDialogsHlpr
14:22:47 ShowDialogsGetDialog returned: nCurrent=0x100000,index=20
14:22:47 Begin Action ShowDialogsHlpr: 0x100000
14:22:47 Begin Action: DialogShowSdSetupType
14:22:47 Begin Action: Setup Type
14:23:05 SQL program folder: C:\Programme\Microsoft SQL Server
14:23:05 SQL data folder: C:\Programme\Microsoft SQL Server
14:23:05 Windows system folder: C:\WINDOWS\system32\
14:23:05 Prog req: 38073, Data req: 34432, Sys req: 158694
14:23:05 Prog avail: 1481708, Data avail: 1481708, Sys avail: 1481708
14:23:05 Prog req vs. avail, 231199, 1481708
14:23:05 Data req vs. avail, 34432, 1481708
14:23:05 Sys req vs. avail, 193126, 1481708
14:23:05 DisplaySystemPreReq
14:23:05 [SetupTypeSQL]
14:23:05 szDir = C:\Programme\Microsoft SQL Server
14:23:05 szDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 Result = 301
14:23:05 szDataDir = C:\Programme\Microsoft SQL Server
14:23:05 szDataDir = %PROGRAMFILES%\Microsoft SQL Server
14:23:05 End Action: Setup Type
14:23:05 Setup Type: Typical (301)
14:23:05 End Action DialogShowSdSetupType
14:23:05 begin ShowDialogsUpdateMask
14:23:05 nFullMask = 0xbfc0037, nCurrent = 0x100000, nDirection = 301
14:23:05 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:05 Dialog 0x100000 returned: 301
14:23:05 End Action ShowDialogsHlpr
14:23:05 ShowDialogsGetDialog returned: nCurrent=0x400000,index=22
14:23:05 Begin Action ShowDialogsHlpr: 0x400000
14:23:05 Begin Action: DlgServices
14:23:10 ShowDlgServices returned: 1
14:23:10 [DlgServices]
14:23:10 Local-Domain = 3855
14:23:10 AutoStart = 15
14:23:10 Result = 1
14:23:10 End Action DlgServices
14:23:10 begin ShowDialogsUpdateMask
14:23:10 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
14:23:10 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:10 Dialog 0x400000 returned: 1
14:23:10 End Action ShowDialogsHlpr
14:23:10 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
14:23:10 Begin Action ShowDialogsHlpr: 0x800000
14:23:10 Begin Action: DlgSQLSecurity
14:23:12 ShowDlgSQLSecurity returned: 1
14:23:12 LoginMode = 1,szPwd
14:23:12 End Action DlgSQLSecurity
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x800000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
14:23:12 Begin Action ShowDialogsHlpr: 0x1000000
14:23:12 Begin Action: DlgCollation
14:23:12 ShowDlgCollation returned: 1
14:23:12 collation_name = Arabic_CI_AS,locale_name = Arabic,lcid =
0x401,SortId = 0,dwCompFlags = 0x30001
14:23:12 End Action DlgCollation
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x1000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x1000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x2000000,index=25
14:23:12 Begin Action ShowDialogsHlpr: 0x2000000
14:23:12 Begin Action: DlgNetwork
14:23:12 ShowDlgNetwork returned: 1
14:23:12 [DlgServerNetwork]
14:23:12 NetworkLibs = 255
14:23:12 TCPPort = 1433
14:23:12 TCPPrxy = Default
14:23:12 NMPPipeName = \\.\pipe\sql\query
14:23:12 Result = 1
14:23:12 End Action DlgNetwork
14:23:12 begin ShowDialogsUpdateMask
14:23:12 nFullMask = 0xbdc0037, nCurrent = 0x2000000, nDirection = 1
14:23:12 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:12 Dialog 0x2000000 returned: 1
14:23:12 End Action ShowDialogsHlpr
14:23:12 ShowDialogsGetDialog returned: nCurrent=0x8000000,index=27
14:23:12 Begin Action ShowDialogsHlpr: 0x8000000
14:23:12 Begin Action: DialogShowSdStartCopy
14:23:13 End Action DialogShowSdStartCopy
14:23:13 begin ShowDialogsUpdateMask
14:23:13 nFullMask = 0xbdc0037, nCurrent = 0x8000000, nDirection = 1
14:23:13 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
14:23:13 Dialog 0x8000000 returned: 1
14:23:13 End Action ShowDialogsHlpr
14:23:13 ShowDialogsGetDialog returned: nCurrent=0x0,index=0
14:23:13 End Action ShowDialogs
14:23:13 Begin Action ProcessBeforeDataMove:
14:23:13 DeinstallStart returned (C:\Programme\Microsoft SQL
Server\MSSQL): 0
14:23:13 End Action ProcessBeforeDataMove:
14:23:13 Begin Action SetToolsComponentSelection:
14:23:13 End Action SetToolsComponentSelection:
14:23:13 Begin Action ProcessComponentSelection:
14:23:13 End Action ProcessComponentSelection
14:23:13 Begin Action LogSelectedComponents:
14:23:13 SQLProg
14:23:13 SQLProg\SQLServr
14:23:13 SQLProg\SQLServr\Help
14:23:13 SQLProg\SQLServr\SCMDev
14:23:13 SQLProg\SQLServr\SCMDev\SCMh
14:23:13 SQLProg\SQLServr\SCMDev\SCMX86Lb
14:23:13 SQLProg\SQLServr\SCMDev\SCMALb
14:23:13 SQLProg\SQLServr\Rs1033
14:23:13 SQLProg\SQLServr\RsIntl
14:23:13 SQLProg\SQLServr\ActiveX
14:23:13 SQLProg\SQLServr\System
14:23:13 SQLProg\UpgTools
14:23:13 SQLProg\UpgTools\UpgSys
14:23:13 SQLProg\UpgTools\ActiveX
14:23:13 SQLProg\UpgTools\Res1033
14:23:13 SQLProg\UpgTools\ResOther
14:23:13 SQLProg\UpgTools\Resld
14:23:13 SQLProg\ReplSupp
14:23:13 SQLProg\ReplSupp\ReplDat
14:23:13 SQLProg\ReplSupp\RepComm
14:23:13 SQLProg\ReplSupp\RepNoDk
14:23:13 SQLProg\ReplSupp\ActiveX
14:23:13 SQLProg\Install
14:23:13 SQLProg\System
14:23:13 SQLProg\SvrExt
14:23:13 SQLProg\SvrExt\Help
14:23:13 SQLProg\SvrExt\SvrExtRs
14:23:13 SQLProg\SvrExt\ResIntl
14:23:13 SQLProg\Dat
14:23:13 SQLProg\DatSmpl
14:23:13 SQLProg\BaseSys
14:23:13 SQLProg\BaseBinn
14:23:13 SQLProg\BaseInst
14:23:13 SQLProg\Symbols
14:23:13 SQLProg\Symbols\EXE
14:23:13 SQLProg\Symbols\DLL
14:23:13 SQLProg\Perfmon
14:23:13 SQLProg\Perfmon\System
14:23:13 SQLProg\Root
14:23:13 MgtTool
14:23:13 MgtTool\SEM
14:23:13 MgtTool\SEM\HTML
14:23:13 MgtTool\SEM\MSD98
14:23:13 MgtTool\SEM\MSD98SYS
14:23:13 MgtTool\SEM\MSD98Res
14:23:13 MgtTool\SEM\MSD98Hlp
14:23:13 MgtTool\SEM\Help
14:23:13 MgtTool\SEM\Res1033
14:23:13 MgtTool\SEM\ResIntl
14:23:13 MgtTool\SEM\MSD98RsI
14:23:13 MgtTool\SEM\ActiveX
14:23:13 MgtTool\SEM\ActiveX\Res1033
14:23:13 MgtTool\SEM\ActiveX\ResIntl
14:23:13 MgtTool\SEM\Scripts
14:23:13 MgtTool\SEM\OLEDB
14:23:13 MgtTool\SEM\OLEDB\Res1033
14:23:13 MgtTool\SEM\OLEDB\ResIntl
14:23:13 MgtTool\Profiler
14:23:13 MgtTool\Profiler\Help
14:23:13 MgtTool\Profiler\Res1033
14:23:13 MgtTool\Profiler\ResIntl
14:23:13 MgtTool\Qryanlz
14:23:13 MgtTool\Qryanlz\Help
14:23:13 MgtTool\Qryanlz\Res1033
14:23:13 MgtTool\Qryanlz\ResIntl
14:23:13 MgtTool\DTCCLi
14:23:13 MgtTool\Wzcnflct
14:23:13 MgtTool\Wzcnflct\WzcnHlp
14:23:13 MgtTool\Wzcnflct\Wzcn1033
14:23:13 MgtTool\Wzcnflct\WzcnOthr
14:23:13 MgtTool\Wzcnflct\WzcnCmn
14:23:13 MgtTool\UtilSys
14:23:13 MgtTool\UtilBinn
14:23:13 Connect
14:23:13 Connect\ConnSys
14:23:13 Books
14:23:13 Books\Bookso
14:23:13 Books\Bookso\Utils
14:23:13 DevTools
14:23:13 DevTools\Dbg Int
14:23:13 DevTools\Dbg Int\Dbg Int Common
14:23:13 DevTools\Dbg Int\EXE
14:23:13 CoreRepl
14:23:13 CoreRepl\Res1033
14:23:13 CoreRepl\ResIntl
14:23:13 Core
14:23:13 Core\Res1033
14:23:13 Core\ResOther
14:23:13 Repostry
14:23:13 Repostry\RepstSys
14:23:13 Repostry\Res1033
14:23:13 Repostry\ResIntl
14:23:13 CoreMisc
14:23:13 CoreMisc\ActiveX
14:23:13 CoreMisc\ActiveX\Res1033
14:23:13 CoreMisc\ActiveX\ResIntl
14:23:13 CoreMisc\Res1033
14:23:13 Monarch
14:23:13 Monarch\Monr1033
14:23:13 Monarch\MonrIntl
14:23:13 Jet
14:23:13 CoreInst
14:23:13 CoreCOM
14:23:13 CoreCOM\Res1033
14:23:13 CoreCOM\ResIntl
14:23:13 CoreTool
14:23:13 CoreTool\Res1033
14:23:13 CoreTool\ResOther
14:23:13 DBLibCli
14:23:13 SFExt
14:23:13 SFExt\ActiveX
14:23:13 SFExt\ActiveX\Res1033
14:23:13 SFExt\ActiveX\ResIntl
14:23:13 SFExt\Res1033
14:23:13 SFExt\ResIntl
14:23:13 Trace
14:23:13 Trace\Res1033
14:23:13 Trace\ResOther
14:23:13 MiscCore
14:23:13 MC
14:23:13 MC\MC1033
14:23:13 MC\MCIntl
14:23:13 MC\Help
14:23:13 SQLMgr
14:23:13 SQLMgr\Res1033
14:23:13 SQLMgr\ResIntl
14:23:13 SvrTool
14:23:13 SvrTool\Res1033
14:23:13 SvrTool\ResIntl
14:23:13 DTSUI
14:23:13 DTSUI\Res1033
14:23:13 DTSUI\ResIntl
14:23:13 MSOlap
14:23:13 MSOlap\Res1033
14:23:13 MSOlap\ResIntl
14:23:13 ATL
14:23:13 ATL\winnt
14:23:13 ATL\win9x
14:23:13 MFC42U
14:23:13 VC
14:23:13 VB
14:23:13 OCX1
14:23:13 SQLAdHlp
14:23:13 SQLAdHlp\Res1033
14:23:13 SQLAdHlp\ResOther
14:23:13 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:23:13 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:23:13 End Action LogSelectedComponents
14:23:13 Begin Action InstallPkgs:
14:23:13 Begin Action: Locked Connectivity Files Check
14:23:13 ConnectivityLocked returned: 0
14:23:13 Der Vorgang wurde erfolgreich beendet.

14:23:13 End Action: Locked Connectivity Files Check
14:23:13 Setup is installing Microsoft Data Access Components (MDAC)
...
14:23:13 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\sqlredis.exe /q:a
/C:"setupre.exe WARN=1 -s -SMS"
14:23:24 ExitCode: 0
14:23:24 Setup is installing Microsoft Distributed Transaction
Coordinator (MSDTC) ...
14:23:24 C:\WINDOWS\TEMP\SqlSetup\Bin\cldtcstp.exe -SupportDir
"C:\WINDOWS\TEMP\SqlSetup\Bin" -DTCPkg
"E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Other\dtcsetup.exe" -LogFile
"C:\WINDOWS\sqlstp.log"
14:23:24 Process Exit Code: (0)
14:23:24 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
14:23:24 Setup is installing HTML Help ...
14:23:24 HTML Help installer exit code: 0
14:23:45 End Action InstallPkgs
14:23:45 Begin Action MoveFileData:
14:23:45 Enabled SELFREGISTERBATCH
14:23:45 Enabled CORECOMPONENTHANDLING
14:24:11 Begin Action: MoveFileDataSpecial
14:24:11 End Action: MoveFileDataSpecial
14:24:11 End Action MoveFileData
14:24:11 Begin Action ProcessAfterDataMove:
14:24:11 E:\SOFTWA~1\DEV\DB\SQL200~1\x86\Binn\hhcol.exe
C:\Programme\Microsoft SQL Server\80\Tools\Books
14:24:11 End Action ProcessAfterDataMove
14:24:11 Begin Action BuildServer:
14:24:11 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5
-ExePath "C:\Programme\Microsoft SQL Server\MSSQL\binn\sqlservr.exe"
-Service "MSSQLSERVER"
14:24:12 Process Exit Code: (0)
14:24:12 Begin Action: CreateRegistrySetSQL
14:24:12 End Action: CreateRegistrySetSQL
14:24:12 Begin Action: RegWriteSetupEntry
14:24:12 End Action: RegWriteSetupEntry
14:24:12 Begin Action: CreateSer
14:24:12 End Action: CreateSer
14:24:12 Begin Action: SkuIt
14:24:12 End Action: SkuIt
14:24:12 SetFileSecuritySQLAndAdmin for C:\Programme\Microsoft SQL
Server\MSSQL returned: 0, 0
14:24:12 SetRegSecuritySQLAndAdmin for
Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
14:24:12 Begin Action: UpdateSystemPath
14:24:12 Path successfully updated.
14:24:12
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Programme\Java\jdk1.5.0_04\bin;C:\Borland\BCC55\bin;"C:\Programme\Symantec\Norton
Ghost 2003\";C:\Programme\Microsoft SQL
Server\80\Tools\BINN;C:\Programme\MySQL\MySQL Server 5.0\bin
14:24:12 End Action: UpdateSystemPath
14:24:13 C:\Programme\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "Arabic_CI_AS"
-H 459924 -U sa -P
###############################################################################

Starting Service ...

Arabic_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=COOSA;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'VORDEFINIERT\Administratoren'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'VORDEFINIERT\Administratoren'.

EXEC sp_addsrvrolemember N'VORDEFINIERT\Administratoren', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL
Server]'VORDEFINIERT\Administratoren' added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @.@.version where
attribute_id = 2

EXEC sp_addserver N'COOSA', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to
install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###############################################################################

14:24:42 Process Exit Code: (0)
14:24:42 End Action BuildServer
14:24:42 Begin Action SelfRegiser
14:24:42 DLLRegisterServer atl.dll: 0, 0x0
14:24:50 Return code: 0
14:24:50 Begin Action SelfRegisterOnCluster
14:24:50 End Action SelfRegisterOnCluster
14:24:50 Begin Action RegisterSvrReplFiles
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-unregserver
14:24:50 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-unregserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\snapshot.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\distrib.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\replmerg.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\logread.exe-regserver
14:24:51 **** File registered: C:\Programme\Microsoft SQL
Server\80\COM\qrdrsvc.exe-regserver
14:24:51 End Action RegisterSvrReplFiles
14:24:51 Begin Action SelfRegisterCOMShared
14:24:51 End Action SelfRegisterCOMShared
14:24:51 End Action SelfRegister
14:24:51 Begin Action SetupRegistry:
14:24:51 SNMP service has been detected.
14:24:51 Begin Action RegWriteInstalledInstances:
14:24:51 End Action RegWriteInstalledInstances
14:24:51 Register this installation of SQL Server with MDAC
14:24:51 Completed registering this installation of SQL Server with
MDAC
14:25:07 An error occurred while creating one or more registry entries.
Please see C:\WINDOWS\\\sqlstp.log for details. The problem could be
caused by a low registry quota condition.
14:25:07 Action CleanUpInstall:
14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service SQLSERVERAGENT
14:25:07 Process Exit Code: (1060) Der angegebene Dienst ist kein
installierter Dienst.

14:25:07 C:\WINDOWS\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 4
-Service MSSQLSERVER
14:25:07 Process Exit Code: (0)
14:25:07 StatsGenerate returned: 2
14:25:07 StatsGenerate
(0x80000000,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
14:25:07 StatsGenerate -1,admin)
14:25:07 Installation Failed.

I got the indentical error when I attempted to install SQL 2000 Developer's Edition on XP Pro. My log file failure occurred at the same place yours did.

I had recently installed .Net framework, .Net SDK, and ASP Web Matrix. I made a lucky guess that they were causing the problem.

I did an uninstall of:
.Net framework
.Net SDK
ASP Web Matrix

I deleted the sub folders in c:\Program Files\Microsoft SQL Server.

Then SQL 2000 DE installed successfully, and I reinstalled the .Net framework & ASP Web Matrix.

Hope this helps.

Frustrating Installation Error

I also deleted every thing under %TEMP%; I even installed third pary registry tools to clean the registry such as RegistryFix, Registry Mechanic and AMUST.

Finally, i'm using Windows XP Professional SP2.

Any help?

The log file lists the following:

Starting Service ...

Arabic_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=COOSA;UID=sa;PWD=;database=master

Configuring Server ...

EXEC sp_grantlogin N'VORDEFINIERT\Administratoren'

[Microsoft][ODBC SQL Server Driver][SQL Server]Granted login access to
'VORDEFINIERT\Administratoren'.

EXEC sp_addsrvrolemember N'VORDEFINIERT\Administratoren', 'sysadmin'

[Microsoft][ODBC SQL Server Driver][SQL
Server]'VORDEFINIERT\Administratoren' added to role 'sysadmin'.

update master.dbo.spt_server_info set attribute_value = @.@.version where
attribute_id = 2

EXEC sp_addserver N'COOSA', local

EXEC sp_configure 'allow updates', 1

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to
install.

reconfigure with override

update master.dbo.sysaltfiles set size=1024 where name=N'tempdev'

EXEC sp_configure 'allow updates', 0

[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution
completed. If DBCC printed error messages, contact your system
administrator.

[Microsoft][ODBC SQL Server Driver][SQL Server]Configuration option
'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to
install.

reconfigure with override

Disconnecting from Server ...

Stopping Service ...

SQL Server has been successfully configured!

###############################################################################

I got the indentical error when I attempted to install SQL 2000 Developer's Edition on XP Pro. My log file failure occurred at the same place yours did.

I had recently installed .Net framework, .Net SDK, and ASP Web Matrix. I made a lucky guess that they were causing the problem.

I did an uninstall of:
.Net framework
.Net SDK
ASP Web Matrix

I deleted the sub folders in c:\Program Files\Microsoft SQL Server.

Then SQL 2000 DE installed successfully, and I reinstalled the .Net framework & ASP Web Matrix.

Hope this helps.

Friday, March 23, 2012

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Frustrating: Can't get to Provider Options in SQL 2005 Express?

Frustrating: Can't get to Provider Options in SQL 2005 Express

Frustrating Visual Studio crashes when adding Script step

Frustrating Visual Studio crashes when adding Script step

Frustrating Visual Studio crashes when adding Script step

Frustrating SubQuery Won't Total

Frustrating Reporting Services problem. New machine fails to deploy reports to report serv

Frustrating nulls with average

Frustrating Newbie Parameter Question

Frustrating Installation Error

Frustrating Installation Error

Get Next Number

Blog Archive

About Me