Unable to create new table in DB Explorer

eddiemcham · May 29th, 2009, 02:57 PM

Hello,

After going through the Planet Wrox project in this book, I am now trying to customize some of these exercises to our specific project, and I am running into a problem with adding new DB tables.

Our project has 2 SQL DB instances added via DB Explorer. The actual SQL Server box is physically located at our HQ about 5 hours' drive from me. The IT director assures me I have full DBO permissions for our 2 instances, and I am attempting to test them now.

I am able to see and expand both instances, and I am able to open and update existing table records. But when I try Step 2 on page 373 of the book (right-click the Tables node and choose Add New Table), I get the following error message:

This feature is not supported by Microsoft Visual Web Developer Express.

Can anyone please help? This is my very first ASP.NET project, and I've been having a rather rough time getting it off the ground.

Thanks, Eddie

Imar · May 29th, 2009, 05:47 PM

Hi there,

I am not 100% sure (never ran into this) but it seems that creating new tables in a remote server is not supported.

Have you tried SQL Server Management Studio Express? It's a management tool for SQL Server and it should allow you to create new tables.

http://www.microsoft.com/express/sql/download/

Cheers,

Imar

eddiemcham · May 29th, 2009, 06:00 PM

Hello Imar,

Thank you (again!) for your quick reply.

Yes, I have SQL Server Management Studio Express, and it's working fine. I was just under the impression that I could create new SQL DB tables remotely from VWD as well.

I'm able to proceed with the project now. Next item on my to-do list is the whole user login/password/profile thing. If I can get past that, I think the rest will fall into place in fairly short order. (Or so I hope.)

Cheers! ~ Eddie

Imar · May 29th, 2009, 06:03 PM

Maybe you can, maybe you can't ....;-) I guess we'll have to ask Microsoft. Although I wrote the book using the Express Edition, I normally use the commercial versions of VWD, so I am not really aware of all the Express edition's limits....

Glad you can at least continue....

Imar