Install roll back

Hi Guys,
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.

>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok

>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?

>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>

install DTS package

Hi guys!

How do you install a DTS package from another server.

I have a .dts file (coming from another SQL Server) and I want to transfer it to another SQL Server?

Please advise.

Thanks!

Assuming this is SQL 2000, in enterprise manager right click on the DTS node and select open package(in 7.0 this is all tasks open package). The package should now be open in the designer, now just save it locally as normal.|||http://www.sqldts.com/204.aspx

insertion scheduled job in SQL

Hi guys,
i want to make a scheduled job that inserts 10 user defined row each minute continously in enterprise managerI'd write a stored procedure to do the insertion and then use SQL Agent to schedule it to run every minute.
But, what do you mean by "10 user defined row"?

Inserting Zero instead of Null

Hi Guys,

I have the following SQL Code:

SELECT TOP (100) PERCENT

CAST(Item AS nvarchar(32)) AS Item,

CAST(Customer AS nvarchar(12)) AS Customer,

CAST(Warehouse AS nvarchar(12)) AS Warehouse,

MAX(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END) AS INV1,

MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END) AS INV2,
MAX(CASE WHEN InvMonth = 'INV3' THEN CAST(Qty AS numeric(8, 0)) END) AS INV3,

MAX(CASE WHEN InvMonth = 'INV4' THEN CAST(Qty AS numeric(8,0)) END) AS INV4,

MAX(CASE WHEN InvMonth = 'INV5' THEN CAST(Qty AS numeric(8, 0)) END) AS INV5,
MAX(CASE WHEN InvMonth = 'INV6' THEN CAST(Qty AS numeric(8, 0)) END) AS INV6

FROM MVXReport.DMSExportStage1
GROUP BY CAST(Item AS nvarchar(32)), CAST(Customer AS nvarchar(12)), CAST(Warehouse AS nvarchar(12))
ORDER BY Item, Customer

And i am getting the following Results:

T100 APGL 10 1 6 2 1 3 3
T100 AUTOONE 10 NULL NULL NULL NULL NULL NULL
T100 CBCNSW 10 NULL NULL NULL NULL NULL NULL
T100 CBCQLD 10 NULL NULL NULL NULL 2 3
T100 CBCSA 10 NULL NULL NULL NULL NULL NULL
T100 CBCVIC 10 NULL NULL NULL NULL NULL NULL

I would like to know how to insert a 0 (zero) when the qty is null.. I have tried :

MAX(CASE WHEN InvMonth = 'INV1' THEN (CASE WHEN QTY IS NULL THEN (CAST(0 AS numeric(8, 0))) ELSE CAST(Qty AS numeric(8, 0)) END) END) AS INV1,

But it didnt seem to work.. If someone could point me in the right direction that would be wonderful..

thanks

Scotty

You could use COALESCE function for this task. Try change

CASE WHEN QTY IS NULL THEN (CAST(0 AS numeric(8, 0))) ELSE CAST(Qty AS numeric(8, 0)) END

to COALESCE(QTY,0)

|||

Try something like this:

isnull( Qty, 0 )

in each location where you have just Qty.

|||

Thanks Guys,

I have tried both of your solutions, but i am still getting null values. I can see why, as in the file that i am building these columns from, not every customer/Item every month has a record.. Hence why it is bringing back NULL..

Any other ideas...

thnkas

scotty

|||try this one instead

SELECT TOP (100) PERCENT
CAST(Item AS nvarchar(32)) AS Item,
CAST(Customer AS nvarchar(12)) AS Customer,
CAST(Warehouse AS nvarchar(12)) AS Warehouse,
COALESCE(MAX(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV1,
COALESCE(MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV2,
COALESCE(MAX(CASE WHEN InvMonth = 'INV3' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV3,
COALESCE(MAX(CASE WHEN InvMonth = 'INV4' THEN CAST(Qty AS numeric(8,0)) END),0) AS INV4,
COALESCE(MAX(CASE WHEN InvMonth = 'INV5' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV5,
COALESCE(MAX(CASE WHEN InvMonth = 'INV6' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV6
FROM MVXReport.DMSExportStage1
GROUP BY
CAST(Item AS nvarchar(32)),
CAST(Customer AS nvarchar(12)),
CAST(Warehouse AS nvarchar(12))
ORDER BY
Item
, Customer|||

use

MAX(Isnull(CASE WHEN InvMonth = 'INV1' THEN CAST(Qty AS numeric(8, 0)) END,0)) AS INV1

--or

Isnull(MAX(CASE WHEN InvMonth = 'INV2' THEN CAST(Qty AS numeric(8, 0)) END),0) AS INV2

Inserting the date as defaultvalue in a sqldatasource Parameter

Hi Guys.

I am trying to insert the date as the default value into the DatePosted parameter in the sqldatasource object. I have put have the following below but it doesn't work. I have also tried <asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= Date.Now %>" />

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue="<%= now() %>" />

I know the solution is probably simple and I look like an idiot, but excuse me because I am very knew and fragile at this lol...

any help would be great :).

Mike.

Change your code to this,and it is OK.

<asp:Parameter Name="DatePosted" Type="DateTime" DefaultValue='<%# DateTime.Now %>' />

|||

Hi Jason,This does not work either. It says you can't use databind in a parameter I tried it with <%= %> as well but still nothing?

Any other ideas?

|||

If you can't override the parameter, it would be easiest to change the sql statement to reference getdate or getutcdate instead like:

INSERT INTO MyTable(col1,DatePosted) VALUES (@.col1,getutcdate())

If you have to allow for the parameter to be overridden, try putting this code into page_init:

SqlDatasource1.InsertParameters("DatePosted").DefaultValue=now

|||just do it at the database level via enterprise manager by modifying the table in question and set the default for the column by specifying the getdate() function so when a recorded is inserted via code with dateposted not supplied the sql server will insert that column with the current date.|||I have the same problem and this solution doesnt work. The column in the table has a default of getdate(), but I still get an error that NULL cannot be insert into the column. The problem is there is no way to tell it to not supply a value--if a value is not set it will supply NULL. Is there another way to default a DateTime parameter to DateTime.Now or getdate()? TIA|||

The solution I posted should work. The solution posted after mine should also work.

Please post your code.

|||

Doing it at the database level only works if you can remove it as a parameter entirely. In my case I needed to allow the user to enter datetime and only default it to getdate()/DateTime.Now when they choose not to enter specific date.

I knew of the page init method you suggested, but I was trying to avoid this as I was experimenting with how much you can do with only declarative code--I guess I just hit one of the limits of declarative coding.

(For the record, I much prefer DDD with NHibernate, NUnit, etc., but in some cases, especially for small/trivial/non-critical projects, being able to do things quickly outweighs other concerns.)

inserting string with quotes

Hi Guys,
i want to insert a string for example 'abcd'edfg'gg'into a
table in sql server 2000.
but it is not working but giving the error
"not permitted in this context. Only constants,
expressions, or variables allowed here. Column names are
not permitted."
will this require any sp_configue or db_option changes?
pls advice me.Use two single quotes instead of one like: 'abcd''edfg''gg'
Anith