Professional Web Applications Themes

Generate Table script from query yzer... - Microsoft SQL / MS SQL Server

You can use SQL-DMO to do that but not straight tsql. -- Andrew J. Kelly SQL Server MVP "Robert Taylor" <roberttrtnetworks.com> wrote in message news:0f8201c34639$275ef2c0$a501280aphx.gbl... > Is there a way/stored procedure that can be run from query > yzer that will write a CREATE object script like > Enterprise Manager can, only from QA? > > Thanks for any ideas or help. > > Robert Taylor...

  1. #1

    Default Re: Generate Table script from query yzer...

    You can use SQL-DMO to do that but not straight tsql.


    --

    Andrew J. Kelly
    SQL Server MVP


    "Robert Taylor" <roberttrtnetworks.com> wrote in message
    news:0f8201c34639$275ef2c0$a501280aphx.gbl...
    > Is there a way/stored procedure that can be run from query
    > yzer that will write a CREATE object script like
    > Enterprise Manager can, only from QA?
    >
    > Thanks for any ideas or help.
    >
    > Robert Taylor

    Andrew J. Kelly Guest

  2. #2

    Default Re: Generate Table script from query yzer...

    Thanks,

    I saw the sql-dmo, but was hoping for tsql.

    Thanks for taking the time to answer my question.

    Robert


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Robert Taylor Guest

  3. #3

    Default Re: Generate Table script from query yzer...

    Dinesh,

    Thanks. That looks like a good alternative.

    Robert

    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Robert Taylor Guest

Similar Threads

  1. Replies: 1
    Last Post: May 31st, 08:56 PM
  2. Replies: 0
    Last Post: May 18th, 11:33 AM
  3. Generate csv file from sql table
    By ththomps in forum ASP Database
    Replies: 3
    Last Post: May 5th, 02:16 AM
  4. Replies: 9
    Last Post: October 24th, 02:25 PM
  5. Replies: 1
    Last Post: July 2nd, 09:09 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