Rank: ? (4278)
Member #: 5260

Have anyone use MS SQL Server?

Is it hard to use or install?

Rank: ? (2172)
Member #: 11609

It's Microsoft, so I know it's not free.

No, I have not used it, and don't really plan to.

I think it uses the same basic SQL syntax/language though...

Rank: ? (4278)
Member #: 5260

The reason why I asking is that I would like to learn different server-based databases. I had learned using Oracle and with limited amount of exposure to DB2 when I was studying, but I've never touched MS SQL Server before.

There are quite number of differences between using Oracle and MySQL in the syntax, and the Oracle have the added functionality of PL/SQL scripting.

I am wondering if SQL Server have some of the GUI tools that Access have.

Rank: ? (46)
Member #: 4517

SQL Server has a GUI interface somewhat like Access but you can't make forms in it like you can in Access. I believe the GUI is called the Enterprise Manager - you can even use it for remote access and administration. At one point Microsoft had an 180 demo floating around on their Web site or a CD. Install from CD is brain dead simple. No harder than any other Windows install

I have jumped around between SQL Server, Access, MySQL and SQLite using the same basic SQL syntax and not had to make many adjustments at all. I'm not the most sophisticated database user/developer but the basic SELECT, UPDATE, INSERT, and DELETE statements seem to works the same no matter which DB I am using

Rank: ? (3)
Member #: 14630

Hi, storyteller.

There is a toned down version of MS SQL Server called MS SQL Desktop Engine.

Link to MSDE

I believe it would be just perfect for getting to know MS SQL before diving into the bigger Server version.

Just my opinion. Hope this helps.

Rank: ? (2)
Member #: 14634

Hi, storyteller
I am using MS SQL for last 3 years. it is very good and user friendly to use. Help given for MS SQL is enough to learn it.

Rank: ? (4821)
Member #: 3416

since we're talking about ms sql server already, does anyone know of a free program i can use to connect to an ms sql server and view / edit stored procedures? that or a reference to sql statements that will let me at least view them? i am working on a website that was unfortunately set up with a crappy host and is using iis and ms sql, and i can't find a way to do anything with stored procedures other than call them with asp.

Rank: ? (46)
Member #: 4517

quick googling turned this up:

http://www.toadsoft.com/index.htm

good luck

Rank: ? (4821)
Member #: 3416

thanks, i'll give that a try . . . i didn't find anything when i was looking about 6 months ago . . .

Rank: ? (4821)
Member #: 3416

seems to not work unless you have ms sql already installed on your computer . . .

Rank: ? (3)
Member #: 14630

storyteller,

If you download and install MSDE, you'll need an admin program for it. MSDE does not come with a GUI tool for management. So try this one:

Link to MyLittleAdmin for MSDE

Rank: ? (4278)
Member #: 5260

It has been a while since I check the Database forum, and I forgot that I left a couple of posts, here and there.

Thanks to all you guys. I will tried this MSDE hrp2171. Going to those links now.

Just out of curiosity, what current version of MS SQL Server now?

Rank: ? (3)
Member #: 14630

MS SQL Server is up to version 2000 or 8.oish.

The codename for the next version is Yukon.

I'm guessing the end-product name will be MS SQL Server .NET or something else off-the-wall like that. LOL

Off Topic:

I don't know why MS didn't just use the name Windows XP Server instead of Windows Server 2003.

Rank: Unregistered

How does 1 connect 2 ms-sql server in a c++ program.

Rank: ? (1)
Member #: 25590

how encrypt stored procedure