Professional Web Applications Themes

Server Explorer in VS.Net - Microsoft SQL / MS SQL Server

Hi, I've created a database using Server Explorer in VS.Net 2003 pro and would like to generate the sql script necessary to reproduce the database if I need to start over. However, no matter what I do the "Generate Create Scripts..." option remain greyed out on the menu. Does anyone know how I go about generating scripts or how to get this menu item enabled? I've connected to the database Ok and have gone through the properties menu to test the connection, which seems Ok. Where am I going wrong? Thanks Steve...

  1. #1

    Default Server Explorer in VS.Net

    Hi,
    I've created a database using Server Explorer in VS.Net 2003 pro and
    would like to generate the sql script necessary to reproduce the database if
    I need to start over. However, no matter what I do the "Generate Create
    Scripts..." option remain greyed out on the menu.

    Does anyone know how I go about generating scripts or how to get this menu
    item enabled? I've connected to the database Ok and have gone through the
    properties menu to test the connection, which seems Ok.

    Where am I going wrong?

    Thanks
    Steve


    Steve Barnett Guest

  2. #2

    Default Re: Server Explorer in VS.Net

    The user name used by your application may not be having permissions to
    access those database objects. Verify that.

    --
    HTH,
    Vyas, MVP (SQL Server)
    [url]http://vyaskn.tripod.com/[/url]
    What hardware is your SQL Server running on?
    [url]http://vyaskn.tripod.com/poll.htm[/url]




    "Steve Barnett" <nonamenodomain.com> wrote in message
    news:OQ8$CrxPDHA.2832TK2MSFTNGP10.phx.gbl...
    Hi,
    I've created a database using Server Explorer in VS.Net 2003 pro and
    would like to generate the sql script necessary to reproduce the database if
    I need to start over. However, no matter what I do the "Generate Create
    Scripts..." option remain greyed out on the menu.

    Does anyone know how I go about generating scripts or how to get this menu
    item enabled? I've connected to the database Ok and have gone through the
    properties menu to test the connection, which seems Ok.

    Where am I going wrong?

    Thanks
    Steve




    Narayana Vyas Kondreddi Guest

  3. #3

    Default Re: Server Explorer in VS.Net


    Steve,

    Look at the reply I posted for the question you posted in the
    'microsoft.public.vsnet.general' newsgroup titled "Server Explorer Scripts"

    Srinivas Kanakapally
    VS .Net Data Tools, MSFT
    This posting is provided "AS IS" with no warranties, and confers no rights.

    --------------------
    >From: "Steve Barnett" <nonamenodomain.com>
    >References: <OQ8$CrxPDHA.2832TK2MSFTNGP10.phx.gbl>
    <OINkB#zPDHA.3088TK2MSFTNGP10.phx.gbl>
    >Subject: Re: Server Explorer in VS.Net
    >Date: Tue, 1 Jul 2003 08:32:44 +0100
    >Lines: 51
    >X-Priority: 3
    >X-MSMail-Priority: Normal
    >X-Newsreader: Microsoft Outlook Express 6.00.2800.1123
    >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1123
    >Message-ID: <OxDG7L6PDHA.1748TK2MSFTNGP11.phx.gbl>
    >Newsgroups: microsoft.public.sqlserver.programming
    >NNTP-Posting-Host: host213-122-153-56.in-addr.btopenworld.com
    213.122.153.56
    >Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP11.phx.gbl
    >Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.programming:34015
    >X-Tomcat-NG: microsoft.public.sqlserver.programming
    >
    >I have access. I created the database in the first place and have tested
    the
    >connection to confirm that I can get at it. Since I'm using the development
    >environment, I must be using the integrated NT security, which makes me the
    >owner of the database.
    >
    >I read something somewhere that said this functionality may not be
    available
    >in VS.Net pro... do you know how I might confirm that?
    >
    >Thanks
    >
    >Steve
    >
    >
    >"Narayana Vyas Kondreddi" <answer_mehotmail.com> wrote in message
    >news:OINkB#zPDHA.3088TK2MSFTNGP10.phx.gbl...
    >> The user name used by your application may not be having permissions to
    >> access those database objects. Verify that.
    >>
    >> --
    >> HTH,
    >> Vyas, MVP (SQL Server)
    >> [url]http://vyaskn.tripod.com/[/url]
    >> What hardware is your SQL Server running on?
    >> [url]http://vyaskn.tripod.com/poll.htm[/url]
    >>
    >>
    >>
    >>
    >> "Steve Barnett" <nonamenodomain.com> wrote in message
    >> news:OQ8$CrxPDHA.2832TK2MSFTNGP10.phx.gbl...
    >> Hi,
    >> I've created a database using Server Explorer in VS.Net 2003 pro and
    >> would like to generate the sql script necessary to reproduce the database
    >if
    >> I need to start over. However, no matter what I do the "Generate Create
    >> Scripts..." option remain greyed out on the menu.
    >>
    >> Does anyone know how I go about generating scripts or how to get this
    menu
    >> item enabled? I've connected to the database Ok and have gone through the
    >> properties menu to test the connection, which seems Ok.
    >>
    >> Where am I going wrong?
    >>
    >> Thanks
    >> Steve
    >>
    >>
    >>
    >>
    >
    >
    >
    Srinivas Kanakapally [MSFT] Guest

Similar Threads

  1. Cannot end process explorer.exe on Windows 2003 server
    By novice in forum Windows Server
    Replies: 1
    Last Post: June 10th, 10:42 PM
  2. Replies: 0
    Last Post: November 5th, 07:17 PM
  3. how to un install i explorer...not internet explorer
    By Elijah in forum Windows Setup, Administration & Security
    Replies: 0
    Last Post: July 17th, 02:09 PM
  4. Replies: 1
    Last Post: July 17th, 04:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139