Click to See Complete Forum and Search --> : Questions about sql server and asp
Hi!
i'm new to sql server db and have some questions:
1. Is there a management tool like phpmyadmin for sqlserver?
2. Is sqlserver basically the same as mysql?
thank
buntine
06-12-2004, 12:49 AM
Its alot different from MySQL. This should answer all of your questions.
http://www.microsoft.com/sql/default.asp
thank for the link but have already see it!
But what i need to know is the way to fill content, create table, etc... in a sql server db!
I'm just the webmaster so the db is already create. The only thing i have to do is to fill it with sql request, as i guess, will be the same sql request as i use for mysql db!
I know i can fill content and create table using asp file, but was just wondering if there any online tools like phpmyadmin to only manage the content of the sql server db!
Hope i'm a little clear,
turb
simflex
06-12-2004, 09:13 AM
there is a tool in sql server called query analyer.
From Enterprise manager (EM) go to tools and select query analyzer.
It allows you to perform all sorts of ddl functions.
maybe you'll find this question stupid but can i access this "query analyzer" if the database is on a host server?
Alex C
06-12-2004, 02:48 PM
Originally posted by turb
maybe you'll find this question stupid but can i access this "query analyzer" if the database is on a host server?
Shouldn't you have Terminal Services access to the server so you will be able to run Enterprise Manager?
Regards,
Alex