MS SQL Setup For Beginners

May 28, 2004

:) Hi dear fellow members,

I am a newbie to MS SQL. I already completed the installations on the SERVER side and CLIENT side. I have an inventory database in Ms Access that I want to transfer into MS SQL SERVER 2000. Is there anybody who can help me how to do it?

I would be very thankful to anybody who can help like me
who is new to SQL

Regards.

BOBOY PONCE

View 1 Replies


ADVERTISEMENT

Please Help Beginners

Oct 19, 2005

The followong statement is working

iif ([Measures].[Docsum]>500, "1","0")

But there is a need to count these Docsums
so
iif ([Measures].[Docsum]>500, Count[Docsum],"0")

but not this way
Can somebody help and explains, how to Count these sums
Thank's

View 1 Replies View Related

Beginners

Sep 13, 2006

I have just started learning SQL server. Where from I start. I have downloaded SQL Management Studio & SQL Express Edition.

Now What should I do now ?

View 3 Replies View Related

SQL Beginners Problem !

May 20, 2004

*** edited by: master4eva ***
Please enclose your code in < code ></ code> tags (without the spaces). This will make your code easier to read online; therefore, encouraging a response to be faster. It is to your own benefit for your question to be answered in future.

I have already done the editing to include the < code ></ code> tags for this post.
*********

Hi,
I am following tutorials in a book to try and implememnt a basic select query using SQL.
However i am following all the instructions, which includes entering this header:

<%@ Page Language="VB" Explicit="True" Debug="True" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>

Then i am dragging a data grid onto my form, constructing a select query in query builder, however the resultamt code i get is totally different than the one in book.
The ideal poutcome refers to the SQL client, SQL reader etc, however in my code below, there is NO mention of SQL at all...simply dbconnection, IDatareader.

can anyone help me out here..I know it's probably soemthing simple.but I'm stumped, and I've followed everything in the book.

H

Function Page_Load() As System.Data.IDataReader
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=F:My Documents"& _
"shopping.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)

Dim queryString As String = "SELECT [Product].* FROM [Product]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

Return dataReader
End Function

View 1 Replies View Related

DTS - Beginners Guide

Mar 22, 2001

I have "played" with DTS packages but I am now trying to do the following in an ActiveX VB script

Open a connection to database/table <---- Can't find how to do this!
Read a record from the table
Alter the content based on some rules
Post the record back to the table

Simple eh? If anyone has any examples or can point me to a good source of examples.

Many Thanks.

Geoff.

View 3 Replies View Related

Triggers For Beginners

Mar 30, 1999

Hi all,

I have just started getting stuck in to SQL Server and have a silly question - i cannot find an example trigger anywhere for

UPDATE
INSERT
DELETE

I know i can use the insered or deleted tables, but my TSQL doesn't seem to work.

Any assistance (in the form of an exmaple!) would be greatly appreciated.

Thanks in advance

Simon

View 3 Replies View Related

Beginners Question

Jul 23, 2005

This is probably straight forward, but let's see:Say I have a Family which includes an address field table and a relatedFamilyMembers table which includes an age field.I need to output a report on each Family where there is at least onefamily member with an age over 16.Any help gratefully received!

View 4 Replies View Related

Queries Used In Vîdeo For Beginners

Aug 21, 2007

Hi,

I just installed reporting services and now starting with the video tutorial for reporting services(http://msdn2.microsoft.com/en-us/express/aa718391.aspx)
In Video 10 and 11 some queries are used to demonstrate building reports. I would like to repeat the steps in the video but I need the SQL Queries used in those videos.

Does anyone have any idea where I can download those SQL queries in order to programm the same reports as shown in the videos?

Many thanks for your replies and best regards from Switzerland

Chris

View 1 Replies View Related

Resources For ABSOLUTE Beginners

Jan 26, 2007

Seems to me like microsoft mentions learning, but it's never for beginners. I haven't found a single tutorial that says how to make a simple database step by step.

Does anybody know about a tutorial focused on teaching the very basics (a kind of "hello world" application) from setting up the new database with a few sample fields to "deploying" it (making it ready to be used)?

Please let me know.

Once I'm through with these first steps there seems to be a lot of helpful learning resources meant for experienced and expert users, but I'm not there yet...



Thanks,

Bernardo

View 2 Replies View Related

Books For Sql Server Development Beginners

Dec 22, 2007

Hi,

Can anyone suggest me good books for learning sql server development ie stored procedures etc..

View 1 Replies View Related

Connect To SQL Server 2000 With VB.NET For Beginners

Sep 4, 2006

I just started to learn Visual Basic 2005.NET. I have experience with VBA in Access and SQL Server.
I
now want to build applications (client/server) with VB & SQL
Server. Does anyone have a simple example with which I can start
learning?

Thank you in advance!

View 4 Replies View Related

Can't Play Files: Video Series: SQL Server 2005 Express Edition For Beginners

Apr 20, 2006

I cannot play any of these video files in RealPlayer or in Windows Media Player. Any suggestions? Anyone else having this problem?

Thanks,

Brian

Video Series: SQL Server 2005 Express Edition for Beginners

C00D1199: Cannot play the file

View 6 Replies View Related

MDAC 2.8 Fatal Setup Error. This Setup Does Not Support Installing On This Operating System

Jan 5, 2006

I have XP Pro SP2 with MDAC 2.8.1022.  It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.

I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP.  There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs. 

There's some other strange things, so I wonder if they are related. 

1) I have Paul set up as an administrator account.  Some folders like MSSQL show that account with no permissions.  I grant all the permissions to Paul for that folder.  I come back later and the permissions are gone.

2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared.  I deleted those 7 again and then they finally went away.

3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.

 

View 12 Replies View Related

Setup And Upgrade :: 2008 R2 Setup UI Has Incomplete List Of Installed Features - Can't Uninstall RS

Jul 23, 2015

We're doing upgrades from SQL 2008 R2 to SQL 2014. This is blocked due to RS is installed but not configured. Our desired action is to uninstall RS and proceed with the upgrade. But when setuparp.exe is raised, it does not list all the features on the 'Select Features' page.  In fact, it only lists the last 2 shared features (SQ Client Connectivity SDK and Microsoft Sync Framework). However, all items appear to be listed on the 'Select Instance' page including RS. I've seen this issue on 2 of our SQL 2008 R2 Servers already.

View 3 Replies View Related

Setup And Upgrade :: Error Setup Account Privileges

Nov 15, 2015

I'm trying to install SQL Server Management studio 2012 on my Windows 7 (x64) standalone laptop.  When I click "New SQL stand-alone installation..." it runs a Setup Support Rules check and always fails "Setup Account Privileges". I've looked into the error and I keep getting that I need to change security rules but I don't have that option in window 7.  How do I get around this without having to resort to a computer running Windows Server?

I have Visual Studio 2013 premium installed along with Localdb v11.  I just want to connect and manage my database engine through SSMS when developing any application.

View 2 Replies View Related

Please Post Setup And Installation Questions In The Setup Forum

Nov 17, 2005

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

View 11 Replies View Related

Setup And Upgrade :: One Machine 6 IPs - How To Setup DNS For Server

Apr 24, 2015

I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:

MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2

If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.

View 3 Replies View Related

SQL Setup

Apr 9, 2001

Hello everyone

I know this is discussed very often, but please indulge me.
I have two hardware/software configurations for the SQL servers,
(1) NT4 + SQL7 on 2HDD's (C/D-drive) and,
(2) NT4 + SQL7 on 3HDD's (C/D/E-drive).
What will be the best configuration for SQL regarding:
a. RAID,
b. placement of the OS,
c. placement of the data & log files(devices),
d. local(hdd) backups

Regards
George

View 1 Replies View Related

SQL Setup

Jun 29, 1998

Hello!

I`m new to SQL Server, so excuse this if it`s a well-known
problem with a well-known solution.

I tried setting up SQL Server 6.5 (the box but not the
docs or install claims it`s an
upgrade product) but the install hung at "Setup is now
installing the initial SQL Server configuration" for over
10 minutes. That is, the install kept processing
something but did not appear to be coming to an end until
I killed it. This happened repeatedly, and on a second
server, too.

I then installed 6.0 (over 6.5!), and was able to install
6.5 over 6.0. However, I`m not able to install the 6.5
docs.

SQL Server appears to run (although I`ve not tried any
DB stuff).

Any suggestions? Should I uninstall and start over?

best, paul

View 2 Replies View Related

Setup

Mar 7, 2007

Hello,
This is the present setup.
Server A --> sql server 2000
Server B --> sql server 2005

On my machine I point to an instance name of sql server 2000 to use. i.e.
sqlserver2000Serverinstance1
On my local machine I have installed sql server 2000 and can use the enterprise manager. Have the Admin rights.
I have setup a daily backup job on sql 2000...

On server B, I installed sql 2005. Restored the sql 2000 backup onto sql 2005. And now I have the sql 2000 database in sql server 2005.

Now I can use the sql 2005 by refering to the serverB name (Not an instance).

In Server A, the applications are using a login name (sql authentication) i.e. username, password.

Questions
1) How do I install sql 2005 on my local machine (Remember that I have sql 2000)

2) If I should run the setup for sql 2005 on local machine, then during the installation, do I give it an instance name or should this instance name be done on the server i.e. server B ?

Thanks

View 3 Replies View Related

DTS Setup

Mar 23, 2007

Hi All

Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.

My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.

Please can you help.

Many Thanks

View 1 Replies View Related

DTS Setup

Mar 23, 2007

Hi All

Iam new to SQL and using sql2000. I have created a DTS which works as I want, but I am abit concerned about the way set-up.

My source is a Lotus notes view and my data is going to a sql table. Now when I click in 'EM/DTS/MyPackage' and then rhs click 'design package' and look how the source is being extract after double clicking the source db I get a mini window labelled 'Execute SQL Task Properties'. In the bottom part of this window their is a line labelled SQL Statement. In here there is a syntax for creating a table, exactly the same as my created table ie. the destination table. I really dont understand why this syntax is appearing here.

Please can you help.

Many Thanks

View 1 Replies View Related

Sql Setup

Aug 8, 2006

I need help with SQL Server 2005 Setup.

View 1 Replies View Related

Tables Setup

Jun 16, 2006

How would I set up a sql server database based on the following problem? I will be creating a poll based on 9 dimensions that compare two companies.
honda yamaha               performance        features        reliability        conformance        durability        serviceability        aesthetics        safety        other perceptives
The values stored would be 1 or 0 so the values can be totalled. The user will be using a web pageand will select a radio button per dimension for either honda or yamaha. Would this work?
tbl_companiescompanyid    int pkcompanyname  varchar
tbl_resultsresultsid  int pkp          int --performancef          int --featuresr          int --reliabilityc          int --conformanced          int --durabilitys          int --serviceabilitya          int --aestheticssf         int --safteyop         int --other perceptivescompanyid  int -- fk to tbl_companies.companyiduserid     int -- fk to tbl_users.userid
tlb_usersuserid    int pkusername  varcharuserip    varchar

View 2 Replies View Related

Can't Connect To Db After Web Setup

Nov 17, 2006

I have an asp 2.0 app that connects to a database in another city.
When I test this app through VS2005 is connects and works great. After I created a web setup project it goes bad.
I ran the setup on 2 different computers, including the dev machine, both start ok and bring up the applications main menu, but when I choose a menu item that is supposed to bring up a datagrid from the sql server I get an error saying it's not a trusted connection.
Any advice on where I should start looking? It's got me beat.
Thanks.

View 4 Replies View Related

SQL Server Setup

Feb 2, 2005

Hi Everybody,

I was trying to install the SQL Server on my machine and I successfully did it because the server is running. I can get into the Enterprise Manager (without password) and I'm able to create new databases. Except, I can not log into those databases with the userid that I also created with full access. It must be somekind of security issue but I can not figure out what. The message says: "Unable to connect to server local - SQL server does not exist or access denied". If I look at my SQL service manager my server name is "NEWONE" , which is also my computer name. So, I'm not sure what's wrong. I tried to log in with the 'sa' account it doesn't work either.

I would appreciate any help you can give me.

Thank you,

Laszlo

View 1 Replies View Related

Creating SQL At Setup

Feb 16, 2005

I must install web applications on many servers
how can I create a MS SQL database at setup ?

thank you

View 4 Replies View Related

Setup MSDE200A

Jun 8, 2005

Hi can you help me with this problem with msde
 
I have installed MSDE200A and i didn’t gave any password(setup BLANKSAPWD=1).
My configuration code for the connection with msde is:
  <appSettings>
     <add key="DSN" value="Initial Catalog=dyt_mac;Data Source=localhost;Integrated Security=SSPI;"/>
  </appSettings>
 
When i try to connect with the database this error occurs:
 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
 
Thank you!

View 1 Replies View Related

Setup Error

Oct 28, 2005

hello everyone,it's first time for me to write here and also to use SQL.While i was installing SQl 2000 i got Setup Message said:" Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client component will be available for installation."Hope to know what's wrong, and please guide me.Thanks alot

View 6 Replies View Related

Setup /t RegistryRebuild

Jun 23, 2001

Hi all

I have a client application which is running winnt4 sp6, sql7 sp1, gives the following error.

Msg 18458, Level 14, State 1, Server Microsoft SQL Server, Line 0
Login failed- The maximum simultaneous user count of 5 licenses for this
server has been exceeded. Additional licenses should be obtained and
registered via the Licensing application in the NT Control Panel.

I have found in technet article no Q180364, which ask to rebuild the registry of sql server. Was wondering anybody had the same experience. I can't shutdown the server more than 30 mins.

Any guidence or suggestion ?

Thanks in Advance

Jaya.

View 1 Replies View Related

Replication Setup

Jun 7, 2000

I need to replicate a database which will be updated both sides.Table doesn't have the primary key,and already has data.Please advice which replication will suit and what are the limitations.URGENT!!
Thanks!

View 1 Replies View Related

Best Hardare Setup For SQL 7.0

Jun 2, 2000

Hello all,

What is the hardware configuration for mssql 7.0 in order to achieve best performance. Some people suggest that

1. Dual Processors
2. 1G memory
3. RAID Controller
4. 2x9.2 GB RAID 1 for o/s and log files
5. 3x182. GB RIAD 5 for database

Your input is much appreciated.

Sui S

View 1 Replies View Related

Setup SQL DB- Newbie

Feb 2, 2000

Ok I have installed SQL 7 on my NT4sp4/MIIS box.
Can someone please tell me how to add a SQL DB to my website? and can I do this remotely?

Amy

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved