Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. SQL Server, you are starting to annoy me

SQL Server, you are starting to annoy me

Scheduled Pinned Locked Moved The Lounge
databasesql-servervisual-studiosysadmintutorial
24 Posts 10 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • OriginalGriffO Offline
    OriginalGriffO Offline
    OriginalGriff
    wrote on last edited by
    #1

    Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

    Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

    "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
    "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

    N C L S S 6 Replies Last reply
    0
    • OriginalGriffO OriginalGriff

      Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

      Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

      N Offline
      N Offline
      Nagy Vilmos
      wrote on last edited by
      #2

      It's a view of a system table, query that and print the results...


      Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

      OriginalGriffO 1 Reply Last reply
      0
      • OriginalGriffO OriginalGriff

        Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

        Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

        C Offline
        C Offline
        CPallini
        wrote on last edited by
        #3

        You may ask for help in the Q&A: there is a very knowledgeable Welsh guy...

        If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
        This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
        [My articles]

        OriginalGriffO A 2 Replies Last reply
        0
        • C CPallini

          You may ask for help in the Q&A: there is a very knowledgeable Welsh guy...

          If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
          This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
          [My articles]

          OriginalGriffO Offline
          OriginalGriffO Offline
          OriginalGriff
          wrote on last edited by
          #4

          :thumbsup:

          Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

          1 Reply Last reply
          0
          • N Nagy Vilmos

            It's a view of a system table, query that and print the results...


            Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

            OriginalGriffO Offline
            OriginalGriffO Offline
            OriginalGriff
            wrote on last edited by
            #5

            Thanks, I found that on t'interweb - I wasn't after an answer, I just wanted to release some frustration. :laugh: But seriously, why the heck not add it? It's a pretty obvious thing to want, I would have thought? Ah. This is Microsoft, I forgot. "If the user is likely to want it, they can go stuff themselves" - silly me! :-D

            Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

            "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
            "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

            N P 2 Replies Last reply
            0
            • OriginalGriffO OriginalGriff

              Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

              Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              The Table designers allow you to edit the table's structure. So when you click print, what does it print: the actual saved definition or the one that appears in your screen (edited but not saved)? I agree that the tools must provide some other way to print the info, like right-click on a Table and click 'Print Definition' or something of that sort.

              OriginalGriffO G 2 Replies Last reply
              0
              • OriginalGriffO OriginalGriff

                Thanks, I found that on t'interweb - I wasn't after an answer, I just wanted to release some frustration. :laugh: But seriously, why the heck not add it? It's a pretty obvious thing to want, I would have thought? Ah. This is Microsoft, I forgot. "If the user is likely to want it, they can go stuff themselves" - silly me! :-D

                Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                N Offline
                N Offline
                Nagy Vilmos
                wrote on last edited by
                #7

                OriginalGriff wrote:

                they can go stuff themselves stick their head in a pig

                ftfy


                Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

                OriginalGriffO G 3 Replies Last reply
                0
                • N Nagy Vilmos

                  OriginalGriff wrote:

                  they can go stuff themselves stick their head in a pig

                  ftfy


                  Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

                  OriginalGriffO Offline
                  OriginalGriffO Offline
                  OriginalGriff
                  wrote on last edited by
                  #8

                  ...except at times of special celebration

                  Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                  "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                  "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                  1 Reply Last reply
                  0
                  • L Lost User

                    The Table designers allow you to edit the table's structure. So when you click print, what does it print: the actual saved definition or the one that appears in your screen (edited but not saved)? I agree that the tools must provide some other way to print the info, like right-click on a Table and click 'Print Definition' or something of that sort.

                    OriginalGriffO Offline
                    OriginalGriffO Offline
                    OriginalGriff
                    wrote on last edited by
                    #9

                    That's the point: you can't, because the damn thing is disabled! :laugh:

                    Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                    "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                    "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                    1 Reply Last reply
                    0
                    • N Nagy Vilmos

                      OriginalGriff wrote:

                      they can go stuff themselves stick their head in a pig

                      ftfy


                      Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

                      OriginalGriffO Offline
                      OriginalGriffO Offline
                      OriginalGriff
                      wrote on last edited by
                      #10

                      BTW: http://www.tapir.caltech.edu/~teviet/share-and-enjoy_44.mp3[^] - turn off your speaker first (or set it as a cow-orkers default beep...)

                      Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                      "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                      N 1 Reply Last reply
                      0
                      • OriginalGriffO OriginalGriff

                        BTW: http://www.tapir.caltech.edu/~teviet/share-and-enjoy_44.mp3[^] - turn off your speaker first (or set it as a cow-orkers default beep...)

                        Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                        N Offline
                        N Offline
                        Nagy Vilmos
                        wrote on last edited by
                        #11

                        Mobile ring-tone - sorted.


                        Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

                        OriginalGriffO 1 Reply Last reply
                        0
                        • N Nagy Vilmos

                          Mobile ring-tone - sorted.


                          Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

                          OriginalGriffO Offline
                          OriginalGriffO Offline
                          OriginalGriff
                          wrote on last edited by
                          #12

                          I am so glad I never sit next to you in the cinema...

                          Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                          1 Reply Last reply
                          0
                          • OriginalGriffO OriginalGriff

                            Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

                            Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                            S Offline
                            S Offline
                            smcnulty2000
                            wrote on last edited by
                            #13

                            Reminds me of the problem I had today (er, yesterday) where I was trying to figure out how to document an SSIS package. WTF is this so hard?

                            _____________________________ Give a man a mug, he drinks for a day. Teach a man to mug...

                            1 Reply Last reply
                            0
                            • L Lost User

                              The Table designers allow you to edit the table's structure. So when you click print, what does it print: the actual saved definition or the one that appears in your screen (edited but not saved)? I agree that the tools must provide some other way to print the info, like right-click on a Table and click 'Print Definition' or something of that sort.

                              G Offline
                              G Offline
                              Gary Wheeler
                              wrote on last edited by
                              #14

                              Print what's on the screen. You don't expect Word to print the document on disk, rather than the one in memory, do you?

                              Software Zen: delete this;

                              L 1 Reply Last reply
                              0
                              • C CPallini

                                You may ask for help in the Q&A: there is a very knowledgeable Welsh guy...

                                If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
                                This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
                                [My articles]

                                A Offline
                                A Offline
                                AndyInUK
                                wrote on last edited by
                                #15

                                CPallini wrote:

                                Welsh guy

                                =

                                CPallini wrote:

                                knowledgeable

                                ?

                                C 1 Reply Last reply
                                0
                                • A AndyInUK

                                  CPallini wrote:

                                  Welsh guy

                                  =

                                  CPallini wrote:

                                  knowledgeable

                                  ?

                                  C Offline
                                  C Offline
                                  CPallini
                                  wrote on last edited by
                                  #16

                                  OK, Mr. AndyInEngland. :rolleyes:

                                  If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
                                  This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
                                  [My articles]

                                  1 Reply Last reply
                                  0
                                  • OriginalGriffO OriginalGriff

                                    Why the heck can't either SQL Server Management Studio or the VS SQL table designer print the table definition? They both show on screen exactly what I want: field name, type, size and null permitted, but print is greyed out! :mad: Why? How difficult can it be, when they will print anything else? Damn it, I'll just have to print a screen dump. Stupid, stupid, stupid. Sorry about that, I feel better now...

                                    Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                                    S Offline
                                    S Offline
                                    Steven J Jowett
                                    wrote on last edited by
                                    #17

                                    Are you one of those people who want someone else to do all your work for you? I mean had Microsoft(in the head) actually provided this function for you, what else would you do with your time. More postings on CP I guess ;)

                                    Steve Jowett ------------------------- Real Programmers don't need comments -- the code is obvious.

                                    OriginalGriffO 1 Reply Last reply
                                    0
                                    • S Steven J Jowett

                                      Are you one of those people who want someone else to do all your work for you? I mean had Microsoft(in the head) actually provided this function for you, what else would you do with your time. More postings on CP I guess ;)

                                      Steve Jowett ------------------------- Real Programmers don't need comments -- the code is obvious.

                                      OriginalGriffO Offline
                                      OriginalGriffO Offline
                                      OriginalGriff
                                      wrote on last edited by
                                      #18

                                      Steven J Jowett wrote:

                                      what else would you do with your time. More postings on CP I guess

                                      Doubtfull - I have to sleep sometimes... :laugh:

                                      Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                                      "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
                                      "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

                                      S 1 Reply Last reply
                                      0
                                      • OriginalGriffO OriginalGriff

                                        Steven J Jowett wrote:

                                        what else would you do with your time. More postings on CP I guess

                                        Doubtfull - I have to sleep sometimes... :laugh:

                                        Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                                        S Offline
                                        S Offline
                                        Steven J Jowett
                                        wrote on last edited by
                                        #19

                                        OriginalGriff wrote:

                                        I have to sleep sometimes

                                        There's plenty of time for that when your life-time warranty expires.

                                        Steve Jowett ------------------------- Real Programmers don't need comments -- the code is obvious.

                                        1 Reply Last reply
                                        0
                                        • OriginalGriffO OriginalGriff

                                          Thanks, I found that on t'interweb - I wasn't after an answer, I just wanted to release some frustration. :laugh: But seriously, why the heck not add it? It's a pretty obvious thing to want, I would have thought? Ah. This is Microsoft, I forgot. "If the user is likely to want it, they can go stuff themselves" - silly me! :-D

                                          Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together. Manfred R. Bihy: "Looks as if OP is learning resistant."

                                          P Offline
                                          P Offline
                                          PIEBALDconsult
                                          wrote on last edited by
                                          #20

                                          OriginalGriff wrote:

                                          "If the user is likely to want it, they can go stuff themselves"

                                          No, only if it makes sense and the majority want it; if it's stoopid and only a few users want it, they'll add it and turn it on by default.

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups