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
No comments:
Post a Comment