Hi
I want to start to use SQL Server 200 Express but have no idea where to enter the SQL queries and view the results.
I installed SQL Express and under Start > Programs > SQL Server 2005 I only have Configuration Tools which has Configuration Manager, Error and Usage Reporting and Surface Area Configuration.
SQL Server and SQL Server Browser Services are running but I have no clue of from to start creating my database, tables, etc etc.
I have a background of MySQL and used MySQL's command line tool and phpMyAdmin, so SQL is not a problem.
Thanks
Starting to use SQL Server 200 Exp
Hot Topic
- Using stored procedure as OLE DB source with parameters from package variables
- Package Templates?
- SQL 2005 CTP - Basic Question
- Scripting: Dumb Q.. How can I store a DTS variable inside a script variable?
- How to generate a report containing multiple single page reports
- SQL help
- SQL Server 2005 Notification Services and IIS
- Use Partial or No_Cache mode in Lookup task
- upgrade sql 2k std to sql2k5 problem with Reporting Services
- Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)
SQL Server
- Best Practices Analyzer for Sql Server 2005
- Why is sort so slow?
- beta3
- Which SQL version to install for Windows XP, and be able to create new databases and tables.
- LIKE % question
- Stopping automatic reconnect of SQL tools
- replication component missing error while installing Sql Mobile2005
- Concatenate field based on unique id.
- analysis service DTS keeps failing . ERRORSOURCE = DSO
- Text Qualifier {"} Not Working
Starting to use SQL Server 200 Exp
vistalad
Hi
I believe you are looking for SQL Server Management Studio Express. Have a look here.
HTH
lalbertoth
Starter Kits [Starter Kits are fully functional sample applications designed to help you learn SQL Server and accomplish common Web and client development scenarios. Each sample is complete and well-documented so that you can use the code to kick start your application development projects today!]
Get Started with SQL Server Express [SQL Server Express Edition, a free product based on SQL Server 2005 technology, includes the unique Application XCopy feature, and networking and security that differ from other SQL Server 2005 editions. This article discusses these topics and the integration of SQL Server Express with Visual Studio 2005. We also compare this product with the existing Microsoft free databases like MSDE and Jet. (19 printed pages)]
For more : SQL Server 2005 Express Edition or SQL Server Express Developer Center.
BTW, there is a Microsoft SQL Server Learning Page...
csqepaul
But Im looking for an interface to perform my sql queries.
I understand that theres MS SQL Web Administration utility but Im looking for a desktop-app as I intend to make desktop-app that connect to the SQL Server Exp database.
Chickenwing
I looks like this section is for people who has started to use Sql Server,
well my question, I create a database with SQL Server Management Studio Express but I have no idea how to
bring it to my website, well I create a website with VWD and I create a database outside with SQL Server
Management Studio Express because it was more easy to create and setup the login and security options.
Now, I need to use that database that I made to connect with my site that I have create with VWD, How can I
connect both together The database and my site.
If I am in the wrong section can someone redirect me to the rigth link,
Thank you,
New User.