SQL Server Management Studio - Connected...Now what?

Discussion in 'Databases' started by Arxaios, Jul 6, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Arxaios

    Arxaios

    Hi all,

    well I have 2 basic questions. I successfully connected to my new SQL 2005 database using SQL Server Management Studio 2005. I see a bunch of databases now, including mine. But I am confused a lot.

    1) How Can I create a new table now? How can I edit this table, add data etc...?
    e.g I cannot find a way to create a connection in Visual Studio.
    (Actually I managed to connect throught Management Studio and I can do nothing more - I just see my database!)

    2)In my home I use Visual Studio 2005 and I cannot have the luxury to buy SQL Server 2005. (I can use it in my company computer but actually I only have time to develop at home). Can I also connect to my database throught SQL Express which is included in my Visual Studio package?


    I will appreciate your help.
     
    Arxaios, Jul 6, 2006
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    If you would like to copy one table to the DASP SQL server, you can use SSMS (not SSMSExpress - function omitted) - Right Click on the database - tasks - export data and follow the wizard. Please make sure that the local table is created by the dbo schema (dbo user)because if it uses another schema besides dbo, the other schemawill be created on the DASP server
    Example:

    local DASP
    dbo.tblCustomers --->dbo.tblCustomers
    new.tblCustomers ---> new.tblCustomers - Now you will need to grant appropiate permissions to the schema or transfer authorization to the dbo


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Jul 7, 2006
    #2
  3. Arxaios

    Arxaios

    Ok problem solved.

    It seems that when I tried to login using a login name which I created in the control panel, I did not have access to create database tables etc.
    I logged in now using the provided master database login and everything worked fine.

    Just another question now

    I had created a SQL 2005 Expredd Database in my local machine using Visual Studio.
    Can I copy this table with its data to the DiscountAsp.net remote database?

    I know I can attach the whole database but this would delete the existing attached database.
    So I prefer to copy only 1 table if possible.


    Thanks
     
    Arxaios, Jul 7, 2006
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page