Posts Tagged SQL Server

SuzanneHow to resolve the error 2537 in SQL Server 2000?

Wednesday, May 19th, 2010

While mounting the database, it could be frustrating to view an error message, which not only results in unmountability of the database, but also in inaccessibility of database records. Such error messages can be caused due to database corruption. Some of the few main reasons responsible for database corruption are metadata structure damage, network issues, hardware malfunction, improper system shutdown, and virus infections.

In order to overcome such error messages, the database administrator needs to run an inbuilt repair utility named ‘DBCC CHECKDB’. While this command is competent enough to repair a damaged SQL Server 2000 database, it might also result in loss of data from the database. To prevent any such data loss situation from occurring, you will need to repair the database by using a powerful MDF Database Repair application.

Lets consider a real-time scenario where you encounter a severity level 16 error message while trying to mount your SQL Server 2000 database:

“Table error: Object ID O_ID, index ID I_ID, page P_ID, row ROW_ID. Record check (CHECK_TEXT) failed. Values are VALUE1 and VALUE2.”

Once the above error message flashes on the screen, the database records become inaccessible.

Reason:

Two main reasons liable for the occurrence of 2537 error message are discussed underneath:

  • A condition specified in the CHECK_TEXT statement could not be fulfilled.
  • The database table is logically or physically damaged.

Tips to Resolve:

To get past the above error message, an easy way is to restore the database from an updated backup. However, if in case backup is not available, and then repair the database using following steps:

  • In case the SQL Server 2000 database table is physically damaged, and then replace the physically damaged component with a new component. To determine the component that is physically damaged, check the system logs.
  • In case the SQL Server 2000 database table is logically corrupted, then run DBCC CHECKDB command with a suitable repair clause. While doing so, the logical corruption can be resolved, but it might also result in loss of data. To ignore such data loss situations, it is advisable to repair the database using a commercial MDF Repair application. Such MDF File Repair tools are totally non-destructive and keep the original file untouched while repairing.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , ,
Posted in Database, Purely Technical | No Comments »

NaggieDBCC CHECKDB unable to resolve SQL Database corruption

Thursday, April 22nd, 2010

The logical and physical integrity of all SQL Server database tables is performed by DBCC CHECKDB command. The command performs and divides its operations in three different phases.

The first phase checks the consistency of the allocation structures in disk space, the second phase checks the integrity of all pages and their structures, and the last phase checks the catalog consistency.

If critical errors are found in any of the phases, the DBCC CHECKDB command terminates immediately. This happens when the SQL Server database is badly corrupted, and is beyond the repairing capabilities of DBCC CHECKDB command. In such cases, if you need to access the database records, then you will need to restore the database records from a valid backup. But, if no backup is available or backup falls short to restore the required amount of data, then you will need to repair the database by using advanced MS SQL Server Recovery application.

Let’s consider a practical scenario, where you receive the below error message when you attempt to access one of your table records-

Table error: Object ID O_ID1, index ID I_ID1 cross-object chain linkage. Page P_ID1 points to P_ID2 in object IDO_ID2, index ID I_ID2.

The above error message primarily results in inaccessibility of all the table records. Additionally, the error message pops up every time you attempt to access the table records.

Cause: Reason of error

The above table error message occurs when the next page pointer of P_ID1 page points to different object. This can happen either due to logical corruption factors or physical crash of a system component.

Resolution: Steps to be used to resolve the above error message

Database table corruption, if caused due to physical damage, can be resolved by changing the damaged system component. For logical table corruption reasons, run DBCC CHECKDB command with appropriate repair clause.

While the physical corruption issues can be resolved easily changing the system component, the probability of logical corruption problems being resolved by DBCC CHECKDB command is slightly less. In such cases, you will need to use advanced Recovery application to repair the database table. A SQL Repair software can be easily downloaded from Internet.

Source: www.programmersheaven.com

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , ,
Posted in Purely Technical | No Comments »

NaggieOpenOffice.org Releases Version 3.2

Saturday, February 13th, 2010

openof11 OpenOffice.org Releases Version 3.2

On Thursday, the organization announced that OpenOffice 3.2 is now available for download.

The latest version of the productivity suite- which is intended to be an open-source alternative to Microsoft Office- boasts faster start-up times, ODF support, proprietary file support, support for postscript-based OpenType fonts, and more.

The release comes after OpenOffice.org hit a milestone of 300 million downloads over the course of its 10-year history, 100 million of which occurred from the organization’s main Web site.

The suite includes basic components like word processor, spreadsheet, presentation, graphics, and formula and database capabilities. Improvements to those components the version 3.2 boasts, including the Calc spreadsheet. The Chart module, meanwhile, received a “usability makeover” and includes new chart types.

Some people are currently locked in to other personal productivity tools – maybe by corporate IT policy, or by tie-in to other legacy software. For everyone else, we want OpenOffice.org to be the 2010 office software of choice, and 3.2 takes us another step towards that goal,” said Florian Effenberger, marketing project lead of OpenOffice.org.

Version 3.2 is available for download on the organization’s Web site.

Tags: , , , , , , , , , , , ,
Posted in Linux Technology, Opensource, Technical News | No Comments »

NaggieOpera Develops Mini Browser for Apple’s iPhone

Saturday, February 13th, 2010

Opera announced to release it’s newly developed version of its Opera Mini web browser for Apple’s iPhone, which will be demonstrated at the Mobile World Conference in Barcelona, Spain.

The cofounder of Opera Software, Jon von Tetzchner said he is “thrilled” to offer the preview and added that the software provides a “fast, feature-rich” experience for iPhone users. Opera on the iPhone brings the company “one step closer” to its mission of “bringing the web to the world”.

Will Apple Approve?

However, the big question is whether Apple will approve Opera as an iPhone application on its App Store. Apple currently only accepts browsers that run on the WebKit engine — the same engine that powers Apple’s Safari browser.

But Apple has gotten into hot water with the Federal Trade Commission over its initial refusal to certify Voice over Internet Protocol applications, Rob Enderle, principal analyst with the Enderle Group, noted. This time around, Apple will be hard-pressed to exclude competitors.

Enderle said, Given Apple is under FTC review for their application approval process, I don’t think they can refuse this application — but they could break it or limit its capability. “For instance, both the ARM processor and the Opera browser support flash on other platforms, but Apple will likely make sure Flash doesn’t work on Opera any better than it does on Safari on the iPhone.”

“Changing defaults will likely be difficult as well,” Enderle added, “so that it is the Safari browser that opens when you click on a link. If Opera gets on the phone, it is likely that [Google's] Chrome will soon follow, and Apple will do whatever it can to make sure that never happens.”

Advanced Features

Currently, Opera Mini 5 in beta boasts quite a few advanced features over Safari, including tabbed browsing so users can view several sites simultaneously and “easily jump from one to another,” the company said. Another feature is Speed Dial, a display of frequently used pages so users can launch a favorite site with just one click, a feature Safari and Chrome offer in desktop versions but not on smartphones. There’s also Opera Link, which synchronizes bookmarks and Speed Dial between the user’s mobile phone and desktop computer, and Download Manager, which manages downloads from the browser.

According to Opera, its browser offers an intuitive, easy-to-user interface, and is much faster than other browsers because it compresses web pages as much as 90 percent before downloading. Other features include adaptive zoom, in-page searching, landscape mode, and kinetic scrolling.

A senior research analyst at IDC, Raman Llamas said, Opera has a great browser and offers a great experience.

Lucky in 2010?

In 2008, von Tetzchner told The New York Times that Opera had started work on an iPhone version of Opera but stopped development because of Apple’s restrictive developer agreements. Apple initially banned all third-party browsers but finally allowed other browsers based on WebKit.

Around this time, von Tetzchner clearly feels he will have more luck with Apple. Indeed, given that Opera is making a big deal about the availability of Opera Mini 5 for iPhone, Opera may have already received Apple’s blessing.

According to Christen Krogh, Opera’s chief development officer, Opera Mini is compatible with every requirement for the App Store. Krogh also said, there aren’t any identical applications on the iPhone, discounting Safari as an identical application. Opera Mini is a different kind of browser, so we cannot see any conflict with any requirements in the App Store.

Krogh said Opera hasn’t yet submitted the application to the App Store. “We’re comfortable enough [with] where Opera Mini is at to show it to select partners and journalists,” he said. “It won’t take long before we’re ready to submit it to the App Store.”

Tags: , , , , , , , , , , ,
Posted in New Product Release, Opensource, Technical News | No Comments »

NaggieOpera Mini: 5 Reasons iPhone Owners Need It

Thursday, February 11th, 2010

For the iPhone, Opera has announced plans to release the Opera Mire mobile Web browser, and plans to show it off during Mobile World Congress next week. The early announcement is meant to generate excitement, therefore pressuring Apple into approving this threat to its native Safari browser.

Anyway, not a big deal see the Opera Mini simulator, or check out these five reasons Opera Mini could become your favorite iPhone Web browser, if Apple approves it:

Super Speed

According to claim made by Opera, its mobile Web browser can cut the iPhone’s Web data traffic by 90 percent, thanks to a method of compressing images and text on its own servers. This would, of course, improve the loading time of Web pages as well.

Home Page

Forget loading up a new browser window with nothing in it. Opera Mini’s “Speed Dial” features lets you customize a grid of nine favorite Web sites for quick loading without visiting your list of bookmarks.

Find in Page

The searching inability within a Web page for text is Safari’s most glaring omission. In Opera Mini, it’s as simple as clicking the Tools icon, then clicking “Find in Page” and typing whatever you’re looking for. Sorry Apple, sometimes Web pages just need to be searched.

Greater Flexibility

Here are some other things you can’t do in Safari, all of which can be controlled or enabled in Opera Mini’s settings menu: Saved passwords, adjustable image quality, full screen browsing, adjustable font sizes and customizable skins.

Free, Presumably

Experts of iPhone might point out that there are already plenty of other browsers to choose from, but the vast majority of them cost money. Opera Mini is a free download for other phones, so I assume it’ll be free if Apple approves it for the iPhone. That alone could make it the most attractive Safari alternative yet.

Tags: , , , , , , , ,
Posted in Expert's Opinions, Technical News | No Comments »

NaggieGoogle launches Chinese holiday travel map amid row

Wednesday, February 3rd, 2010

A map search service has been launched by Google in China for travelers taking trips during the Lunar New Year holiday season, despite a row over cyber attacks and censorship.

According to a spokeswoman for Google China, Marsha Wang, the service is available online now. The Google Spring Festival Map is based on the company’s regular map service but has “more features” targeting users’ special needs during this month’s holiday, the busiest travel period of the year in China, she said.

The statement posted on googlechinablog.com said, the special map provides information including real-time flight status, train schedules and ticket prices, highway conditions and weather updates.

The government estimates says that about 240 million people are expected to crowd China’s trains and planes for the holiday.

Chinese traditionally return to their home towns and villages for family reunions with this year’s travel period stretching from January 30 to March 10. The Lunar New Year falls on February 14.

Last month, Google threatened to abandon its Chinese-language search engine google.cn, and perhaps end all operations in the country, following hack attacks it says targeted the email accounts of Chinese human rights activists. It has also said it is no longer willing to bow to Beijing’s army of Internet censors — and will stop filtering search results soon, a move China says would violate its laws.

The US and Chinese officials have discussed the issue at length, with US Secretary of State Hillary Clinton qualifying her latest talks with Chinese Foreign Minister Yang Jiechi as “open and candid.” But the row is one of an ever-increasing list of issues threatening relations between the United States and China.

Google chief executive Eric Schmidt reiterated last week at the World Economic Forum in Davos that the Internet giant wanted to stay in China, but also said he hoped censorship rules would change.

According to Wang, it was “business as usual” at Google China’s headquarters in Beijing.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , , , , , ,
Posted in Expert's Opinions, Technical News | No Comments »

NaggieChina Tablet PC Maker May Sue Apple Over IPad Design

Monday, February 1st, 2010

ipad touch cover China Tablet PC Maker May Sue Apple Over IPad Design

A Chinese company, selling a tablet PC like Apple’s newly announced iPad, may sue the US Company over the similar design between the devices, said the company Monday.

Last Year, Shenzhen Great Loong Brother Industrial started selling its P88 tablet and is not ruling out a lawsuit against Apple, a company representative surnamed Wu said by phone.

The company is based in a southern Chinese city known for producing knock-off phones, which are called “shanzhai,” or “bandit” phones, and sometimes takes the form of counterfeit iPhones or other popular handsets.

According to Wu, we are not shanzhai for these things, because we were first.

The P88 weighs more than the iPad and has much shorter battery life at just over one hour during active use, compared to Apple’s stated battery life of 10 hours for the iPad. But both devices use touchscreens that have a black border and a similar size, at 10.2 inches for the P88 and 9.7 inches for the iPad. Wu said his company’s tablet is sold in the U.S., but declined to say at which outlets.

No immediate comment was returned from an Apple’s spokeswoman.

China’s gray market for electronic devices also reacted quickly to Apple’s announcement of the iPad last week. Some users on Taobao.com, a Chinese auction and retail site, are taking pre-orders for iPads they will first obtain in Hong Kong or elsewhere. Popular devices such as the iPhone or the Hero from Taiwan’s High Tech Computer (HTC) are often brought into China informally and sold there online or at electronics bazaars.

Apple has not yet cleared that if the iPad will be sold in China. Local carrier China Unicom started selling the iPhone last year, but gray-market versions of the device were already widely sold in China.

And according to Japanese electronics company Fujitsu, it owns the rights to the name “iPad,” raising another possible legal challenge for the Apple device.

http://www.all1martpro.com

http://www.all1sourcetech.com

Tags: , , , , , , , , , , , , ,
Posted in Technical News | No Comments »

NaggieWindows Service applications

Wednesday, January 27th, 2010

Windows Service applications are long-running applications that are ideal for use in server environments. The applications do not have a user interface or produce any visual output. Any user messages are typically written to the Windows Event Log. Services can be automatically started when the computer is booted. They do not require a logged in user in order to execute and can run under the context of any user including the system. Windows Services are controlled through the Service Control Manager where they can be stopped, paused, and started as needed.

Windows Services, formerly NT Services, were introduced as a part of the Windows NT operating system. They are not available on Windows 9x and Windows Me. You need to use one of the operating systems in the NT generation such as Windows NT, Windows 2000 Professional, or Windows 2000 Server to run a Windows Service. Examples of Windows Services are server products such as Microsoft Exchange, SQL Server, and other applications such as Windows Time that sets the computer clock.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , ,
Posted in Company Activity, Opensource | No Comments »