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. Database & SysAdmin
  3. Database
  4. Can't create table - SQL 2008 R2

Can't create table - SQL 2008 R2

Scheduled Pinned Locked Moved Database
databasehelpcsharpvisual-studiodesign
12 Posts 2 Posters 3 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.
  • P PIEBALDconsult

    I have never used database tools in Visual Studio and I see no reason to. I prefer to just write the SQL statement or use the designer in SSMS.

    T Offline
    T Offline
    ThetaClear
    wrote on last edited by
    #3

    I'm using the 'SQL Server Management Studio' (=SSMS). he error that I get appears while I'm trying to create a table there.

    P 1 Reply Last reply
    0
    • T ThetaClear

      I'm using the 'SQL Server Management Studio' (=SSMS). he error that I get appears while I'm trying to create a table there.

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

      Ah, then I don't know. Just write some SQL. "Would you like some help with that?" -- Clippy

      T 1 Reply Last reply
      0
      • P PIEBALDconsult

        Ah, then I don't know. Just write some SQL. "Would you like some help with that?" -- Clippy

        T Offline
        T Offline
        ThetaClear
        wrote on last edited by
        #5

        Thanks, but I'm looking to solve this problem so I could have access to the designer.

        P 1 Reply Last reply
        0
        • T ThetaClear

          Thanks, but I'm looking to solve this problem so I could have access to the designer.

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

          Right. I've been using the Express versions too and had no trouble with the designers. SQL Server 2012 Express has been causing other trouble though. Did you try a repair install?

          T 1 Reply Last reply
          0
          • P PIEBALDconsult

            Right. I've been using the Express versions too and had no trouble with the designers. SQL Server 2012 Express has been causing other trouble though. Did you try a repair install?

            T Offline
            T Offline
            ThetaClear
            wrote on last edited by
            #7

            OK. So I removed the current installation but right now I can't install the management studio because of compatibility issues. (Windows 8) Besides going back to Windows 7, Any advice??

            P 1 Reply Last reply
            0
            • T ThetaClear

              OK. So I removed the current installation but right now I can't install the management studio because of compatibility issues. (Windows 8) Besides going back to Windows 7, Any advice??

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

              Nope, I'm on Win 7. You could possibly use a virtual Win 7 system. Hopefully someone else will have something more useful.

              T 1 Reply Last reply
              0
              • P PIEBALDconsult

                Nope, I'm on Win 7. You could possibly use a virtual Win 7 system. Hopefully someone else will have something more useful.

                T Offline
                T Offline
                ThetaClear
                wrote on last edited by
                #9

                So I managed installing Management studio but now I'm trying to create a database and I get: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) It looks like I need to update something but I don't know what...

                P 1 Reply Last reply
                0
                • T ThetaClear

                  So I managed installing Management studio but now I'm trying to create a database and I get: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) It looks like I need to update something but I don't know what...

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

                  That could be an access problem. I forgot exactly when I've seen that.

                  T 1 Reply Last reply
                  0
                  • P PIEBALDconsult

                    That could be an access problem. I forgot exactly when I've seen that.

                    T Offline
                    T Offline
                    ThetaClear
                    wrote on last edited by
                    #11

                    Solved it! I had to install this: http://www.microsoft.com/en-us/download/confirmation.aspx?id=26729[^] Finally!!

                    P 1 Reply Last reply
                    0
                    • T ThetaClear

                      Solved it! I had to install this: http://www.microsoft.com/en-us/download/confirmation.aspx?id=26729[^] Finally!!

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

                      Excellent! I may need that too. :thumbsup:

                      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