Hellow, I'm new in MS SQL. in Oracle we can use sqlplus to run a script created elsewhere.
Where and how can I run a sql script to create my database?
Is there any ghrapfical tools to manage tables and to create triggers or indexes? what are the basic steps to enter and manage my tables.
:D
SQL Server includes many client tools for your server.
Enterprise Manager, a graphical manager for sql server(s), DTS to transfer data in/out/between servers, Query Analyzer to run SQL directly (where you will run your sql script) are some. There are also profilers and other tools to help optimize your sql.
You can use Access 2000+ as a graphical front end too. Access Data Project files are designed as a client/server front end for SQL Server. You can do nearly everything from an adp as you can in Enterprise Manager.
Thanks Doug, my problem is that I’ve got the msde version and therefore, don't have those tools. My only option at the moment is access. I’ve already open the project, but where can I run the script in there?
if all you have is access that's not really msSQL, but there's view options and you can select 'SQL view', there you can paste SQL code and run it.
I usually use Query Analyzer for scripts. I don't know of a direct equivalent in an adp project. You can wrap your script in a quick stored procedure is one way.