August 23rd, 2003, 08:57 PM
where to create a new DB with scripts
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.
August 23rd, 2003, 11:01 PM
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.
August 23rd, 2003, 11:40 PM
script in access project?
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?
August 24th, 2003, 12:06 AM
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.
August 24th, 2003, 11:23 AM