Microsoft Security Bulletin MS06-071 ROLLBACK

Hi,
I am producing a Rollback plan in case I find any issue with MS06-071 hotfix
installation. We have several SQL 2005 Servers so I need to have this
rollback plan ready for the day we install this hotfix.
This is a hotfix for MSXML 6.0 which is needed for SQL 2005 Server. If
something goes wrong with the SQL server after I install this hotfix and I
uninstall this hotfix it automatically uninstall MSXML 6.0 as well.
My question is : do I have to install the whole SQL server 2005 again if I
uninstall this hotfix and therefore I uninstall MSXML 6.0? would it be enough
if I install MSXML 6.0 afterwards?
Thank you for your help
Best regards,
Juanjo
Hi Juanjo,
If you do need to uninstall MSXML6 after applying MS06-071 you can reinstall
MSXML6 MS06-061 or MSXML6 RTM directly without reinstalling SQL 2005.
However, most likely your SQL Server 2005 will not function until MSXML6 is
re-installed.
You can download MSXML6-061 from here -
http://www.microsoft.com/downloads/details.aspx?FamilyId=fd513435-fa6d-407c-bedc-5fd03e5b7d6c
or MSXML6 RTM from here -
http://www.microsoft.com/downloads/details.aspx?FamilyID=993C0BCF-3BCF-4009-BE21-27E85E1857B1&displaylang=en
However I hope MS06-071 rollout goes smoothly for you - if you have any
trouble please come to our blog site http://blogs.msdn.com/xmlteam and click
on the email link to let us know what's going on.
Thanks,
Adam Wiener [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Juanjo" <Juanjo@.discussions.microsoft.com> wrote in message
news:4F2BA3B9-0569-46A3-BB66-50FA01AA15F6@.microsoft.com...
> Hi,
> I am producing a Rollback plan in case I find any issue with MS06-071
> hotfix
> installation. We have several SQL 2005 Servers so I need to have this
> rollback plan ready for the day we install this hotfix.
> This is a hotfix for MSXML 6.0 which is needed for SQL 2005 Server. If
> something goes wrong with the SQL server after I install this hotfix and I
> uninstall this hotfix it automatically uninstall MSXML 6.0 as well.
> My question is : do I have to install the whole SQL server 2005 again if I
> uninstall this hotfix and therefore I uninstall MSXML 6.0? would it be
> enough
> if I install MSXML 6.0 afterwards?
> Thank you for your help
> Best regards,
> Juanjo

Microsoft Security Bulletin MS06-071 ROLLBACK

Hi,
I am producing a Rollback plan in case I find any issue with MS06-071 hotfix
installation. We have several SQL 2005 Servers so I need to have this
rollback plan ready for the day we install this hotfix.
This is a hotfix for MSXML 6.0 which is needed for SQL 2005 Server. If
something goes wrong with the SQL server after I install this hotfix and I
uninstall this hotfix it automatically uninstall MSXML 6.0 as well.
My question is : do I have to install the whole SQL server 2005 again if I
uninstall this hotfix and therefore I uninstall MSXML 6.0? would it be enoug
h
if I install MSXML 6.0 afterwards?
Thank you for your help
Best regards,
JuanjoHi Juanjo,
If you do need to uninstall MSXML6 after applying MS06-071 you can reinstall
MSXML6 MS06-061 or MSXML6 RTM directly without reinstalling SQL 2005.
However, most likely your SQL Server 2005 will not function until MSXML6 is
re-installed.
You can download MSXML6-061 from here -
http://www.microsoft.com/downloads/.../>
fd03e5b7d6c
or MSXML6 RTM from here -
http://www.microsoft.com/downloads/...&displaylang=en
However I hope MS06-071 rollout goes smoothly for you - if you have any
trouble please come to our blog site http://blogs.msdn.com/xmlteam and click
on the email link to let us know what's going on.
Thanks,
Adam Wiener [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"Juanjo" <Juanjo@.discussions.microsoft.com> wrote in message
news:4F2BA3B9-0569-46A3-BB66-50FA01AA15F6@.microsoft.com...
> Hi,
> I am producing a Rollback plan in case I find any issue with MS06-071
> hotfix
> installation. We have several SQL 2005 Servers so I need to have this
> rollback plan ready for the day we install this hotfix.
> This is a hotfix for MSXML 6.0 which is needed for SQL 2005 Server. If
> something goes wrong with the SQL server after I install this hotfix and I
> uninstall this hotfix it automatically uninstall MSXML 6.0 as well.
> My question is : do I have to install the whole SQL server 2005 again if I
> uninstall this hotfix and therefore I uninstall MSXML 6.0? would it be
> enough
> if I install MSXML 6.0 afterwards?
> Thank you for your help
> Best regards,
> Juanjo

Microsoft decision tree

I have an example case below :

Customer Id

Debt Level

Income Level

Employment Type

Credit Risk

1

High

High

Self-Employed

Bad

2

High

High

Salaried

Bad

3

High

Low

Salaried

Bad

4

Low

Low

Salaried

Good

5

Low

Low

Self-Emplyed

Bad

6

Low

High

Self-Employed

Good

7

Low

High

Salaried

Good

My question is how to make a tree from the case above I mean what method we should use to split the tree. (Mannually counting)

I hope anyone could help me by explaining i details.Because i want to make some analysis how microsoft decision tree works exactly.So Please explain me the process to build the tree completely with the method.

Thanks a lot.

Please clarify your question. I'm not sure what you are asking for- you want the equations used to determine a split?|||I'm so sorry because of confusing question. Yes what i mean is equations used to determine a split. Would you explain it detail for me? Because i 've made a thesis about microsoft decision tree analysis so i need to know how microsoft decision tree work exactly.
thank you so much|||

This article explains how the Microsoft Decision Tree algorithm works at a high level and also points to the relevant research papers that the implementation is based on: http://msdn2.microsoft.com/en-us/library/ms175312(SQL.90,d=ide).aspx

Microsoft decision tree

Hi again ....i'm trying to understand the works of microsoft decision tree algorithm

I have an example case below :

Customer Id

Debt Level

Income Level

Employment Type

Credit Risk

1

High

High

Self-Employed

Bad

2

High

High

Salaried

Bad

3

High

Low

Salaried

Bad

4

Low

Low

Salaried

Good

5

Low

Low

Self-Emplyed

Bad

6

Low

High

Self-Employed

Good

7

Low

High

Salaried

Good

My question is how about the equations used to determine a split?

Please explain me detailed.

Thanks a lot.

This article explains how the Microsoft Decision Tree algorithm works at a high level and also points to the relevant research papers that the implementation is based on:http://msdn2.microsoft.com/en-us/library/ms175312(SQL.90,d=ide).aspx

Metadata in sql server 2005

Hi
I add extended properties to table in sql server 2005, for example i add Caption property to every column.
In case I generate a datasource from table in sql server in visual studio 2005, Is there a way that "Caption" property in datatable to be filled from that metadata, or metadata is useless for dataset.
Every time i had to fill manually the caption property of datatable generated .

hi,

you can access those extended properties calling fn_listextendedproperty function, similar to

SET NOCOUNT ON; USE tempdb; GO CREATE TABLE dbo.Invoice ( ID INT NOT NULL PRIMARY KEY , BillNo INT NOT NULL -- , others ) GO EXEC sp_addextendedproperty '1st property' , '1St property value' , 'user' , 'dbo' , 'table' , 'Invoice' , NULL , NULL; EXEC sp_addextendedproperty '2nd property' , '2nd property value' , 'user' , 'dbo' , 'table' , 'Invoice' , NULL , NULL; GO PRINT 'All available properties'; SELECT CONVERT(VARCHAR(20), [name]) AS [Property Name] , CONVERT(VARCHAR(20), [value]) AS [Property vCharValue] FROM ::fn_listextendedproperty( NULL , 'user' , 'dbo' , 'table' , 'Invoice' , NULL , NULL ); GO PRINT 'just the required [1st property] property'; SELECT CONVERT(VARCHAR(20), [name]) AS [Property Name] , convert(VARCHAR(20),[value]) AS [Property vCharValue] FROM ::fn_listextendedproperty( '1st property' , 'user' , 'dbo' , 'table' , 'Invoice' , NULL , NULL ); GO DROP TABLE dbo.Invoice; --< All available properties Property Name Property vCharValue -- -- 1st property 1St property value 2nd property 2nd property value just the required [1st property] property Property Name Property vCharValue -- -- 1st property 1St property value

so, assuming you are interested in the Invoice management, you have to query for all the properties of the dbo.Invoice table columns...

this can obviously fill a dataset or a datareader you can then consume to map as desired the returned values so you could assume the "1st property" is the caption of the corresponding UI control and you can set it accordingly..

BTW, to manage those properties outside the Microsoft tools you have to resort on http://msdn2.microsoft.com/en-us/library/aa174648(SQL.80).aspx and http://msdn2.microsoft.com/en-us/library/ms190243.aspx

regards|||Thank you for your reply.
I mean , what is the extended properties that may be used automatically by visual studio 2005.
For example , Can the "Caption " property of datatable created in vs 2005 , be set automatically using extended properties?
This property is useful, because form wizard creates label with that "caption" value(when i set it at design time), and textbox bound to column.

|||

hi,

no, you have to deal with that "by hand"...

regards