Newbie wants help!!

Hi,

I'm completely new to MS SQL Server! I know NOTHING!!!!I need tutorials, or just show me how to make a database.

Thanks in advance!!!

Costas

Anyone please?

Anyone?

Hi!

Seems you have desperate need to learn SQL Server. Everything depends upon which level of knowledge you want to have in SQL Server. I meant, do you want to become expert of SQL Server, or just better knowledge to work on SQL Server for programming needs in .NET.

If you want to be expert, try - (For SQL Server 2000)
Inside SQL Server (bit of knowledge needed)
-OR-
SQL Server in 21 Days (simple book to start, no knowldge required)

You can also try this book -
MS SQL Server DBA Survival Guide

Reply us.. what level you want ? So that I can tell you about more books.

- Som Dutt
http://doeaccpapers.com
http://somdutt.blogspot.com

Hi !

I forgot to reply your second problem - "just show me how to make a database".

There are several ways- (Goto Query Analyzer)
Create Database MyDB

Simply creates a database in your 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'

Although, you must specify all the required things like this -

USE master
GO
CREATE DATABASE MyDB
ON
( NAME = My_DB,
FILENAME = 'f:',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'DB_log',
FILENAME = 'G:',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO

This would create the Data File in F Drive and Transaction Log in G Drive. This is mandatory practice to place Data File and Transaction Log in different Drives. (Everything depends upon your needs).

Ask anything more ..

-Som Dutt
http://doeaccpapers.com
http://somdutt.blogspot.com

Well, to become an expert, first you have to just learn the SQL Server. I figured out how to make a database (in SQL Server 2005) and how to make tables in it. Now, I don't know how to interact it through VC++(select items from tables, add new data e.t.c.). If you(som butt) or anyone else could help would be appreciated!!

Costas

Hi !

If you have installed SQL Server in your C drive, you can find some samples which may help you in VC++.

The location is -
C:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Samples\ado\cpp\

If you have problems connecting database, reply me..

- Som Dutt
http://doeaccpapers.com
http://somdutt.blogspot.com

Thanks!!!

Hey som_butt, I can't find the directory you're telling about!! The problem may be that I installed it with the MS Visual Studio(I mean they were in the DVD and they were installed at the same time). Please, show some tutorials or something of how to connect into a database through C++.

Thanks Again!!

Costas

Hey guys,

I need some help. Any tutorials of how to interact SQL Server 2005 through C++ would be appreciated.

Thanks in advance!

Costas

Anyone? Please I really need some help!

Anyone? Oh, come on guys! I need help! Any tutorials or something?