i need suggestion for install sql server 2008

Question

to install sql server 2008 what i have to do first? which software i need to install? i have a system windows 7 ultimate with 32bit .

Durga Velusamy · Answer

Mr. Khargesh Rajput sir i have download sql server 2014 as you mention and also i have installed but it shows icon as only sql server 2014 import and export Data (32bit) . here , there is not sql visual management tool then how can i go inside the sql to create database and to do furthere funtions?

Khargesh Rajput · Answer

SqlCommand cmd = new SqlCommand ( "Delete from devi where CustomerId='" + comboBox1.Text + "'" , con); cmd.ExecuteNonQuery(); //here write your code or function to bind //comboBox1 from database again

Durga Velusamy · Answer

Mr. Khargesh Rajput sir please answer to this if you know this please give sample code t o refresh a page after delete item its need to do not show in the combolist private void button4_Click( object sender, EventArgs e) { SqlConnection con = new SqlConnection ( @"server=CSE-PC; integrated security=true; Database=Bas" ); con.Open(); if ((comboBox1.Text == "" ) && (comboBox2.Text == "" ) && (comboBox3.Text == "" ) && (comboBox4.Text == "" ) && (comboBox5.Text == "" ) && (comboBox6.Text == "" ) && (comboBox7.Text == "" )) { MessageBox .Show( "doesn't delete null value" ); } else { SqlCommand cmd = new SqlCommand ( "Delete from devi where CustomerId='" + comboBox1.Text + "'" , con); cmd.ExecuteNonQuery(); MessageBox .Show( "Deleted Successfully" ); comboBox1.Text = "" ; comboBox2.Text = "" ; comboBox3.Text = "" ; comboBox4.Text = "" ; comboBox5.Text = "" ; comboBox6.Text = "" ; comboBox7.Text = "" ; con.Close(); here I need to refresh a page after delete item its need to do not show in the combolist . my problem is : after deleted the item it shows in the combolist. But the item is deleted from the database even the item name only displacing in the combolist I need to update with current satus. } }

Khargesh Rajput · Answer

just run setup of sql and follow http://www.codeproject.com/Articles/305113/How-to-Install-SQL-server-on-Windows and install sql successfully Requirements: Visual Studio 2010 or VS 2008 SP1 Step 1: Double click on the installer. It will take some time to extract. After that an window will open as follow. Step 1 Step 2: From this window click on the Installation menu (See Left). Now there will be appear some option under Installation. From right, click on the option New SQL Server stand-alone installation or add features to an existing installation. Note: After Clicking on that a window may appear as bellow. Just click on the button Run Program of that. Note Step 3: Now setup will take a moment to complete some operation. To continue there can not be any operation with status failed. If any operation fails then it will not be possible to continue installation. Click OK Step 4 Step 4: This is express edition so I do not need to enter any product key. Just Click on Next Step 4 Step 5: Check Accept the terms and click NEXT Step 5 Step 6: Now Click Install button. Some setup support files will be installed. Step6 Step 7: Now again It needs some operation to be completed. Every operation must be passed or warning or skipped. If any operation fails then it is not possible to continue. Click Next. Step 7 Step 8: Now select the features which do you need. Here I am selecting Database Engine Services, Busines Intelligence Development Studio, Management Tools basic & SQLl Client Connectivity SDK. Click Next. Step 8 Step 9: Here we need the name and instance ID. I am selecting Default Instance but keep the name "SQLExpress" in your mind for future use. Click Next. Step 9 Step 10: Now a window will appear and it will show the space required and available. Click Next. Step 10 Step 11: Here select the account name from the dropdown list for SQL Server Database Engine- NT AUTHORITY\NETWORK SERVICE and Click Next. Step 12: Now select which mode do you want to use. Here I am selecting the Mixed mode. For mixed mode I have to provide the password for the root account (username "sa" default) and adding my current user by which i will also be able to access database engine without default administrator account (username : sa ). Step 12 Step 13: Click Next Step 13 Step 14: Now again every operation must be passed or skipped. If there is any operation with status failed then installation will not be possible. Click Next Step 14 Step 15: Now finally it is going to start the installation. Click Install Step 15 Step 16: Now wait till installation is complete. Setup is complete. Click Next Step 16 Step 17: Now Close this window Close

Tom Mohan · Answer

I assume the system is your personal computer/laptop. Then go ahead with sql server express edition. That is the compact edition and free. You will get the latest sql server express 2014 from the following URL. http://www.microsoft.com/en-in/server-cloud/products/sql-server-editions/sql-server-express.aspx

i need suggestion for install sql server 2008

Answers (5)