Can ANYONE Program with the sql Server Management sTudio Express

Hi All,

Has anyone been able to actually code in sql Server Management sTudio Express

I went into the sql server management studio Express

I declared a database and a test table that had the following

TestID --->unique identity -- typical config
Test --> nvarchar(10)

I then opened a new query and types

insert into test (test) values ('testline')

I clicked on Execute it said command successfully completed.

If I go back to the table and tell it to open table(right click and select opentable on test table).

There is nothing in it.

Is this suppose to work or has this interface not yet been completed

Many thanks,

Angela

Answer this question

Can ANYONE Program with the sql Server Management sTudio Express

Peter Gadsby
Hi Angela,

I'm not sure if you have been able to work through the SSMS-Express issues. We did have a refresh to SSMS-Express shortly after the first release because it was incompatable with Books-On-Line. If you uninstall, download the newer version, and install it, it should work correctly.

Bill
orit_itzhar
This may have something to do with where your database is stored:

A local database file can be included as a file in a project. The first time you connect your application to a local database file, you can choose between creating a copy of the database in your project or connecting to the existing database file in its current location.

If you choose to create a copy of the database, depending on the file settings, it is possible that a new copy of the database is being created each time the project is run, overwriting the version that contains your changes. For more information, see How to: Manage Local Data Files in Your Project http://msdn2.microsoft.com/library/ms246989

Hope this helps,
Steve Hoag
Visual Basic Express
RKumarB
HI Steve,

Thanks for the treply but that didn't help. I am not using anything except fo rthe SQL Server express area. So I haven't installed the Visual Studio Express yet.

UI might have posted this in the wrong area. But I couldn't find wher ethey are talking about sql server express.

Many thanks for you response though!

Angela
Ehr
Hi Angela,
Thank you for your bug report. This should have worked just fine. In a query editor, if you type the following:
insert into test (test) values ('testline')
go
Select * from Test
go

Do you see the results of the insert after execution
Thank you,
Bill Ramos
ICantThinkOfAGoodOne
Hi Bill,

<<Command(s) completed successfully.>>

That is all I get when I see your above query.

Everything was working before I installed bookonline and samples. My CTP quite working at the time.

I have gone through several system restores and uninstalls (the beta program remover you guys provide) for the June CTP I had on my machine.

With no avail I can not get it working again. All I have loaded now is the basics for the November install windows installer 3.0, Express DB, the CTP, .NET 2.0 and that MSXML thing

What some of us (other users who are having different problems) realized that when we downloaded

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=135986&SiteID=1

the CTP from the link in that thread we are *NOT* getting the right version.

I have tried downloading it on a fresh machine (my test server) that has never had Express on it. And i am still getting the wrong version. The version I am getting is 11/3/2005 and not the updated version of 11/10/2005. The file size that gets downloaded is 30668 and not 30666.

I am unwilling to install it on my test server (the one i did the downloading to that has no express on it) when it is the wrong version. I do not want to rebuild two machines.

Do you have another link I can use to download the newest CTP version

Basically my whole development machine is hosed, right now because restoring in XP is not working properly. I would love an alternative to removing this aside from rebuilding my machine from scratch(format to wipe hard drive). The system restore before I started installing the November addition doesn't seem to work. Does not restore properly. I have done that twice, uninstalled the betas three times and installed the basics 3 times now.

And I can not get it to work again.

Any suggestions, is greatly appreciated :^)

Do you have a different link then the one mentioned in the other thread that I can download the CTP with

Yours in deepest gratitude,

Angela

PS I think I might ahve posted in the wrong area with this post. I have not put on studio express. Only Sql Server Express but I couldn't find a sql express forum.
Can ANYONE Program with the sql Server Management sTudio Express

Answer this question