Thursday, July 09, 2009

download northwind and pub sample databse for microsoft sql

Northwind and pub sample database download link: download now

Alternative Link: http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

It Include both script and the database - (*.mdf + *.ldf)

Here is the Help Provided by Microsoft........

Updated SQL Server 2000 Sample Database Files

December 15, 2004

The SQL Server documentation team cannot answer technical support questions, but welcomes your suggestions and comments about this readme documentation. You can quickly and directly send e-mail feedback using the link below. Please send feedback in English.

To submit written feedback about this document, click here: Submit feedback.

Introduction

The Microsoft® SQL Server™ 2000 Sample Database Files include:

· New versions of two scripts included with SQL Server 2000:

· Instpubs.sql creates the pubs sample database.

· Instnwnd.sql creates the Northwind sample database.

· Pre-built database files that can be attached to an instance of SQL Server 2000:

· Pubs.mdf and pubs_log.ldf are the data and log files for the pubs sample database.

· Northwind.mdf and northwind.ldf are the data and log files for the Northwind sample database.

These copies of the scripts or database files are the same as the versions included with SQL Server 2000, except for these changes:

· The script for creating pubs, instpubs.sql, has been modified to install pubs and all of the pubs data in one step. The original version of instpubs.sql included in SQL Server 2000 does not load in some of the pubs data, and customers were required to run batch jobs to install some of the larger data values.

· The scripts have been brought into compliance with recent Microsoft samples security guidelines. Instpubs.sql no longer creates a “guest” user and no longer grants rights to “guest” or “public”. All dates that are used to populate the databases now express the full four-digit year, such as 1992.

· The pre-built database files include all of the changes incorporated in the new script files.

SQL Server 2000 Desktop Engine (MSDE 2000) customers can also use these copies of the files to install pubs and Northwind.

Note If the instance of SQL Server 2000 was installed with a case-sensitive collation, always type pubs in all lowercase letters, and Northwind with an initial capital "N" followed by lowercase letters. Sample applications and the code samples in SQL Server Books Online might not work correctly if the database names are not created exactly as shown in the examples.

Sample Files Prerequisites

The user attaching the pre-built database files must be a member of the SQL Server sysadmin or dbcreator fixed server roles.

The user running the SQL Server 2000 Sample Database Scripts must be a member of the SQL Server sysadmin or dbcreator fixed server roles, or have been granted CREATE DATABASE permissions.

The files can be used with the following versions of SQL Server 2000:

· SQL Server 2000 Service Pack 3 (SP3) or later.

· SQL Server 2000 Desktop Engine (MSDE 2000) SP3 or later.

· SQL Server 2000 Desktop Engine (MSDE 2000) Release A.

Downloading and Extracting the Files

The SQL Server 2000 Sample Database Files are available as an installation file, SQL2000SampleDb.msi, which can be downloaded by following the instructions on the download website.

After downloading SQL2000SampleDb.msi, extract the sample database files by double-clicking SQL2000SampleDb.msi. SQL2000SampleDb.msi extracts the database scripts and this readme file into this folder by default:

C:\SQL Server 2000 Sample Databases

Installing the Sample Databases

To install the sample databases

1. Either run a script to build a sample database, or attach the pre-built database files for that database.

2. To grant another person access to the sample database, you must grant permissions on the database objects to that person.

SQL Server 2000 customers can perform these tasks using either the osql utility or the two graphical utilities SQL Query Analyzer and SQL Enterprise Manager. MSDE 2000 includes only the osql command prompt utility.

Caution Instpubs.sql drops any existing version of the pubs sample database and Instnwnd.sql drops any existing copy of the Northwind sample database before creating the new copies of the database.

Attaching the Pre-built Files by Using Enterprise Manager

To attach the pre-built files by using SQL Query Analyzer:

1. From the Start menu, point to All Programs, point to Microsoft SQL Server, and then click the Enterprise Manager icon.

2. Right-click Databases and select All Tasks/Attach Database.

3. Either enter C:\SQL Server 2000 Sample Databases\northwind.mdf or
C:\SQL Server 2000 Sample Databases\pubs.mdf as the MDF file of database to attach, or click Browse (…) to search for the file to attach.

4. Click Verify to ensure the selected MDF file is correct.

5. Specify Northwind or pubs in Attach as.

6. Specify the database owner.

7. Click OK.

Attaching the Pre-built Files by Using osql

To attach the pre-built files by using osql:

1. Open a command prompt window.

2. From the command prompt, use the cd command to navigate to the folder containing the SQL Server 2000 Sample Database Scripts:

cd c:\SQL Server 2000 Sample Databases

3. Run osql using the -Q switch to execute sp_attach_db to attach either the pubs or Northwind pre-built database files. Here are some examples:

Note Enter the osql commands on one line in the command prompt window. These examples split the commands across two or three lines to make the examples easier to read.

· To attach the Northwind database to a default instance on the same computer:

·                            osql -E -Q "EXEC sp_attach_db N'Northwind',

 N'c:\SQL Server 2000 Sample Databases\northwind.mdf'"

· To attach the pubs database to a default instance on a different computer:

·                            osql -E -S ComputerName -Q "EXEC sp_attach_db N'pubs',

 N'c:\SQL Server 2000 Sample Databases\pubs.mdf'"

· To attach the Northwind database to a named instance:

·                            osql -E -S ComputerName/InstanceName

·                             -Q "EXEC sp_attach_db N'Northwind',

 N'c:\SQL Server 2000 Sample Databases\northwind.mdf'"

Running the Scripts Using SQL Query Analyzer

To run the scripts using SQL Query Analyzer:

1. From the Start menu, point to All Programs, point to Microsoft SQL Server, and then click the Query Analyzer icon.

2. Connect to the instance of SQL Server 2000 on which you want to create the sample database.

3. On the File menu, click Open, and navigate to the c:\SQL Server 2000 Sample Databases folder. Select either Instpubs.sql or Instnwnd.sql.

4. On the toolbar, click Execute Query.

Running the Scripts Using osql

To run the scripts using osql:

1. Open a command prompt window.

2. From the command prompt, use the cd command to navigate to the folder containing the SQL Server 2000 Sample Database Scripts:

3. cd c:\SQL Server 2000 Sample Databases

4. Run osql specifying either Instpubs.sql or Instnwnd.sql as the input file. Here are some examples:

· To install the Northwind database on a default instance on the same computer:

osql -E -i instnwnd.sql

· To install the pubs database on a default instance on a different computer:

osql -E -S ComputerName -i instpubs.sql

· To install the Northwind database on a named instance:

osql -E -S ComputerName/InstanceName -i instnwnd.sql

Assigning Permissions

The logon you use when creating or attaching a database becomes the owner of the sample database, and of all the objects within the database. That login and any login in the sysadmin fixed server role will have permission to access the data and objects in the sample database. All other logins must be granted permissions before they can access the sample data and objects.

Granting a Login Access to a Database

You can grant access to the sample databases using Enterprise Manager or the sp_grantdbaccess system stored procedure. Only a database user that is a member of at least one of the following roles can grant access to a database: the sysadmin fixed server role, the db_accessadmin fixed database role, or the db_owner fixed database role.

To grant access using Enterprise Manager:

1. Expand the server group and then expand the server.

2. Expand Databases and select the sample database.

3. Right-click Users, and then click New Database User.

4. Complete the Database User Properties form.

To grant access using sp_grantdbaccess

Having connected to the server with either osql or SQL Query Analyzer, you can use sp_grantdbaccess to enable a domain user to access the database. For example, the following commands grant access to pubs to a domain user named Hamid:

USE pubs;

GO

sp_grantdbaccess 'CORPORATE\hamid', 'hamid';

GO

For more information about granting logins access to a database, see the following topics in SQL Server Books Online:

Granting a Windows User or Group Access to a Database

Granting a SQL Server Login Access to a Database

Granting User Accounts Permissions

Once a login has been associated with a user account in the sample database, you must grant that user account permissions to access database objects. Only a database user that is a member of at least one of the following roles can grant access to database objects: the sysadmin fixed server role, the db_accessadmin fixed database role, or the db_owner fixed database role.

To grant account permissions using Enterprise Manager

1. Expand the server group and then expand the server.

2. Expand Databases and select the sample database.

3. Expand the category for type of object, such as stored procedures or views.

4. Right-click the object, point to All Tasks, and then click Manage Permissions.

To grant account permissions using the GRANT statement

In either osql or SQL Query Analyzer you can use the GRANT statement to grant permissions on database objects. First execute a USE <database_name> statement.

To grant execute permission on a stored procedure, use the following statement:

GRANT EXECUTE ON [dbo].[database_object_name]

              TO [database_user_account];

GO

To grant data read and modification permissions, use the following statement:

GRANT  SELECT , INSERT , DELETE , UPDATE

       ON [dbo].[database_object_name]

       TO [database_user_account];

GO

For more information about granting permissions in a database, see the following topic in SQL Server Books Online:

Tuesday, July 07, 2009

I hate iTunes

Thanks to winamp, that I can manage my iPod with Winamp

iTunes can't use it with multiple computers :@ pathetic
using winamp we can control / mange the iPod easily and quickly.

While Installing the winamp Install the Portable Media Support.

Winamp Media Library can be used to add / remove tracks for iPod.

Winamp allows drag and drop tracks to the iPod and just remove from device, will delete the tracks from the iPod.

Thanks to winamp.

References:
http://www.simplehelp.net/2007/07/07/how-to-use-winamp-to-manage-your-ipod/
http://www.mlipod.com/

Sunday, July 05, 2009

Run Multiple Instances of Skype on windows

Skype allows login per windows user.
but we can start another skype with another user without logging into another user's desktop
Here are the steps that you need to follow

Goto c:\Program Files\Skype\Phone - or the directory when skype is installed.
Right click on Skype.exe - select run as from the menu.
Use another user like Administrator or else, and you are done - start using another instance of skype.

Step - I

Step - II

Step - III

Enjoy !!!

Sunday, May 24, 2009

A web tool hailed as a significant rival to search giant Google has gone live to the public.

Wolfram Alpha is called a computation knowledge engine rather than a search engine and wants to change the way people use online data.

It aims to give people direct answers to queries rather than send them to other sites where they may find what they are seeking.

The system is the brainchild of British-born physicist Stephen Wolfram.

Wolfram Alpha was unveiled in late April and since then has been publicly demonstrated and some people have had a chance to run queries through it.

Typically the results it returns are annotated pages of data rather than a simple list of other sites that might help resolve a user's query.

For example, if asked about the weather in Manchester it would present a graph of average temperatures, rainfall and other salient data.

The computational horsepower behind the main site works out answers to question as they are put by grabbing data from databases and consulting feeds of relevant information.

Wolfram Alpha can be asked known facts, such as the height of mountains, or be asked to generate new information such as up to date figures for a nation's GDP.

It can also handle complicated mathematical queries, plot statistics and produce charts of natural events.

The data it consults is chosen and managed by staff at Wolfram Research who ensure it can be displayed by the system. Behind the scenes Wolfram Alpha has about 10,000 CPUs spread across five data centres that it draws on when generating answers.

During a demonstration at Harvard University's Berkman Center for Internet and Society, Dr Wolfram said: "Our goal is to make expert knowledge accessible to anyone, anywhere, anytime."

Dr Wolfram played down talk that the system would be a Google killer and instead presents it as a way for people to get more out of the information on the web.

The final tuning and testing of the system was webcast live during the weekend before the official launch.

Prior to the start of the webcast and final testing, Theo Grey, co-founder of Wolfram Research, said: "If we do melt down when we go live it will not be for lack of effort, or any sort of naive idea of how many queries we might get. It will be because of overwhelming response."

Reference: http://news.bbc.co.uk/2/hi/technology/8052798.stm

Sunday, May 17, 2009

Dell Vostro A840 Windows XP Drivers Download

For Windows XP Audio - Modem Drivers - Dell Vostro A840 / A860.

Don't install the Drivers directly !

Follow the steps below.

1. Install SP32646.exe

2. After installing SP32646.exe, Install SP34386.exe

http://postdownload.filefront.com/8984671//dd1fbc64132245ccdf5287915be0ee44e30b39d3dded5c7a8eee4d0aa58d22cde17670287769152d

Once you have followed above 2 steps, now windows will recognize and found High Definition Audio Driver (for AMD) & Universal Audio Architecture (UAA) Bus Driver for High Definition Audio).

3. Now install the Dell Drivers R192894.exe & R190098.exe

References:

Tuesday, May 05, 2009

Tips for IM Client

It’s been a pleasure to watch Google Talk enter the over-saturated niche of popular instant messages and then quickly dominate. I am Google Talk user myself. I can vaguely understand why I ultimately chose it over other IMs I would use; probably because most of my contacts have only one thing in common: Gtalk.

So today I am sharing a few best tips on how to make the most of your Gtalk:

Translate using Google Talk (the feature runs on Google Translate). Just add any of the bots below (there may be many more) and send them messages of the text you want to translate):

Bot	Translation
ar2en@bot.talk.google.com	from Arabic into English
de2en@bot.talk.google.com	from German into English
fr2en@bot.talk.google.com	from French into English
el2en@bot.talk.google.com	from Greek into English
es2es@bot.talk.google.com	from Spanish into English
ja2en@bot.talk.google.com	from Japanese into English
ko2en@bot.talk.google.com	from Korean into English
en2nl@bot.talk.google.com	from Dutch into English
ru2en@bot.talk.google.com	from Russian into English
zh2en@bot.talk.google.com	from Chinese into English

Gtalk as a free and easy website live chat client:

You can place Gtalk button on your site and let your site visitors contact you using it. Create your Google Talk badge here;

Other IM Clients which works for Gtalk.

pidgin
Gajim
Gaim
eBuddy
Koppete
Digsby - The best !

And lot more read more

Featured Google Talk client: Digsby

DigsBy is by far my favorite third-party Google talk application not because it offers some extra-ordinary Gmail possibilities (well, it does have some cool GTalk enhancements) but because it integrates all my major IMs and social media networks in one handy tool. The platform it supports include:

IMs: GTalk, AIM, Yahoo! Messenger, Facebook chat;
Email notifications: Gmail, Yahoo, Hotmail, AOL mail;
Social networks: Twitter, Facebook, LinkedIn, MySpace.

Some cool features I am personally using:

For each social network add as many accounts as you want;
Sort Gtalk (and other) contacts into groups (!);
Set tracking for any GTalk buddy: e.g. get notified when some person signs in or changes the status message;
See all the contact info when hovering over;
Sort contacts by name, status,
Reply right from the pop-up;
Manage multiple conversations with tabbed conversation windows;
Set your Facebook, Twitter and LinkedIn status right from Digsby;
Synchronize your settings and accounts between computers.

Download Digsby:

download for MAC

download for Windows

coming soon for Linux - Subscribe for newsletter

Chat Windows - Appearance

FaceBook - Twitter - Social Networking Integration !

Chat Notification - As well as Reply from Notification Directly !

Email Notifications and more.....

Monday, March 30, 2009

Visual Assist X

Visual Assist X - an add-in for for Visual Studio

Visual Assist X dramatically reduces application development time with key new features and improvements to existing features in Visual Studio, allowing you to:

All in all, Visual Assist X is an indispensable aid...you'll feel withdrawal symptoms if you ever have to program without it.

Download From - Whole Tomato Software