The database principal owns a schema in the database, and cannot be dropped

While restoring a database backup file in my hosting I was prompted with some error message regarding existing user in the database. So I decided to delete those users. But while trying to delete the users from my local sql sever management studio, error occurred.

The database principal owns a schema in the database, and cannot be dropped.

I tried out browsing the property of the user and removing the assigned scheme from the lists. It was somehow unsucessful. So I decided to go search for the solution and stumbled at doing it the most powerful way - through command.
Here goes the solution - Revoke the database schema assigned to the user and assign it back to the default db object.
ALTER AUTHORIZATION ON SCHEMA :: my_user_name to db_owner
 If you want to assign the schema  to another user, here is how you accomplish it.

 ALTER AUTHORIZATION ON SCHEMA :: my_schema_name to my_user_name

Cheers!

Invitation to connect on LinkedIn

From sangam uprety Executive Director at Time Infotech Nepal I'd like to add you to my professional network on LinkedIn. - sangam Confirm that you know sangam You are receiving Invitation to Connect emails. Unsubscribe © 2012, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA

Installing sql server 2005 express in windows 7

If you started with sql server 2005 express editions in your windows vista or xp operating systems, you are sure to stumble while installing sql server 2005 express in windows 7. After having long time experience of sql server 2005 express in my windows vista, I just switched to windows 7 and tried same version of express in it. But it is not supported. You get the failure message sort of:

This software is not supported in this version of operating system.

The simple solution is to acquire SQL Server 2005 Express Service Pack 3. Choose 32 bit or 64 bit version according to your machine.

The story does not finish yet. If you are looking for sql server management studio express, you again have to look for service pack 3 of sql server 2005 management studio. Get SQL Server 2005 Management Studio Express Service Pack 3 and get installed in your machine. Still don't forget to choose right version matching to your machine (32 or 64 bit).

Happy upcoming Valentine's Day!

Prove that programmers too can be social change makers : last day to vote for a social work

A dream to provide solar and computer to a school in rural Nepal! It can be realized by your single vote. Please vote for it at Solar and Computers to a School in Rural Nepal

Appeal from the dreamer - read below please.

My dream is to help a school in an extremely remote village of Western Nepal to buy and install a solar system, batteries, inverters, computers and printers necessary for the school for its computer lab and e-library. The school was built with support from local people and some of the colleges and students of Kathmandu.

Lalu village where the school is located lacks basic infrastructure, however with the local people driving it, the school is a vehicle to bring the community into the 21st century.

The school has very innovative ideas that make it unique. Firstly, Modern Model Residential School is a rural based purely service oriented co-educational English medium primary institution registered as Non-profit Distributing Company. Secondly, it strives to be a progressive institution that acts as a hub for the community, imparting education mixed with modern technology.

Using a pro-rata system the school is able to provide quality education to people of the entire community. Orphaned, disadvantaged or disabled students and families are admitted free of charge, whilst others contribute as little as $3 per month. This shows how even a small amount can change not only the students’ lives but their families and the entire community.

Kalikot is amongst one of the world's most impoverished areas. “57% of people in Kalikot district live under extreme poverty. Per capita income lies at Rs. 6000 (around $ 83) per year and average life expectancy remains at just 42. Only 57.27% of children are literate where as overall literacy rate is at just 38.47%. Still 45.95% of children involve in some kinds of economic activity instead of going to school.” -Central Bureau of Statistics of Nepal, District Profile, Kalikot 2008 AD .

Please don't forget that your single click can make it happen. Time is too short to stop and think. Help to realize the dream and be proud of it! Click Solar and Computers to a School in Rural Nepal to vote!

Yes, programmers too can be social workers!

Thank you!

CamStudio - Free Streaming Video Desktop Recording Software

CamStudio a really useful desktop based software that you can use for recording anything that happens with your desktop. And the best part is it is distributed under GNU General Public License (GPL) license. Free to use for both commercial and non-commercial uses. So what are the uses? Let me recite the site itself:

CamStudio is able to record all screen and audio activity on your computer and create industry-standard AVI video files and using its built-in SWF Producer can turn those AVIs into lean, mean, bandwidth-friendly Streaming Flash videos (SWFs) Here are just a few ways you can use this software: You can use it to create demonstration videos for any software program Or how about creating a set of videos answering your most frequently asked questions? You can create video tutorials for school or college class You can use it to record a recurring problem with your computer so you can show technical support people You can use it to create video-based information products you can sell You can even use it to record new tricks and techniques you discover on your favourite software program, before you forget them

How to get the software? How to use this? Yes, it is very easy. Watch the video on how to capture video from your desktop and you are easy to begin! Why this post? Any open source products like this one is a great contribution to the whole world. So this just a give-back to the great effort. I have just tried to spread the word. Could you please do the same? Thank you!