Thursday, March 31, 2022

BizTalk Adapter Pack 1.0 Eval version

BizTalk Adapter Pack 1.0 Eval version

 

We are announcing the availability of the Eval version of the BizTalk Adapter Pack 1.0! This can downloaded from here. You can use the eval version for development purposes for 120-day from the day of installation.

 

Party on!

The BizTalk Adapter Pack Team

 

 

Maximum Capacity Specifications Comparison for SQL Server 7, 2000 and 2005

Object SQL Server 7.0 SQL Server 2000 SQL Server 2005 (32-bit)
Batch size 65,536 * Network Packet Size 65,536 * Network Packet Size 65,536 * Network Packet Size
Bytes per short string column 8,000 8,000 8,000
Bytes per text, ntext, or image column 2 GB-2 2 GB-2 2 GB-2
Bytes per GROUP BY, ORDER BY 8,060 8,060 8,060
Bytes per index 900 900 900
Bytes per foreign key 900 900 900
Bytes per primary key 900 900 900
Bytes per row 8,060 8,060 8,060
Bytes in source text of a stored procedure Lesser of batch size or 250 MB Lesser of batch size or 250 MB Lesser of batch size or 250 MB
Bytes per VARCHAR(MAX), VARBINARY(MAX), XML, TEXT, or IMAGEcolumn N/A N/A 2^31-1
Characters per NTEXT or NVARCHAR(MAX) column. N/A N/A 2^30-1
Clustered indexes per table 1 1 1
Columns in GROUP BY, ORDER BY Limited only by number of bytes per GROUP BY, ORDER BY Limited only by number of bytes per GROUP BY, ORDER BY Limited only by number of bytes per GROUP BY, ORDER BY
Columns or expressions in a GROUP BY WITH CUBE or WITH ROLLUP statement 10 10 10
Columns per index 16 16 16
Columns per foreign key 16 16 16
Columns per primary key 16 16 16
Columns per base table 1,024 1,024 1,024
Columns per SELECT statement 4,096 4,096 4,096
Columns per INSERT statement 1,024 1,024 1,024
Connections per client Maximum value of configured connections Maximum value of configured connections Maximum value of configured connections
Database size 1,048,516 TB 1,048,516 TB 1,048,516 TB
Databases per instance of SQL Server 32,767 32,767 32,767
Filegroups per database 256 256 32,767


Reply:
Files per database 32,767 32,767 32,767
File size (data) 32 TB 32 TB 16 TB
File size (log) 4 TB 32 TB 2 terabytes
Foreign key table references per table4 253 253 253
Identifier length (in characters) 128 128 128
Instances per computer N/A 16 16
Length of a string containing SQL Statements (batch size) 65,536 * Network packet size 1 65,536 * Network packet size 1 65,536 * Network packet size 1
Locks per connection Maximum locks per server Maximum locks per server Maximum locks per server
Locks per instance of SQL Server 2,147,483,647 (static) 40% of SQL Server memory (dynamic) 2,147,483,647 (static) 40% of SQL Server memory (dynamic) Up to 2,147,483,647
Nested stored procedure levels6 32 32 32
Nested subqueries 32 32 32
Nested trigger levels 32 32 32
Nonclustered indexes per table 249 249 249
Objects concurrently open in an instance of SQL Server 2,147,483,647 (or available memory) 2,147,483,647 (or available memory)
Objects in a database 2,147,483,647 2,147,483,647 2,147,483,647
Parameters per stored procedure 1,024 1,024 2,100
Parameters per user-defined function 1,024 1,024 2,100
Partitions per partitioned table or index N/A N/A 1,000
REFERENCES per table 253 253 253
Rows per table Limited by available storage Limited by available storage Limited by available storage
Statistics on non-indexed columns 2,000
Tables per database Limited by number of objects in a database Limited by number of objects in a database Limited by number of objects in a database
Tables per SELECT statement 256 256 256
Triggers per table Limited by number of objects in a database Limited by number of objects in a database Limited by number of objects in a database
UNIQUE indexes or constraints per table 249 nonclustered and 1 clustered 249 nonclustered and 1 clustered 249 nonclustered and 1 clustered
XML indexes N/A N/A 249

 


------------------------------------

XP3 / USB Compatibility - VIA chipset

SP3 rc2 (build 3311) on Shuttle SK41G (AMD/VIA chipset). Inserting a flash drive in a usb port will trigger an instant reboot sequence which will then loop until device removed.  SP3 uninstall sequence restores functionality without reloading any drivers.


Reply:

 

Evening Quark

 A few questions

1 Which chipset driver version are you using when this happens?

2 Is it a .inf? and the latest available one from Shuttle?

 

3Check the following

Click on start, run enter the letters "services.msc"

are the following services running?

a) WMI driver service instrumentation at least set to manual?

b)Windows installer started and automatic?

c)Logical disk manager manual or automatic?

d)Logical Disk Manager adminstrative service?

e)RPC. not the locator one. But this one has alot of dependcies. If it is running or at least manual you are ok

 

AA) Clicking on start, accessories then sytem tool and system information are there any conflicts with the usb controller and something else?

 

4) Do you have a hub connected with out power?

a)What type of devices are connected when this failed? There is a KB articale about this when an unpowered hub is used. And over loads the Usb connection to the computer.

 

b) Does re-installing the usb.inf from the :windir%\inf folder work?

 

   This is searching for the usb.in and right clicking the usb.inf and clicking on install.

What errors are on the event log? System?

Any errors in Setuperr in the %windir%\system32 folder?

 

I think this covers almost every thing except if you at least do alittle research and some log enteries may help us firgure this out with out having to connect remotely.

 

Cheers

Keith


------------------------------------
Reply:

 Quark7 wrote:
SP3 rc2 (build 3311) on Shuttle SK41G (AMD/VIA chipset). Inserting a flash drive in a usb port will trigger an instant reboot sequence which will then loop until device removed.

At this stage, there is no merit in continuing with SP3 RC2, and when you try again, you should use the final released version.

 

If I were in this position, I would try installing the latest VIA chipset drivers, direct from VIA.

 

Also, try checking C:\windows\svcpack.log to see whether the installation of any XP USB drivers was skipped because they were thought to be "OEM" drivers.


------------------------------------

Select statment

What is wrong with this sql statment?

declare @alpha as nvarchar(50)

set @alpha = select top 1 monthyear from dbo.Performance_Indicators_Rolling order by recordkey


i get the error 

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'select'.

  • Changed type tonysoper_MSFT Wednesday, June 18, 2008 9:04 PM per andrew
  • Moved by Bill_Stewart Monday, July 28, 2014 4:37 PM Off-topic

Reply:
this is the right code

declare @alpha as nvarchar(50)
select top 1 @alpha = monthyear from dbo.Performance_Indicators_Rolling order by recordkey

but there is the wrong forum, next time post on MSSQL forums


Christian Paparelli

------------------------------------

A disk read error occurred Press Ctrl + Alt + Del to restart"

 

Hi vince

I would suggest changing the SATA cable on the back of your SATA drive. 

This was the only thing worked for me.  Sounds like a faulty hard disk drive cable#

 

Ciara

Documentation for install Windows XP by Operating System Deploymnet

Hi Team.

 

I need documentation for install Windows XP SP2 by feature Operating System Deployment in Configuration Manager.

 

I find documentation in Internet but only have for install Windows Vista.

 

Thanks,

 

Carlos


Reply:

You're right... You need to dive deep into the documentation to find guides for deploying XP

 

You need to build a refernce image first... This article can help build that image:
http://poseidom.wordpress.com/2008/05/20/building-an-xp-base-image-in-sccm-part-1/

 

Hopefully that will get you started...

 

Best Regards

Ronni Pedersen


------------------------------------

Club Shepherd, yyyy

I HAVE THE RESOLUTION FIGURED OUT, FOR everything -4-7 coding GLITCHES, I have them, worked Around!  47 NEW Feature Presentations, Will come to all, the Paid, Club Shepherd, yyyy, members.  53 features, I INVENTED, 2 NEW Features MY Brother, INVENTED, 14 Major League Code Feature presentations!!  2 features Were Designed by him, which I appreciate, because they are Just nice add-on's.  Sorry, I Am a Systems Anayst Miami, OH Graduate.  MY, WORK, A MASTERPIECE, RESOLVES EVERYTHING, Besides the Coding Malfunctions, produced By Al Gore (SNORE).  I Promise ALL Will LOVE, MY HARD WORK.  10 HOT FUNCTIONS, 27 MINOR ADDitions, will come to LIFE, When U DO YOUR Share of WORK, 2 feature presentions, will ROCK THEE Globe, they are that IMPRESSIVE!  I have in my BEST MASTERPIECE, THEE Solution to the ILLEGAL Inmmigration political problem, also, When Congress Acts upon my EEE (English Entrance Exam).  Embedded in ALL THE HI-Tech Systems Analysis WORK, I Have MY Solution commented, in a procedure Call.  I have INVENTED This Entire Solution, single-handedly, just About, 45 NEW Feature procedure Calls, I INVENTED So, I PROMISE you, will LOVE MY Euchre Round-Robin, Card Tournament!  The Shepherd Act, Congress WILL PASS, BECAUSE IT IS THE Solution to ILLEGAL Immigration.  In, 5 YEARS, Invented thee Solution to ALL THE ILLEGALS, and implemented the Solution to every known Problem, I INVENTED THIS Congressional Act, so, I Will JUST BE Patient, and WATCH Microsoft, because IT Was them, I EXPLAINED EVERYTHING To!!!!!!!!!!!!  I Solved thee on-line thievery problem, too, in regarda to MY INVENTION.  14 Major Computer coding MALFUNCTIONS, I Fixed, I SOLVED EVEYTHING, Through HARD Work, and Patience, and Diligence!!  25 minor coding features, I INVENTED For ALL THE World Wide Web Computer SLOPPINESS.  WOW, I Am, SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO EVER EXHAUSTED, So, sloppy Al Gore's WORK, Produced FOR Me to FIX!  Al SNORED THROUGH THIS great INVENTION, i DON'T know why HE MUST Have Snored, and To LEAVE ME All the HI-Tech Computer Work.  He left it insecure, due to ALL THE Computer Glitches, I Found!  Club Shepherd, 2008, and The Shepherd Act, resolves America, of its MOST Annoying problem!  ILLEGAL Immigrants, I Solved by The Shepherd Act, 2008!  The Shepherd Card Cruise, for Relaxation, If you INSTALL A Gym, aboard a Cruise-ship.  47 NEW FEATURES WILL HAPPEN!  Jesusc Christ's MASTERPIECE, I Am JUST A HARD-WORKING Implementor!

 

Brian Shepherd

513-367-6048

cincy2hot4u@hotmail.com

+++Bridge_SMASH

Club Shepherd, 2008, because I Invented THIS Computer MASTERPIECE

10490 Sugardale, Harrison, OH 45030

FAQs: Microsoft KB articles on XP SP3

Check out these Microsoft KnowledgeBase articles to see whether your issue is already known and fixed:

 

You receive a "Stop 0x0000007E" error message after you upgrade to Windows XP Service Pack 2 on a non-Intel-processor-based computer

(888372) - Discusses how you may receive an error message after you upgrade a computer that uses a processor other than an Intel processor to Windows XP Service Pack 2.

Error message: Windows has detected that one or more protected core system files (kernel) on your computer have been modified

(327101) - ... issue that occurs when you try to install Windows XP SP1 or ... Try to install the Windows XP Service Pack.

 

 

After you create Windows XP Service Pack 3 slipstreamed media, your product key is not accepted

(950722) - Describes that Windows XP Service Pack 3 (SP3) slipstream media may not be installed correctly when you create it with the "/integrate" option on a Windows Vista-based or Windows Server 2008-based computer. Provides a resolution.

The Authentication tab is missing in the properties dialog box of the wired network adapter after you install Windows XP Service Pack 3

(950725) - Describes an issue that occurs after you install Windows XP Service Pack 3 (SP3). Specifically, the Authentication tab is missing in the properties dialog box of the computer's wired network adapter. A resolution is provided.

Changes to the 802.1X-based wired network connection settings in Windows XP Service Pack 3

(949984) - Describes that the AuthMode and SupplicantMode registry entries are no longer used in Windows XP Service Pack 3 for a 802.1X-based wired network connection.

Error message during every restart after you install Windows XP Service Pack 3: "The procedure entry point apsSearchInterface could not be located in the dynamic link library wlanapi.dll"

(950720) - Describes a situation in which you receive an error message every time that you restart a Windows XP-based computer. Specifically, this problem occurs after you install Windows XP Service Pack 3 (SP3). A resolution is provided.

How to use Systems Management Server to distribute Windows XP Service Pack 3 from a shared folder on a network

(947310) - Describes how to use SMS to deploy Windows XP Service Pack 3 to Windows XP clients. This article assumes that you have an understanding of SMS and a working knowledge of software distribution.

The hard disk space requirements for Windows XP Service Pack 3

(947311) - Discusses the hard disk space requirements for installing Windows XP Service Pack 3 (SP3) on a computer on which Windows XP is already installed.

Some third-party programs may experience a change in functionality after you install Windows XP Service Pack 3

(947309) - Provides a list of third-party programs that may experience a change in functionality after you install Windows XP Service Pack 3.

Error message when you try to install Windows XP Service Pack 3: "Setup has detected that another update is in progress Please complete that installation or removal and try again"

(949381) - Describes the issue in which the Windows XP Service Pack 3 (SP3) installation is unsuccessful if the update.exe file is running on the computer. Methods to resolve this issue are provided.

How to troubleshoot an unsuccessful installation of Windows XP Service Pack 3

(950718) - Describes how to troubleshoot errors that may occur when you try to install Windows XP Service Pack 3. Five troubleshooting methods are provided.

Error message when you try to install Windows XP Service Pack 3: "Access is denied" or "Service Pack installation did not complete"

(949377) - Describes methods to troubleshoot error messages that you may receive when you install Windows XP Service Pack 3 (SP3).

How to remove Windows XP Service Pack 3 from your computer

(950249) - Describes how to remove Windows XP Service Pack 3 (SP3) from your computer.

Error message when you try to install Windows XP Service Pack 3: "You do not have enough free disk space on %SystemDrive% to install Service Pack 3"

(949385) - Describes a disk-space error that you receive when you try to install Windows XP SP3. You must free some disk space on the system drive to successfully install the service pack.

Steps to take before you install Windows XP Service Pack 3

(950717) - Recommends steps to take before you install Windows XP Service Pack 3. Also includes troubleshooting information.

Description of the Credential Security Service Provider (CredSSP) in Windows XP Service Pack 3

(951608) - Describes the Credential Security Service Provider (CredSSP) in Windows XP Service Pack 3 (SP3).

Error message when you try to use the "Files and Settings Transfer" Wizard to import settings on a computer that is running Windows XP Service Pack 3: "Your migration store was created with a previous version of Files and Settings Transfer Wizard"

(950728) - Describes an issue on a Windows XP SP3-based computer in which you may receive an error message when you try to import settings from a computer that is running a version of Windows earlier than Windows XP SP3. A resolution is provided.

You cannot uninstall Internet Explorer 7 or Internet Explorer 8 Beta 1 after you install Windows XP Service Pack 3

(950719) - Describes an issue that you cannot uninstall Internet Explorer 7 or Internet Explorer 8 Beta 1 after you install Windows XP SP3. Provides a resolution.

An update is available for the Multilingual User Interface Pack in Windows XP Service Pack 3

(942766) - Describes the update for the MUI Pack in Windows XP SP3. This update fixes the issues in which text is displayed in English in the User Interface, instead of in the selected language.

Third-party themes programs may not work as expected after you install Windows XP Service Pack 3

(950258) - Describes why third-party themes programs may not work after you install Windows XP SP3. To resolve this issue, contact the program vendor to obtain an updated Uxtheme.dll file that is compatible with Windows XP SP3.

A Windows XP Service Pack 3-based computer stops responding after you use the Sysprep utility

(951611) - Describes an issue in which a blank white screen is displayed when you restart a Windows XP SP3-based computer after you use the Sysprep utility. A workaround is provided.

The Address toolbar no longer appears on the taskbar after you install Windows XP Service Pack 3

(951448) - Describes why the Address toolbar is no longer visible on the taskbar after you upgrade to Windows XP SP3. A workaround for this missing functionality is provided.

A connection may not be made in the first dial attempt in Windows XP Service Pack 3

(951605) - Describes a behavior that occurs when you dial a NAP-enabled remote access (RAS) connection in Windows XP SP3. Provides a workaround.

You cannot save multiple credentials for the same remote computer when you use the RDP client that is included in Windows XP Service Pack 3

(951609) - Describes a behavior that occurs when you use RDP client in Windows XP SP3-based computers. You cannot save more than one set of credentials for the same computer.

Windows XP Service Pack 3 installation fails with an error message, and the following error is logged in the service pack installation log: "8007F0F4 - STATUS_PREREQUISITE_FAILED"

(949388) - Describes why the Windows XP SP3 installation fails and describes an error message that is logged. You must take one of the actions that are described in this article to resolve this issue.

Windows XP Service Pack 3-based computers in a private network that uses Internet Connection Sharing may lose network connectivity after you change the network adapter settings of the private adapter on the Internet Connection Sharing computer

(951446) - Describes a resolution for an issue in which computers in a private network that use Internet Connection Sharing on a Windows XP SP3-based computer loses network connectivity after you change the network adapter settings.

Error message when you try to install Windows XP Service Pack 3 on some Intel processor-based Apple computers: "Out of Disk Space"

(950716) - Describes a problem in which you may receive an error message when you try to install Windows XP SP3 on some Intel processor-based Apple computers.

When you use Group Policy to install Windows XP Service Pack 3, and then you remove the service pack manually, you cannot then reinstall the service pack by using Group Policy

(951610) - Describes a workaround for an issue in which registry entries for the Windows XP SP3 installation through Group Policy prevent reinstalling Windows XP SP3 through Group Policy again after you remove it manually from the computer.

The installation fails, and an error code is logged in the Windows Update log file when you try to install Windows XP Service Pack 3 from Windows Update

(949386) - Describes an issue that occurs if the Download folder is deleted or if system files are changed after the download process is complete. Provides a resolution.

Spyware Doctor 5.5 or earlier versions of Spyware Doctor may cause Windows XP Service Pack 3 to stop responding when you try to install or to uninstall the service pack

(951403) - Describes scenarios in which Windows XP SP3 may stop responding when Spyware Doctor 5.5 or an earlier version is installed. This issue occurs when you try to install or to uninstall Windows XP SP3. Resolution is to disable Spyware Doctor.

The "CScript //H" or "WScript //H" command may not work as expected on a Windows XP-based computer after you install or uninstall Windows XP Service Pack 3

(952033) - Describes a Windows XP issue that involves Windows Script Hosting. Specifically, when you use the CScript //H or WScript //H command to change the default script host, this operation may not work as expected. A workaround is provided.

Client connections do not authenticate successfully with a Cisco switch when it takes more than five seconds to generate an NAP SoH message on a Windows Vista-based computer or on a Windows XP Service Pack 3-based computer

(947017) - When it takes more than five seconds to generate a Network Access Protection (NAP) statement of health (SoH) message on a Windows Vista-based computer or on a Windows XP Service Pack 3-based computer, client connections do not authenticate successfully with a Cisco switch.

Error messages when you try to install Windows XP Service Pack 3: "Service Pack 3 installation did not complete" and "An internal error occurred"

(949384) - Describes several causes of the error that occurs when you try to install Windows XP SP3. Resolutions and a workaround are provided.

You receive an error message, the print operation fails, or partial pages are printed when you try to print to a Citizen printer or to an Alps printer in Windows XP Service Pack 3

(951822) - Describes a problem that occurs because of an error in the Alpsres.dll plug-in in Citizen printers and in Alps printers. Provides a resolution.

Script output is not displayed as expected when you run VBScript or JScript scripts in Windows Vista Service Pack 1, in Windows Server 2008, or in Windows XP Service Pack 3

(951978) - Describes a problem that occurs when the language locale that you configured differs from the language of the operating system. Provides a workaround.

You cannot create a slipstream build of Windows XP N Service Pack 3 by using the "/integrate" parameter or the "/s" parameter on N editions of Windows XP

(951606) - Describes an issue in which you cannot create a slipstream build when you combine Windows XP N SP3 with the Windows XP Home N installation media or with the Windows XP Professional N installation media. A resolution is provided.

Error message when you try to install Windows XP SP3: "You do not have enough free disk space on %SystemDrive% to archive the uninstall files"

(949375) - Describes an issue that may occur when you try to install Windows XP SP3. Specifically, if the free disk space is insufficient to archive the uninstall files. A resolution is provided.

Error message when you try to install a hotfix or an update on a Windows XP computer: "You do not have permission to update Windows XP"

(951244) - Describes an issue in which you cannot install a hotfix or an update on a Windows XP computer. This issue may occur if you are not logged on as a user who has local administrator permissions or if the Group Policy settings are too restrictive.

A Windows XP SP3-based computer loses wireless connectivity when it resumes from standby or from hibernation, or you receive an error message when you try to put the computer in standby or in hibernation

(951447) - Describes the issue in which you cannot put the computer in standby or in hibernation after you install Windows XP SP3. Or, the computer loses wireless connectivity when it resumes from standby or from hibernation. Provides a workaround.

When you double-click the Internet Explorer 7 icon on the desktop after you install Windows XP SP3, Internet Explorer does not start, and a new Internet Explorer shortcut is created

(950721) - Fixes an issue in which Internet Explorer does not start after you double-click the Internet Explorer 7 icon on the desktop. Instead, a new shortcut is created. This problem occurs after a Windows XP SP3 upgrade.

You cannot connect to a remote computer or start a remote application when you use Terminal Services Web Access or Remote Web Workspace on a Windows XP SP3-based computer

(951607) - Describes a workaround for an issue in which you cannot connect to a remote computer or start a remote application when you use TS Web Access or Remote Web Workspace on a Windows XP SP3-based computer. Occurs because of an ActiveX control issue.

When you disable and then re-enable the LAN-side network adapter on a Windows XP SP3-based computer that is configured as a Connection Sharing host, a client computer on the network cannot access the Internet

(951830) - Fixes an issue in which a client computer cannot access the Internet. This issue occurs when you disable and then re-enable the LAN-side network adapter on a Windows XP SP3-based computer that functions as an Internet Connection Sharing host.

An audio application that uses the Portcls.sys file may stop responding when you run the audio application on a computer that is running Windows XP

(950616) - Describes a problem that occurs when a thread of the Portcls.sys file tries to reacquire a spin-lock if an I/O request packet (IRP) is canceled at certain points in its processing. Provides a hotfix.

MS06-069: Vulnerabilities in Macromedia Flash Player from Adobe could allow remote code execution

(923789) - security_patch security_update bug flaw malicious attacker exploit registry unauthenticated buffer overrun overflow specially-formed scope specially-crafted denial of service DoS TSE

Description of the Remote Desktop Connection 6.1 client update for Terminal Services

(951616) - Describes the Remote Desktop Connection 6.1 client update and how it affects Terminal Services in Windows Vista SP1, in Windows XP SP3, and in Windows Server 2008.

On a computer that is running Windows Server 2003 or Windows XP, an application experiences an access violation and then crashes if the computer has more than four cores or more than four logical processors

(953028) - Fixes an issue in which applications may encounter an access violation and then crash in Windows Server 2003 or in Windows XP. This problem occurs if there are more than four cores or processors being used on the computer.

You cannot upgrade a Windows-based operating system when you have Windows PowerShell 1.0 installed

(950376) - Discusses an error message that directs you to uninstall Windows PowerShell 1.0 before you upgrade a Windows-based operating system. A workaround is provided.

FIX: Error message when you insert data to a table that contains two image columns by using the SQL Server ODBC driver: "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid locator de-referenced"

(950565) - Fixes an issue in which you receive an error message when you insert data in a table that contains two image columns by using the SQL Server ODBC driver that is included in the MDAC.

On a computer that is running Windows Vista, Windows Server 2008, or Windows XP, an incorrect value is returned when an application queries the identity column value of a newly inserted row in various versions of SQL Server 2005 and of SQL Server 2000

(951937) - Fixes a problem in which an incorrect value is returned when you query the identity column value of the newly inserted row on a computer that is running Windows Vista, Windows Server 2008, or Windows XP, that is connected to SQL Server 2005 or 2000.

A multiprocessor computer that is running a Microsoft Windows operating system stops responding on a black screen after you resume the computer from hibernation

(951126) - Fixes an issue in which a multiprocessor computer that is running Windows Vista or Windows XP or Windows 2003 stops responding after you resume the computer from hibernation (S4). This problem occurs on a computer that has multiple processors.

List of fixes that are included in Windows XP Service Pack 3

(946480) - Primarily intended for IT Professionals, this article lists the fixes that were added in Windows XP Service Pack 3.

An application that uses the ADO interface may malfunction, or data loss may occur when the application connects to SQL Server in Windows Vista, in Windows XP, or in Windows Server 2008

(952287) - Describes a problem in which an incorrect value is returned when you query the identity column value of a newly inserted row on a computer that is connected to SQL Server. Provides a resolution.

December 2007 cumulative time zone update for Microsoft Windows operating systems

(942763) - ... 00,02,00,00,00,00,00,00,00 "2007"=hex:20,fe,ff,ff,00,00,00,00,c4,ff,ff,ff,00,00,03,00,00,00,05,00,03,00,\ 00,00,00,00,00,00,00,00,0a,00,00,00,05,00,02,00,00,00,00,00,00,00 Update rollup information Windows XP Prerequisites To apply this hotfix, you must have Windows XP Service Pack 2 (SP2 ...


Reply:

Hi rdhw,

The December 2007 cumulative time zone update for Microsoft Windows operating systems listed here is wrong!

Plain and simple!! I've tried to get microsoft to remove this hotfix from this listing to no prevail. What concerns me is that folks slipstreaming sp3 into xp or reinstall xp sp3 with out this update(xp sp2) already on their computers are going to get a very big surprise when october rolls around for daylight savings time! Also, folks who have time zone changes in their countries or regions are going to find out that their time zones are incorrect the hard way.

A lot of people are going to be furious with microsoft.

I've slipstreamed this update into xp sp3 so it will always be there in the future. I wonder what other surprises I'm going to find out when it comes to a ledged hotfixes included in sp3? I would not trust this hot fix being on my system unless it was slip steamed into xp sp3 final (build 5512)! You may want to use the Time Zone Editor from Microsoft to check your time zones
and Daylight Savings Time.

Microsoft needs to fix this hot fix list!!

Take Care,

thesunnytexas




------------------------------------
Reply:

No, it is quite correct. This update is listed as an update to SP3 (as well as SP2), and thus it is listed in my post as relevant to SP3.  My post is not a list of hotfixes included in SP3, it is a list of KB articles that provide solutions for SP3 problems.


------------------------------------
Reply:

Hi rdhw,

Maybe I don't understand the official hotfix list for sp3 from microsoft. When we were beta testing service pack 3, we were

told that the new daylight standard time would not be part of service pack 3 final! I thought this was very strange because

this hotfix  was such of a important one for everyone. After reading the official hotfix list from microsoft website, I decided to

install the retail intergrated xp sp3 from microsoft. I wiped the hard drive by f disking it so nothing was left on the hard drive.

I installed windows xp sp3 from scatch. What I found out later was the daylight savings time was the old daylight savings

time installed! Did I miss something with microsofts hot fix list. The windows xp sp3 was the intergrated version from

Microsoft! Microsft made this version!!! Because I noticed that the daylight savings time was not in the microsoft version

of windows xp with sp3, I decided to slipstream this hotfix into xp sp3. Than, I wiped the hard drive and re installed

the operating system. Did I read the hot fix list wrong? Please let me know!


Please let me know what I read wrong about sp3 hot fix list. It looks as though you have looked at the same one as I did
from Micrososft website for sp3! What did I read wrong or interpret wrong?

Again, Please let me know.


thesunnytexas





------------------------------------
Reply:

I make no statement one way or another about the Hotfix list for SP3, and I can't really help you with that.  All I know is that the "December 2007 cumulative time zone update for Microsoft Windows operating systems" KB942763 for Windows XP was silently re-released on April 21st, incorporating update files for both SP2 and SP3.  The version string for the SP3 version of tzchange.exe is "5.1.2600.5570 (xpsp_sp3_gdr.080327-1253)", and you are up to date if you have this version.  The KB942763 article text has not caught up with these new file dates and versions.

 

This means that KB942763 is now a fully-fledged post-SP3 hotfix - but it is not yet being offered by Windows Update.


------------------------------------
Reply:

Hi rdhw,

Thank You so much for clarifying this hot fix. KB94273 daylight savings time is a post sp3 fix! And, yes I know that Microsoft was going to release a post sp3 hot fix because they told us sp3 beta testers they would release it. I just hope folks know
this is a post sp3 hot fix. The hot fix list from Microsoft is deceptive:

http://support.microsoft.com/kb/946480


The statement from Microsoft states:

"Fix list

The following fix list includes only the updates that were added in Windows XP SP3. For more information about the updates that are included in previous Windows XP service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:........"

What Microsoft actual did was made this hotfix KB94273 able to install in SP3! SP3 doesn't actually update the time zones

and daylight savings time! This is where it is deceptive! Now look at their statement above.

Microsoft needs to clarify this to everyone!

Again, Thank You your help - rdhw


thesunnytexas

------------------------------------

Problem in SP3 is driver incompatability

XP3 installed itself in during an auto update by windows update, had to have been installed that way because I did not do it manually; the next morning XP began to act very erratic Zone Alarm Suite quit working saying my subscription had expired and I was no longer able to use IE7; I had internet access for email however with IE7 it would load but I could not access any sites.

 

I uninstalled ZA which was not a big deal as ZA has become, since bought out by whoever it was who bought them, being not as stable, a system resource hog and quite a bloated piece of software. I installed Comodo and a couple other firewalls and other virus software like Avast and no matter what I did the same thing happened. Please note that I wasn't even aware at that pont that SP3 had been installed, the end result of all of this is the system going into a loop rebooting itself repeatedly and I couldn't even get into safe mode to try system restore.

 

I finally ended up doing a reformat and reinstall of XP which believe me I did not want to do because reinstallng everything would take days but I had no other choice. I did the reinstall and everything seemed to be working fine so I started installng software testing my connection after each install. I reached a comfort point to where I stopped checking the connection after each install and eventually the system started doing the same thing but at least it did not go into a re-boot loop as before.

 

I threw my hands up in the air and did another reinstall and this time I checked my internet connection and web access through IE7 after each software and driver install and discovered that after installing drivers for my Logitech Qucik Cam Communicate I no longer had internet access through IE7, everything else on the system needing internet access worked fine, just not IE7.

 

I uninstalled the Logitech software and driver and now the system is working normally, actually better than before. My take on the SP3 issue is that there is an incompatablity in SP3 with some drivers; the Logitech drivers and software I installed were the most recent from Logitech's website so it wasn't an old driver issue.

 

This is really a problem for me as I video conference with my office in Europe several times a week and short of buying a new web-cam that may still have the same driver problem I am screwed as far as video conferencing goes. I am going to contact Logitech about this but since this is a holdiay weekend they won't be available until Tuesday.. Oh well, no video conferencing for me.

 

 

Keyboard restrictions.....

 

Great product - It's exactly what I've been looking for - just have one questions or suggestion. How about a way

to disable "Ctrl, Alt, Del" or make it password protected.  We have a kiosk in our museum that just plays videos

and allows for visitor comments - I wrote the program in VB. I'd love a way to completely disable the Windows

key and "Ctrl Alt Del"

 

 


Reply:

 

Thank you for your suggestions. Currently, there is no such settings in SteadyState and I will forward the thread to our product team and see if the function can be added in the future version. Thank you.


------------------------------------
Reply:
That sounds like a good idea. Only thing is, for the rest of us, how would you turn off the pc at the end of the day, short of just pulling the plug or holding in the power button? Of course, some folks do know about holding the power button in, aren't you afraid of them shutting it off doug?

Just curious

------------------------------------
Reply:

 

In our case it wouldn't be an issue.  The computer for the kiosk is hidden in a locked base.  If Ctrl Alt Del was password

protected it would a better option than disabling it completely.  I'm really hoping they add this as an option - I could have

used it numerous times in the last year!


------------------------------------
Reply:
Sean, password protected ctrl alt del sounds great. if the team can consider that and also password-protect/disable Alt-F4, that would be swell.

kat

------------------------------------

SCE install will never fail if you follow this procedure

 

hi guess what guys i found solution to this error ... heres what you do..

 

if you have any previous install of sql backup and remove start freshinstall of sql or even upgrade will do too.

1.install SQL2005 standard you purchased with SCE2007

2.Install SQL2005 SP1

3.Install SQL2005 SP2

4.open IIS remove any SSL port in default website properties and start default website.

5.open browser http://<server name>/reportserver it must show something

6.If it shows up then begin installation of SCE2007

7.it will detect local sql instance selece and will also not give this error..

 

if you have not purchase sql still start default web site.. this will help sce coniguring report service..

 

enjoy guys...

 

Imran

Network Administrator

immi_im@hotmail.com


Reply:
Hi Imran,

Thanks for your sharing.

--------------------
Regards,
Eric Zhang




------------------------------------

My experience deploying Exchange 2007 sp1 on Windows 2008 server

 

Hi all,

 

This is a brief description of a 15-hours deployment project.

 

- A single-server site, AD running under Windows 2000 sp4, no exchange previously installed.

- One new HP ML 370 G5 Windows 2008 server with exchange 2007 sp1.

- Tried upgrading the 2000 DC server to 2008; failed (I know...major lack of preparation here)

- Windows 2000 server is not ACPI

- Tried 6 times to put 2000 server ACPI (BSOD one after the other)

- Took 3 tries to upgrade 2000 server to 2003 standard R2 (still not ACPI)

- Raised forest-functionnal level

- Joined Windows 2008 to Domain as standalone server

- Forestprep and Domainprep on Windows 2008 before starting installtion of Exchange 2007

- Ran numerous commands to upgrade the schema

- Setup failed: need to install IIS (complete)

- Setup took 30 mins and was a success.

 

Basically my first idea was to upgrade my Windows 2000 server to Windows 2008, since my exchange 2007 is running on a Windows 2008. I can't emphasize enough on the importance of having a fully-fonctionnal backup because I had to re-install my system partition on my Windows 2000 server almost 5 times during the process because I just couldn't fix my ACPI problem (that's another...scary story). Once I got my 2000 server to 2003, I was able to install my exchange 2007 on my standalone 2008 server.

 

Monday I'll be spending a lot of time configuring and "discovering" exchange 2007. I have experience managing 5.5, 2000, 2003 exchange..but at first glance...the GUI is quite different. I'm glad my customer didn't have a server running a previous version of exchange, they still use pop3 accounts from their ISP provider. I will gradually connect users to the exchange server and configure pop3 connectors.

 

So if you ask me: deploying exchange 2007 took longer than what I expected, mostly because of the windows 2000 server I had to upgrade. But so far, my 2003 std r2 DC runs fine and my 2008 standalone with exchange 2007 sp1 looks pretty neat. I just wished the upgrade path would have been easier.

 


Reply:

Thank you for your sharing.

 

Jason


------------------------------------

Windows vista sp1

 

Vista sp1 is a real dissapointment  .......

Reply:

Spydersplace

 

Since there is no question in your post, you need to mark it as a Comment.

 

Thanks.

 



Ronnie Vernon
Microsoft MVP
Windows Desktop Experience

------------------------------------

Could not login at Welcome screen after resume

I'm glad to be off of SP3...I unwittingly installed as part of automatic update and this week has been a disaster. I could login at start up but on resume after screen saver it would deny me access using the same password and I'd have to reboot. Also, I'm an admin on this machine and I lost access to SQL Server that I have running locally. Tried to reinstall SQL Server before I knew it was an SP3 issue and reinstall failed - bad security.dll file. Finally, I lost authorization to see http:\\localhost... anyway, I just uninstalled and everything is good again.

Hyper-V and DHCP....Careful!

 

Just thought I would leave this here so if anyone else has the same issue. I was working on Hyper-V installed on a Server 08 (Host) remotely using Windows remote desktop connection. I installed on the guest OS of Hyper - V Win2K3 and installed a DHCP Server to play with in my virtual environment. I had an internal connection setup between the other guest OS as well that were all in a domain together. The next day, I had problems logging into the Host (Win2K8). Turns out, the internal connection was wreaking havoc with logins, and trying to pull an IP from the guest OS, which was running. The fix: Use a private network connection with Hyper-V (I had internal so I could try and pull updates; never got to see if it would work though) to connect the guest OS's together.  Very strange.....hope this helps!

 

Question: I've never played with virtual environments so, does this happen with Virtual Server 05?


Reply:

This would happen to any virtual environment when the Host is using DHCP.

 

All that you did was create a rogue DHCP server on a virtual network.  You Hyper-V host was configured to use DHCP and this 'rogue' DHCP server VM was answering first, so it was winning when your Hyper-V server was renewing is DHCP lease.

 

This is not the fault of Hyper-V.  This is the behavior of DHCP and is a complication to a machine being able to 'see' more than one DHCP server at a time.

 

You resolved the situation properly for your configuration.

 

 

 


------------------------------------
Reply:

Just as a general caveat... and I'm sort of glad Hyper-V does have containment rules (of a fashion) when you bind NIC's, try to ensure that you operate on a per NIC per subnet per broadcast domain basis... yes there are VLAN's there for you to use but it's very easy to abuse the networking options there on offer  

 

Regards,

Mylo

 


------------------------------------

In Place upgrade and Rename of Win2k CA and IAS

If I were to perform an in-place upgrade of a win2k dc to 2003 then to 2008 and then rename it would i lose the functioanlity of the RADIUS/IAS and CA services that are running on it currently?
  • Changed type Miles Li Thursday, June 5, 2008 10:18 AM to comment
  • Changed type Miles Li Thursday, June 5, 2008 10:18 AM to comment

Reply:

You cannot rename a CA, so you would lose that functionality.

 

The upgrade path would work though, to say something positive.

 


------------------------------------
Reply:
Just to confirm then the CA will stop working when the computer name is changed but the IAS and RADIUS will continue to function with an upgrade from 2000 to 2003 and then from 2003 to 2008 even with a name change and the change from IAS to NPS? I am pretty sure I understand settings will be migrated from 2003 ias into 2008 nps but i want to ensure a name change along the way will not have a drastic impact.

Thanks again.

------------------------------------
Reply:
IAS/Radius will need a certificate so a qualified guess is that you'll loose that functionality too. I'd try this in a lab environment before doing it in production. Can anyone from MSFT clarify this issue?

 


------------------------------------
Reply:
I didn't think of that. :-(  Thanks!

------------------------------------

Tips on Launching Webpage

 

Hi all...

would like to share a piece of info that i followed.

To have shortcut in start menu which launches a webpage(eg www.google.com) from sequenced app...

i created a .bat file eg "Launch.bat" and put this in that "start www.google.com"

Plcae this "Launch.bat" file in Q:\ and create shortcut for it with whatever icon using Application wizard.

 

When we launch this a cmd prompt opens and then the webpage is launched.

To supress the cmd i used a jscript as follows..

 

var WindowStyle_Hidden = 0
var objShell = WScript.CreateObject("WScript.Shell")
var result = objShell.Run("cmd.exe /c Launch.bat", WindowStyle_Hidden)

 

save this .js(eg Launch.js) file, and place both of these Launch.bat and Launch.js in same folder in Q:\

and point the shortcut to "Launch.js" with proper icon....the webpage launches without the cmd prompt.

 

happy Sequencing!

 


Reply:
Why not while sequencing just create a shortcut to iexplorer.exe with the website as the parameter or just a .url shortcut directly to the website?

Just create a new text file, rename it to a .url extension, put it where you want your shortcut to end up and write the following in it:
Code Snippet

[InternetShortcut]
URL=http://google.com



------------------------------------
Reply:

Indeed i do prefer using the parameter for a url and pointing to local IE.

 

Just be careful to clean up your packages http://blogs.technet.com/virtualworld/archive/2007/12/18/virtual-internet-explorers-virtual-homepage.aspx 

 

However .....and most importantly, i think your both wrong with the homepage..... should'nt it be http://www.live.com  

 

All the best

JZ

http://blogs.technet.com/virtualworld

 


------------------------------------

These forums should NOT be the Default place one ends up at

Until the proper stuctures are in place to support the old forum content this is NOT the place one should end up by clicking on Forums.
It might look great but there is less than 0 content here.

Before this gets close to being the default you need to have al least some of the forums even if you abandon the content from the old site.

I am more than a little frustrated by what appears to me to be an abandoning of the old forum content good and bad alike.  I personally spent hours helping people on that old site and I think it is a slap in the face to have my help abandoned in a graveyard forum that "might be ported over some time this year" and to have my contribution set to 0.

If you are going to abandon the old content why not just close these forums altegther as it appears plain to me how much you value the contributions that members make.

Reply:

Appreciate the feedback. We're definitely not abandoning all the great content on the old platform. More details in an annoucement I just posted. It's going to take some time to get everything brought over (months), but we are moving to make it happen as quickly as possible. 

What link to forums did you click that took you here?

Also, we're making sure all points migrate from the old platform. They'll come over on a per forum basis, but as the forums move all the points you've accumulated will come with you.

-Andrew


Forums Product Planner, Andrew.Brenner at Microsoft.com

------------------------------------
Reply:
Thanks for the reply.  I'm relieved that the old content will not be abandoned.

From the main MSDN site (http://msdn.microsoft.com/en-us/default.aspx)
If you go down to the "Get Involved" section and click on "MSDN Forums" you come here.

If you are lucky, the rotating list of "Featurured forums" does point back to the old content.  If you don't see your favorite forum featured or even worse you see the list of top contributors then there is no way to reach the old forums.

I understand that there is a catch 22 on what "MSDN Forums" should link to while the content is being migrated.  It seems to me though as there is nothing but a test forum here that this is not (currently) the right place to point to.

As you migrate the content I think you really need two links.  One to the old forum and one to the new.

I personal vote would be to replace the "Code Gallery" section with a section highlighting (and linking to) the old forums and a brief explaination of where you are in the migration process.

------------------------------------
Reply:
The forums link has been updated. (I also made a similar change to the TechNet forums link.) Thanks for the suggestion.

------------------------------------

Found a bug with Service Pack 3

I am setting up a fresh XP install at work and was downloading updates from Microsoft Update.  I decided to use this new build to test the Service Pack 3 for our environment.  I had downloaded Service Pack 3 and left the PC alone for a few days.  I then ran update again to check again for updates.  Everytime I tried to install:

Malicious Software Removal Tool (KB890830)
Security Update for Flash Player (KB923789)
XP withe Media Format Runtime 9 (KB94159)
Internet Explorer 7

I kept getting errors and failed installs.  Everytime I reviewed the updates to install, I was shown 0 MB files.  I then uninstalled Service Pack 3 and the above updates were installed with no issues. 

Has anyone else noticed this bug?

HostedTech

Reply:
Try a "regsvr32 wups2.dll" under "Run" in the Start menu.
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2880997&SiteID=17 mentions the reasons for the issue and yes, MS did NOT include WUA 3.0 in SP3 for whichever lousy reason.

Bye,
Freudi

------------------------------------

windows cannot connect to the printer the local print spooler service is not running please restart the spooler or restart the m

When trying to Add a Printer on Vista, I got the error message " windows cannot connect to the printer the local print spooler service is not running please restart the spooler or restart the machine"
The following steps worked for me:
1. Go To Run and type " services.msc" Hit Enter.
2. Click Accept on the User Account Control Box tha pops up
3. On the new Window, scroll down the list and double click on Print Spooler.
4. Under the Startup Tab make sure Startup Type is set to Automatic
5. Under the Startp tab, under Service Status, click on Started.
6.
Under the tab Log On, make sure The Local System Account is checked and box next to Allow Service to Interact with Desktop is checked.
7. Click Apply and OK
8. Close the Services window
9. Go To Network, and Add a Printer. And Click on Add a Network Printer. Whn you Printer shows up, follow the usual steps.

Hope this works for you



Reply:

Hi,

 

We convert this post type from "Question" to "Comment". Thanks for sharing your expereince here!

 

Regards,

Lionel Chen


------------------------------------

No comments:

Post a Comment

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...