Adding tables to SQL server database in visual studio?

Hi

I keep reading it's possible to add, amend ,etc. tables in visual studio but to do so I need access to the features that allow this.
I can connect to the database but I haven't been able to use any of these database features since they are "blanked" out.
Obviously, I can do all this at the server but ideally I would like to do it remotely.

Any suggestions?
Thanks in advance.In your server explorer, can you navigate to the tables?
-Servers
- <your server>
- SQL Servers
- <your SQL server>
- <your database>
- tables

From there you should be able to add, change, or delete tables.

-Ian|||Hi Ian

Thanks for the reply.

I can navigate to the tables but the menu features are not available for adding,etc. tables.
Could it be something at the server end that I need to change?

Thanks in advance.sql

Adding Disks

I would like to add another volume to my two node sql 2005 cluster. From
what i have been reading i need to shut one of the cluster nodes, add
the drive to the cluster then bring the backup node back on line. Am i
missing anything?
Thanks for the help
Noah Hamilton
Sr Systems Administrator
Carpathia Hosting, Inc
21711 Filigree Court, Suite A
Ashburn, VA 20147
voice: (703) 297-4451
Fax: (703) 997 5577
www.carpathiahost.com
Once you have physically connected the disk (or carved a new LUN and
presented it to the host computers), you must create a clustered resource.
Use the cluster admin tool to create a disk resource and map it to the
physical disk. I usually create a temporary resource group to park it in
while I am setting things up. Test failover to make sure all host nodes can
"see" and use the clustered disk.
You then can move the disk into the SQL resource group. Finally, you must
make the SQL Service dependent on the new disk before SQL will use it for
data or logs. This will require stopping the SQL service while the
dependencies are changed.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Noah" <noah@.carpathiahost.com> wrote in message
news:%23$wrjlp2HHA.4584@.TK2MSFTNGP03.phx.gbl...
>I would like to add another volume to my two node sql 2005 cluster. From
>what i have been reading i need to shut one of the cluster nodes, add the
>drive to the cluster then bring the backup node back on line. Am i missing
>anything?
> Thanks for the help
> Noah Hamilton
> Sr Systems Administrator
> Carpathia Hosting, Inc
> 21711 Filigree Court, Suite A
> Ashburn, VA 20147
> voice: (703) 297-4451
> Fax: (703) 997 5577
> www.carpathiahost.com
>
|||Thanks for the help. I have the new drives up and running now.
Appreciate all the help.
Geoff N. Hiten wrote:
> Once you have physically connected the disk (or carved a new LUN and
> presented it to the host computers), you must create a clustered
> resource. Use the cluster admin tool to create a disk resource and map
> it to the physical disk. I usually create a temporary resource group to
> park it in while I am setting things up. Test failover to make sure all
> host nodes can "see" and use the clustered disk.
> You then can move the disk into the SQL resource group. Finally, you
> must make the SQL Service dependent on the new disk before SQL will use
> it for data or logs. This will require stopping the SQL service while
> the dependencies are changed.
>