new to database

hello
I have developed applications but never used and created a database. .now I must make a database and I must reach it from 3 or 4 computer.database will not be huge. can I do this freely with sql? if not what do you suggest?

well you want to create a database and access it from someother machines i believe......if i understood it wrongly pls correct me you need to create linked server to access thosedbs from some other machines and run queries on them...

refer, http://technet.microsoft.com/en-us/library/ms186312.aspx > for db creation

http://technet.microsoft.com/en-us/library/ms176061.aspx > using T-SQL

refer ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6ef578bf-8da7-46e0-88b5-e310fc908bb0.htm about linked servers

|||To speak in common, SQL Server is the scalable RDBMS of Microsoft. It scales up to thousands of clients and connections at a time. YOu should start at the http://www.microsoft.com/sql to see all the deature SQL Server provides. To keep a short answer, yes this could be the appropiate solution for you. Depending on your needs you will have to pick one edition from the available one which fits your needs (and budget).

See the different editions here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

New release of SqlClrProject

I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.
I have re-created this as an Add-In for VS, so you now have the ability
to automatically deploy from inside of VS as well as debug! I have also
created a GUI front-end for those who don't use VS which allows
deploying of assemblies using this front-end (setting properties etc).
So what exactly does all this do:
The SqlClrProject is a project type for Visual Studio 2005 for creation
and deployment of assemblies to SQL Server 2005. It consists of
templates for both Visual C# (C#) and Visual Basic (VB) with skeleton
code for creation of CLR methods to be used as stored procedures, User
Defined Functions (UDF's), triggers, User Defined Types (UDT's) and User
Defined Aggregates (UDA's). Some of the features are:
* Ability to deploy the assembly to SQL Server and create the SQL
Server methods, all from inside the Visual Studio IDE.
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
* Debug facilities from inside VS.
For you who have used the SQL Server Project project type from VS to do
this, you may wonder what the differences are. Things that the
SqlClrProject allows you to do, which the VS SQL Server project can't
do:
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
Anyway, if you are interested you can download all needed from here:
[0].
Un-zip the file and read the README.txt file in the root directory.
Comments are as usual very welcome!!!
Finally I wish you all a very Happy New Year!!!
Niels
[0]: http://staff.develop.com/nielsb/cod...ropAndAddIn.zip
****************************************
**********
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
****************************************
**********Thanks Niels! I'll check it out. It would be to put up at Channel9
sandbox if you get a chance.
William Stacey [MVP]
"Niels Berglund" <nielsb@.develop.com> wrote in message
news:Xns97388D87ACF40nielsbdevelopcom@.20
7.46.248.16...
>I thought I better post before this year ends. :-)
> Anyway, you may know that I have developed a MSBUILD task dll for
> deployment of SQLCLR assemblies. I also created some templates for use

New release of SqlClrProject

I thought I better post before this year ends. :-)
Anyway, you may know that I have developed a MSBUILD task dll for
deployment of SQLCLR assemblies. I also created some templates for use
from with Visual Studio 2005, the SQLCLRProject.
I have re-created this as an Add-In for VS, so you now have the ability
to automatically deploy from inside of VS as well as debug! I have also
created a GUI front-end for those who don't use VS which allows
deploying of assemblies using this front-end (setting properties etc).
So what exactly does all this do:
The SqlClrProject is a project type for Visual Studio 2005 for creation
and deployment of assemblies to SQL Server 2005. It consists of
templates for both Visual C# (C#) and Visual Basic (VB) with skeleton
code for creation of CLR methods to be used as stored procedures, User
Defined Functions (UDF's), triggers, User Defined Types (UDT's) and User
Defined Aggregates (UDA's). Some of the features are:
* Ability to deploy the assembly to SQL Server and create the SQL
Server methods, all from inside the Visual Studio IDE.
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
* Debug facilities from inside VS.
For you who have used the SQL Server Project project type from VS to do
this, you may wonder what the differences are. Things that the
SqlClrProject allows you to do, which the VS SQL Server project can't
do:
* Automatic creation of T-SQL deployment scripts.
* Automatic creation of T-SQL DML scripts for testing of the created
objects.
* Ability to alter an assembly and only deploy newly added methods
from the assembly.
* Ability to create objects in a non default schema
"schemaname.objectname".
Anyway, if you are interested you can download all needed from here:
[0].
Un-zip the file and read the README.txt file in the root directory.
Comments are as usual very welcome!!!
Finally I wish you all a very Happy New Year!!!
Niels
[0]: http://staff.develop.com/nielsb/code...opAndAddIn.zip
**************************************************
* Niels Berglund
* http://staff.develop.com/nielsb
* nielsb@.no-spam.develop.com
* "A First Look at SQL Server 2005 for Developers"
* http://www.awprofessional.com/title/0321180593
**************************************************
Thanks Niels! I'll check it out. It would be cool to put up at Channel9
sandbox if you get a chance.
William Stacey [MVP]
"Niels Berglund" <nielsb@.develop.com> wrote in message
news:Xns97388D87ACF40nielsbdevelopcom@.207.46.248.1 6...
>I thought I better post before this year ends. :-)
> Anyway, you may know that I have developed a MSBUILD task dll for
> deployment of SQLCLR assemblies. I also created some templates for use