SQL server 7.0
Hey all!
I've have now access to SQL Server 7.0 but have no idea how it works! How do I create a database on the server which is not in the same place where i work? Do I create table using a special software, interface, or just through plain SQL?
See the problem is that I'm use to MS Access where everything is done via the MS Access interface. If I have to do with SQL, how to I pass the fonctions to the server?
Any help would be apprreciated!!
Thanks
LD
Luc Deault
----------------------------------
If the minimum wasn't acceptable it wouldn't be called the minimum
-----------------------------------
Peter J. Boettcher posted this at 20:08 — 2nd January 2002.
They have: 812 posts
Joined: Feb 2000
Even though you can do everything using Transact-SQL, save yourself a load of time and get Enterprise Manager. This will allow you to connect to your database remotely and manipulate it through a GUI.
Enterprise Manager is part of Microsoft SQL (Client Tools), so by installing this on your computer, then registering your SQL Server you'll be able to work remotely.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.