Posts Tagged SQL Database Services

LolaTheriotHow 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

BobbyeM71hxwDBCC 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

BobbyeM71hxwSonne DVD Burner v4.1.0.2036

Tuesday, February 16th, 2010

Sonne DVD Burner is an almighty DVD burner designed to meet all your needs in burning video, ISO Image file and VIDEO_TS to DVD disc and burning all files to data disc, creating DVD from other video files. For the more, it can capture videos to burn or create to DVD. It s necessary to add an intact capture function to meet users need. Users can easily capture video or image from other devices, DV and TV Tuner. Auto shot, overlay, audio settings volume and balance can be adjusted by easy to use buttons… [/center]

Key Function:

  • Create a DVD disc with DVD menu.
  • Capture video or image from other devices like USB webcams, TV tuner and DV in real time.
  • Snapshot pictures with hotkeys.
  • Set properties for each capture device.
  • Burn data to disc.
  • Burn DVD (VIDEO_TS) folders to DVD disc.
  • Burn video files to DVD disc without menu.
  • Show information about recorder.

How to Create DVD

Sonne DVD Burner can let you directly create DVD from other video files.

  • Step 1: Define the desired DVD mode as pagination menu or chapters menu.
  • Step 2: Define a template for your DVD from the template list.
  • Step 3: Input your desired video files.
  • Step 4: Click Create button, a dialog will pop up. You can define the DVD Output Path as your like. Start the process with Start button.
  • Step 5: Click Burn button to burn the newly created DVD folder or others, relative settings interface will pop up.
  • Step 6: Click Start to start burning.

Tags: , , , , , , , , ,
Posted in New Product Release, Technical News

BobbyeM71hxwLG, Samsung Go Social with Latest Handsets

Tuesday, February 9th, 2010

On Tuesday, the two South Korea’s biggest cell phone makers previewed handsets that they plan to unveil at next week’s Mobile World Congress exhibition in Barcelona.

Both phones feature full-screen touch panels on their face, Wi-Fi and close links with social networking services.

The Samsung Monte is an extension of the company’s S-series of phones and includes applications for Facebook and MySpace, and widgets for access to Twitter, Bebo and several instant messaging networks.

The front of the phone is dominated by a 3-inch display with full-screen touch panel through which all the main user interaction takes place.

A GPS receiver hooks into Google Latitude, which allows you to share your position with friends on a map, and provides location data that is embedded with photos taken with the phone’s 3.2-megapixel camera. Two applications, Exchange ActiveSync and Google Sync, are included to synchronize e-mail, contacts and other data with a PC.

LG’s new handset, the GD880 Mini, connects to Facebook and Twitter and a social network feed function combines updates from different services in a single stream.

In some areas the LG Mini outpaces the Samsung Monte: the screen is slightly bigger at 3.2 inches and the camera offers a higher resolution of 5 megapixels. Other features include high-speed HSDPA networking and A-GPS (assisted GPS).

According to LG, the Mini will be launched in Europe in March and later in other markets. Samsung didn’t provide launch details for the Monte.

Both the companies are yet to announce prices for the new handsets.

Tags: , , , , , , ,
Posted in Marketing, New Product Release

BobbyeM71hxwFive Benefits of an Open Source Symbian

Monday, February 8th, 2010

The Symbian Foundation has given the Symbian mobile operating system a second life, making the smartphone platform open source. The lifeline will revitalize the platform, and has benefits for Nokia, smartphone developers, Symbian handsets, and smartphone users.

With all of the hype and attention devoted to the iPhone, it’s easy to forget that Symbian is actually the leading smartphone operating system in the world. Symbian has nearly as much market share as the rest of its competitors combined–including the iPhone, with more than 330 million Symbian smartphones in use.

If Symbian is so dominant, why should Nokia spin it off, and why should the Symbian Foundation make it open source? The answer is that the Symbian is yesterday’s smartphone operating system. It may be dominant, but it’s declining.

Globally, Symbian has a huge footprint, but RIM and Apple have been steadily chipping away at it. It is somewhat geriatric compared with next-generation smartphone operating systems like iPhone and Android.

For the Symbian platform, the move to open source is a good move with benefits at all levels.

Here are five ways an open source Symbian is good for the smartphone platform:

1. Nokia. From the transition to open source, Nokia will be benefited because it pumps new blood into the waning platform without any effort or investment from Nokia.

While Nokia moves on to creating new devices built on its Linux-based Maemo platform, it will still gain a marketing and public relations boost from its relationship with Symbian and its dominant contribution to the development of the smartphone platform.

2. Smartphone Manufacturers. The availability of Symbian as an open source operating system gives smartphone manufacturers an alternative to Google’s Android. Android has demonstrated that an open source mobile operating system can be a very effective platform–enabling smartphone vendors to customize the OS, and develop robust devices at a lower cost (or higher profit margin) due to the lack of associated licensing fees.

Some manufacturers may be interested in leveraging an open source platform, yet be reluctant to partner too closely with Google. Even vendors who have embraced Android may be looking for alternatives now that Google has entered the market as a direct competitor with the Nexus One.

3. Developers. Making the source code of the Symbian operating system available as open source opens up a huge market for developers. Symbian will never achieve the rabid success of the iPhone App Store, but it’s hard to ignore a market of 330 million potential customers. Just based on economy of scale, even a mediocre Symbian app could be quite lucrative.

4. Businesses. Taking the developers benefit in a different direction, companies of all sizes will benefit from the ability to customize the platform, and develop unique applications to integrate Symbian smartphones with the enterprise, and streamline business processes.

For businesses that are already invested in Symbian-based smartphones, an open source Symbian can extend the useful life of the devices and enable the company to maximize the investment it’s already made rather than allocating precious budget dollars to smartphone upgrades.

5. Users. The 330 million Symbian users of the world get some new life as well. As developers embrace the open source Symbian and begin to create innovative applications for the smartphones, Symbian users will benefit from new features and functionality without having to trade their devices in for an iPhone or a Nexus One.

The transition to open source isn’t necessarily all wine and roses, though. As different developers take the open source code in different directions, there is a risk of the platform forking and creating some confusion as far as which Symbian will work with which Symbian smartphones.

Making Symbian open source may stop some of the hemorrhaging of market share Symbian has experienced, and it is almost guaranteed to extend the useful life of the platform. However, it is still yesterday’s smartphone platform and Symbian’s days are still numbered–the number is just higher now.

Tags: , , , , , , , ,
Posted in Opensource, Technical News

BobbyeM71hxwMalicious Firefox Add-ons Installed Trojans

Saturday, February 6th, 2010

Last night, Mozilla announced that two experimental Firefox add-ons, Master Filer and the Sothink Web Video Downloader version 4, infected victim PCs with Trojans when either add-on was installed.

The small-distribution extensions were previously available via Mozilla’s add-on site, but have since been removed. According to Mozilla’s post, the Master Filer add-on had been downloaded about 600 times and installed the Bifrose Trojan. The Sothink Web Video Downloader version 4 slipped in the LdPinch Trojan, and had been downloaded about 4,000 times.

According to the open-source organization, the malicious add-ons managed to sneak by the one malware scanner (unnamed in the post) used by Mozilla. The organization says it will now be scanning with two additional detection tools.

If you happen to have installed either of these malicious add-ons, note that removing the add-on will not remove any installed Trojan. You’ll need to run a separate antivirus scan and disinfection to clean your system. Mozilla’s post includes a list of antivirus software currently known to detect the particular Trojans involved.

This unfortunate incident makes clear why relying solely on one antivirus scanner is never a good idea, as no one program detects everything. Since this has happened at least once before with an infected Vietnamese language pack, I’m curious why Mozilla doesn’t simply switch to uploading all add-on submissions to the free Virustotal.com, which uses about 40 different engines to scan each submission. I’ve also asked Mozilla which scanner it had been using. If I get that information I’ll add it to this post.

According to Mozilla, it had been using ClamAV as its sole scanner prior to this incident. I’d guess Mozilla feels it’s a natural match as an open-source app, but the ClamAV engine didn’t fare well at detection tests when I reviewed the Windows version of the program, ClamWin.

http://www.all1Press.com

http://get-a-designer.com

Tags: , , , , , , , , ,
Posted in Expert's Opinions, Opensource, Technical News

BobbyeM71hxwApple Addresses iMac Flicker Problem with Update

Thursday, February 4th, 2010

Apple has posted a firmware update, 27-inch iMac Display Firmware Update 1.0, to address persistent flickering problems in Apple’s largest iMac.

On Apple’s Web Site, the issue is heavily documented in this support thread, should fix what users have called intermittent flickers lasting a quarter of a second or so. But the fix won’t solve another concern: complaints of yellowing in the monitor, which Apple requires users return the monitor to an Apple store.

However, Apple has issued what appears to be a standard warning or disclaimer: “If your screen remains black after applying the update, contact Apple Care or an Apple Authorized Service Provider. If you continue to experience image corruption or display flickering, make sure you have also installed the 27-inch iMac Graphics Firmware Update 1.0. If you are still having display issues after successfully completing both firmware updates, contact AppleCare or an Apple Authorized Service Provider.

The graphics firmware update, issued in December, was supposed to address ATI Radeon HD 4670 and 4850 graphics cards that may caused image corruption or display flickering. We can only assume the fix didn’t work, however, necessitating the second update.

It’s difficult to say whether Apple has solved the problem, as one user pointed the inherent problem with support forums: once the problem is fixed, people no longer visit the site, as their problems have been solved.

User “Aaron Stroot” reported: I have a week 45 27″ iMac i7. It has had minor screen flickering since the beginning, but it never really bothered me enough to worry about exchanging it. I never saw the flickering in Windows 7 so I figured it was a software thing that could be fixed, he added.

“Anyways, here is my experience:
1) First firmware update – seemed to fix it, but flickering came back after a day.

http://www.all1martpro.com

http://get-a-designer.com

Tags: , , , , , , , , ,
Posted in Technical News

BobbyeM71hxwChrome Has 5.2 Percent of Browser Market, Ahead of Goal

Wednesday, February 3rd, 2010

Google may not be winning over the multitudes with its Nexus One “superphone,” but the search giant is gaining ground in the 21st century browser wars. Google’s Chrome browser grabbed market share in January from its key rivals, Microsoft’s Internet Explorer and Mozilla’s Firefox.

According to NetApps, Chrome finished January strong, with a 5.2 percent market share. Although a 0.6 percent gain may not immediately rattle the dominance of well-entrenched players like IE and Firefox, it does show a steady flow of users to the youngest player in the browser market.

Overall, Google has doubled its market share, and in January saw the second-largest gain since rolling out the browser in September 2008. Google has already surpassed Apple’s Safari in the browser wars, making it the third-most-used browser.

Google has exceeded its goals, hitting five percent well before its September 2010 deadline. Google aims to reach 10 percent by September 2011 but could reach that number this year if its growth rate holds steady.

Digging Deeper Into IE Usage

Weeks after the bad publicity around Internet Explorer 6 and its role in the China-based attacks on Google, Internet Explorer lost half a percentage point of market share in January, according to NetApps. That leaves Microsoft with 62.2 percent of the browser market, a record low.

Microsoft has steadily seen its share of the market eroded by the likes of Firefox, Opera and even Apple. Google seems to be putting another dent in the browser market leader. Microsoft has lost 10 percent of its market in the past 12 months while Google reached its 5.2 percent mark.

Looking a little deeper, IE6 saw a 0.9 decline in market share to 20.1 percent. IE7 also suffered in January, dipping a full percentage point to 14.6 percent. The good news for Microsoft is that IE8 is stemming the tide of losses, at least in part. Launched last March, IE8 rose 1.5 percent in January, ending the month with a 22.3 percent market share. That makes IE8 Microsoft‘s most popular version.

Browser Round Up

The number-two browser, Firefox, also wasn’t immune to market declines in January. For the second month in a row, Firefox usage dipped. However, unlike Microsoft, Mozilla may not have as much reason to worry.

Although Firefox saw usage declines in December and January, there is no long-term trend. Firefox has only seen declines twice in about a two-year period. Overall, Firefox dipped 0.2 percent in January and still holds 24.4 percent of the browser market.

Turning to Safari, Apple gained a slight advantage, ending January with 4.5 percent market share, not enough to regain the number three spot but enough to outpace Opera, which fell to 2.4 percent.

Michael Gartenberg, a vice president at Interpret, doesn’t think the IE6 incident related to Chinese hackers has affected IE. Rather, he credits Google’s gains with the fact that the search giant regularly advertises Chrome on its home page.

“When you go to Google.com, if you are not using Chrome, you get offers to download and upgrade. When you’ve got the kind of clout Google has on its home page, it’s going to help drive adoption going forward,” Gartenberg said. “Of course, Chrome is a pretty good product, so that helps as well. It goes to show how fluid the tech market is today. It’s not easy for a small company to do a browser, but if you are a company the size of Google, you can make an impact on the industry.”

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , , , ,
Posted in Microsoft Technology, Technical News

BobbyeM71hxwGoogle offers bounty for Chrome vulnerabilities

Monday, February 1st, 2010

Google is offering a cash reward to security researchers for finding flaws in its Chrome web browser.

It would be doling out payments ranging from $500 to $1337 to developers who find and directly report security holes in the browser, said the company. The $1337 amount is an apparent homage to the hacker term ‘1337’ (pronounced “elite”.)

The payment system will apply to flaws in the Chromium open source project along with the Chrome browser and bundled components such as Google Gears.

The company was looking to bring more third party researchers into its midst, said Google Chrome security team member Chris Evans. Some of the most interesting security bugs have been fixed by researchers external to the Chromium projects, he wrote.

“Thanks to the collaborative efforts of these people and others, Chromium security is stronger and users are safer.”

Paying vendors for disclosure of flaws has been a tactic used by both developers and security vendors to encourage not only research, but responsible disclosure.

According to firm, it hopes that by offering cash rewards, researchers will report flaws to those who will patch them rather than malware writers who pay for new vulnerabilities to exploit.

http://www.all1social.com

http://get-a-designer.com

Tags: , , , , , , , , ,
Posted in New Product Release

BobbyeM71hxwSun-Oracle Merger Looks Bright for OpenOffice, MySQL

Saturday, January 30th, 2010

Oracle announced its intentions with Sun products, although Apple’s iPad announcement has eclipsed, and now the acquisition of Sun Microsystems is compete.

The announcement was actually a planned webcast, which reassured those worried over the fate of two open-source Sun products for small business: the database software, MySQL and the productivity suite,OpenOffice.org. The acquisition might make MySQL and OpenOffice.org even more competitive against costly Microsoft counterparts (SQL Server and Microsoft Office).

OpenOffice.org has already proven a worthy alternative to the stranglehold Microsoft has in the productivity suite space for SMBs. And Last year, OpenOffice.org reached its one hundred millionth download. Yet, Sun has still not managed to make great headway in the productivity space.

Forrester’s research reported last year that 80% of businesses still use Microsoft Office. Oracle will be able to push competition against Microsoft in a way that Sun never could quite accomplish.

Oracle is also poised to offer a cloud-based productivity suite that leverages the awesomeness of OpenOffice.org into a real competitor against Google Docs/Apps.

Oracle’s plan to keep MySQL Community Edition free, as well as spend more on research and development for it than Sun did in its most recent fiscal year, bodes well for MySQL.

The database savvy of Oracle and MySQL developers can make MySQL into a formidable competitor to MS SQL and the database of choice for small to mid size business.

For small business, it’s a win. Both products will stay free; they work well already and only stand to get better with Oracle’s backing.

http://get-a-designer.com

http://www.all1sourcetech.com

Tags: , , , , , , , , ,
Posted in Opensource