December 15, 2008 at 12:04 pm
At home I have installed SQL server 2005 and the compact edition also installed is SQL Server configuration manager and SQL Server Management studio Express. With these tools I have created a simple database and used VB2005 to insert delete find and browse a table.
The trouble is I have used books and the internet to learn to do these things and I really need more understanding of alternative methods.
I am working on a project at college, where the techs have installed Server 2005 and SQL Server configuration manager but not SQL Server Management studio.
I cannot figure out how to create a database without SQL Server Management studio. Is it possible is so how?
December 15, 2008 at 12:26 pm
You can create databases with any application that allows you to connect to the server and issue SQL commands. You could download any one of many query tools out there, like Toad for SQL Server, and create databases. I think SSMS is the best tool, but that is just my opinion. Or, you can create your own application in .NET that either uses ADO.NET to issue SQL commands or SMO to create and manage databases.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 15, 2008 at 12:51 pm
I agree with Jack on this. SSMS is a pretty good tool, but you don't have to use it. As a matter of fact, you might be much better off only learning the TSQL syntax as opposed to having to poke & click your way through the GUI. Just one example, it takes six mouse clicks and two tabs when creating a table to define the column name, data type, make it non-nullable and make it an identity column where as:
...ColumName int NOT NULL IDENTITY(1,1)...
is done as fast as you can type and I can type a lot faster than I can click around the screen with a mouse.
So, you can do it all through a TSQL connection, it'll just require picking up the DDL commands.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 16, 2008 at 10:22 am
Thank-you I will try now.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply