Readers and Webmasters

Symptoms
Source: Microsoft Support
Resolution
RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION.THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

Symptoms
You can use the SHUTDOWN method for the SQL Distributed Management Objects (SQL-DMO) server object to shut down the SQL Server service. The following message is sent back to SQL-DMO from the SQL Server server:

Server shut down by request.
SQL Server is terminating this processSQL-DMO treats this as an error condition. However, SQL-DMO should not treat this as an error condition because shutting down SQL Server is the expected result. If you do not handle this error condition in the Microsoft Visual Basic application, the standard error message dialog box opens. After you acknowledge the error message, the application terminates immediately, which may not be behavior you expect and may also produce unfavorable results.
Another error message that might occur is:

Error number: -2147215802
Error source: Microsoft SQL-DMO (ODBC SQLState: 01000)
Resolution
By adhering to good programming practices and making sure that error conditions are handled within the Visual Basic code, you can prevent the unexpected termination of the application. Additionally, even after the error condition is handled, the SQL-DMO SQL Server object is still connected to the SQL Server server that shut down. Thus, it is necessary to run the Disconnect method if you want to reuse the object. If you do not need the object, to release the object you can set the object to Nothing.
Here is an example:

On Error GoTo errHandlerSet oSQLServer = New SQLDMO.SQLServeroSQLServer.LoginSecure = TrueoSQLServer.Connect’ Need to connect to SQL Server firstoSQLServer.Shutdown’ Execute shutdownoSQLServer.DisConnect’ Disconnect from SQL Server if object is to be reused:’ Rest of code. Without error handling, application will not get here:Set oSQLServer = Nothing’DoneerrHandler::’ Error handler

Symptoms
When you use thePush method in Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) or SQL Server 2005 CompactEdition Remote Data Access (RDA) to transfer data from a SQL Server CE or SQL Server 2005 CompactEdition database table to aremote SQL Serverdatabasetable, the data transfer may fail.This problem may occur if all the following conditions are true:The destination table in the remoteSQL Server database contains one or more columns that are defined as NOT NULL.The SQL Server CE database table contains rows withan empty string or with space values for columns that correspond to the NOT NULL columns on the destination table.
Ifa row with an empty string or with space values is inserted in the destination table, you may noticeNULL values in the nullable columns.
You may not notice this behavior when you use replication to transfer data between a SQL Server CE or SQL Server 2005 CompactEdition database and a SQL Server database.
Note This problem does not occur in Microsoft SQL Server 2000 Windows CE version 1.1.
Resolution
The Push method in SQL Server CE RDA or in SQL Server 2005 CompactEdition RDA treats empty string or space values as NULL values.

Ever wondered what site maps are for?

In any internet marketing endeavor, the best thing to do is to maintain a good linkage and to always stay indexed. There many ways available to you online to have your web site indexed and spidered. Using HTML site maps is a way you can utilize to make sure that your site is up to date in the internet and search engine database.

What is a site map?

A site map is basically a function or Web links, your site is listed there. This will make it easier to search engine spiders to your site. It is usually found in a site near the bottom of the page.

Why are site maps important?

An HTML site map is important. It should contain the top level pages. In one page, there should be just about the right amount of links in it. The link should not exceed 100 for more favorable views.

A certain degree of welfare of a good HTML sites. This is usually be released to any potential customers can easily navigate the site, find exactly what they are looking for. The site map page will become a tool for your visitors. In this way, they would choose to visit your site, if they can easily browse and find the way to your site. It can also ensure that your visitors can very well stay in your site.

Good links will also ensure you that spiders will locate your web site easily each week. This will make your site indexed by the important search engines online. This will also avoid your site from being dropped.

However, HTML site maps may serve more important purpose than merely as another link to click on. The specific purpose you should consider in having a site map is to make it easier for search engine robots to ‘crawl’ in your web site. Pages are located by search engines through ‘crawling.’ It is a process that goes through the index of a page, following the links and adding the pages to the database.

When a problem comes not fail to find the page are links to access the search engine. This is a site map to tackle this dilemma. Your search engine home page, follow the Site Map, Web site only gives you access to different links.

Here are some important pointers in creating your HTML site map.
1.?? ?Get tutorials on how to make your site map. There are available pages online that can give you a step-by-step guide in coming up with a good website.

2.?? ?You can also ensure that your site map looks good, to make it more pleasing to the eye of your visitor and to make navigation easier. You can get ideas for a properly designed site map online too.

3. Make sure that your site map and links to important pages on your Web Site. That way your visitors do not know will be lost. At the same time, you can ensure that your guests are still able to get the general idea of your site structure. It is advisable that you left as simple as possible.

4.?? ?Make the link to your site map as visible and obvious as possible in your homepage. Visitors should not spend too much time in locating it or else you might end up losing them.

5.?? ?A site map serves more like a table of contents of your website. It should provide all of the different sections of your internet site with all the information and data that may be found in each section.

6.?? ?Each of the contents in your site map must have a hyperlink to its respective URL.

7.?? ?If you will have to give way to numerous links, you can make use of several pages. You could numbers each site-map page or you could also make use of the contents in naming each site-map.

After an HTML site map will also help you maximize the traffic to your website. Just make sure that your homepage and all internal pages are properly indexed. Create a site map will definitely things more efficient for you. The links to all pages of your site will be connected directly to your homepage.

A lofty goal for your Internet marketing efforts. The more links you have on your site, the higher is the chance to get a good place among the major search engines, so do not hesitate to learn the rules of the game and make yourself a sure winner.

Symptoms
When you perform stress tests on a Windows Server 2008 system that has the Hyper-V role installed, the system may stop responding or hang.
Resolution
A thread on one processorowns a network device interface specification (NDIS) Read lock or Write lock. This thread waits for a spinlock. However,a thread on a second processor owns the spinlock, and this threadwaits for the same NDIS Read lock or Write lock that is owned by thethread on the first processor. This creates a deadlock situation. Therefore the computer stops responding.

Symptoms
In some cases, collections defined at a parent site do not appear in the collection hierarchy of a child site. A symptom of this problem is the generation of status message “2528.” This status message defines which collection (or subcollection) is causing the problem. After the collection has been identified, you may find that one or more of the .psd files, which are pending in the SMS\INBOXES\Colleval.box file for the collection, are experiencing problems.
Resolution
This problem typically occurs when defining a subcollection. When you add this new subcollection, the parent collection (including the new subcollection) must be copied down to the child site. This is because the addition of a subcollection is considered a change to the parent collection.
When the collections are received at the child site, the new subcollection is saved, but the parent is not. The parent site then checks to make sure that each of its children exist in the database. Child sites that do not exist in the database are placed back in the queue for reprocessing at a later time.