SQL server - creation of database

SQL server - creation of database

Post by maol » Sat, 08 Jul 2006 15:52:38


Hi

I am a newbie and I want know how to do following in SQL server:

- How can I add a database
- How can I add tables and data to it
- How can I make a DSN entry for the database created in DB and use it.

Regards
 
 
 

SQL server - creation of database

Post by Andrea Mon » Sat, 08 Jul 2006 21:13:45

hi,


in order to create new database you have to connect to the Server instance
and execute the appropriate Transact-SQL command... this can be done via the
provided command line tool, oSql.exe, as described in
http://www.yqcomputer.com/ ;EN-US;q325003 ..
if you are using MSDE (SQL Server 2000 code based free version, for your
convenience, you can perhaps have a look at a free prj or mine, available at
the link following my sign, which provides a graphical user interface
similar to Microsoft Enterprise Manager to perform database's and tables
management..

if you are using the current SQLExpress version, code based on SQL Server
2005, you can download the free graphical management tool provided by
Microsoft (SQL Server Management Studio Express) at
http://www.yqcomputer.com/

as regard adding "data"... SQL Server is not like Access, which provides an
"all in one" tool/interface to manage objects and interact with data... this
task is usually perfomed via "client tools", and actually via applications
interacting with the Database Server... Access an be one of them, as long as
Web or Win applications...

why are you required to define a DSN? nowdays usually DSN-less connections
are used to interact with databases..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.yqcomputer.com/ http://www.yqcomputer.com/
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply