SQL Connect

Thank you for trying SQL Connect. Your feedback will influence what we do next!

Suggest a new feature, an enhancement, a bug, ask a question...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  1. Field properties

    It would be really useful if we could see the structure of the table including column types and sizes (pref with columns sorted alphabetically) in a window without opening the alter database dialog.

    3 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
    • What is the point of the data folder?

      There's a "Data" folder that has nothing in it. I assume it's to add default data to tables, yet I can't seem to add anything to it.

      4 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  question  ·  Flag idea as inappropriate…  ·  Admin →
      • Solution Explorer scrolls to top each time I open a Database Object

        Each time I double-click a Stored Procedure or Table in the Database Project, solution explorer scrolls back to the top.

        Just an annoyance more than anything - should stay on the opened object same as any other project file.

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
        • Importing more than one SQL Source Control database into a solution

          Is it possible to import more than one SQL Source Control database into a single solution? As soon as one has been imported, the SQL Connect window switches to 'Sync' mode and you can't access the import option.

          2 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  question  ·  Flag idea as inappropriate…  ·  Admin →

            Sorry for the inconvenience here. For now we only have a workaround for this.

            Please right click on the first imported Project and “Unload Project”. The option to import another project should reappear. Once completed with the second import you can right click and “Reload Project” for the initially imported Project.

            Please do advise on whether this works for you and also give us an idea about how you’d like or expect it to work properly. Thanks!

          • Red Gate Support and Upgrades Messages has stopped working.

            After my latest install I get the following message everytime start VS2010 or Microsoft Sql Server Management Studio
            "Red Gate Support and Upgrades Messages has stopped working."

            Problem Details:

            Description:
            Stopped working

            Problem signature:
            Problem Event Name: APPCRASH
            Application Name: RedGate.IPNService.exe
            Application Version: 1.0.0.262
            Application Timestamp: 4f295c0d
            Fault Module Name: mscorwks.dll
            Fault Module Version: 2.0.50727.5448
            Fault Module Timestamp: 4e153960
            Exception Code: c0000005
            Exception Offset: 0000000000151749
            OS Version: 6.1.7601.2.1.0.1296.17
            Locale ID: 1033

            Read our privacy statement online:
            http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

            If the online privacy statement is not available, please read our privacy statement offline:
            C:\Windows\system32\en-US\erofflps.txt

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
            • Installation problem

              I installed SQLDeveloper bundle using an admin account. I checked the "install for all users" option. Under admin account, SQL Connect shows up in VS2010. But I have to use another axccount for "real-life" tasks, and there SQL Connect dows not show up. Seems it asn't installed correctly in VS2010.

              6 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
              • TFS sheckout

                SQL Connect needs tosupport TFS check out, check out exclusive, and check in policies with regards to work items

                9 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • Ability to modify views/tables against database in new query window instead of table designer

                  When creating views/tables in Management Studio, we do not use the interface. We write straight t-sql in a new query window. We would like to have this option when using SQL Connect. Currently, you can do this if you use the "Edit file in project" option, but if you want to work against the database, SQL Connect forces you to use the table designer.

                  4 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                  • Option to make "Edit in Project" the default action when double click an object

                    Currently, when you double click an object in source control it opens to modify it in the database. To edit the SQL file in project you must right click the object and select that option. It would be nice for the people who prefer to edit the script in the project first to be able to make the default double click actionto be "edit the SQL file in the project".

                    22 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      5 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
                    • Ability to select a template when creating a new object

                      Would like the ability to select a template when creating a new object. For example, in Visual Studio, we have custom templates for different objects, such as procedures, functions, views. These templates contain place holders for things we want developers to remember to put in their scripts, such as header comments and certain permissions.

                      2 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
                      • Choose objects from database instead of everything in database

                        Currently, we have projects that use the same database, but I only want to pull out what I use, stored procedures, tables...

                        I don't need EVERY stored procedure

                        15 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          2 comments  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
                        • check out/in plus merge changes

                          With multiple team members, it is important to know which objects are checked out and to be able to check out exclusively(prevent others from modifying). Plus i do not find an equivalent merge utility to that is available in Visual Studio when conflicts arise where you get to choose lines from either version to merge into the object.

                          3 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • Ability to add queries folder to project that does not synchronize to the server

                            It would be nice to be able to add a folder to the redgate sql connect project and set the folder so it is not compared to the database. We'd like to store useful and/or related queries that are often used in a particular database to source control. It would make sense to keep these scripts along side of the database in source control. Would like sql connect to essentially ignore it, but allow the addition of a folder and anything we want below that folder.

                            2 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              3 comments  ·  feature  ·  Flag idea as inappropriate…  ·  Admin →
                            • Notification objects

                              I use SQL Notifications in one of my database. This is creating SP like this one:

                              ALTER PROCEDURE [SqlQueryNotificationStoredProcedure-31560677-ebce-4d11-ad0d-5f3524379f90] AS BEGIN BEGIN TRANSACTION; RECEIVE TOP(0) conversation_handle FROM [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; IF (SELECT COUNT(*) FROM [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 BEGIN DROP SERVICE [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; DROP QUEUE [SqlQueryNotificationService-31560677-ebce-4d11-ad0d-5f3524379f90]; DROP PROCEDURE [SqlQueryNotificationStoredProcedure-31560677-ebce-4d11-ad0d-5f3524379f90]; END COMMIT TRANSACTION; END

                              Because these SP are recreated everytime users connects, you need to find a way of keeping these objects outside SQL Connect.

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                              • Exception has been thrown by the target of an invocation

                                Attempted to View Data or enter the Table Designer in VS 2010 on a project and this message is thrown.

                                Tried synchronizing the database, which had no effect.

                                Running SQL Connect 1.0.1.1172 and VS 2010 Pro on a Win7 64 box.

                                4 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                                • Is support for VisualSVN forthcoming? We have no visual cues of what has changed inside Visual Studio.

                                  Is support for VisualSVN forthcoming? We have no visual cues of what has changed inside Visual Studio.

                                  1 vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • output

                                    Periodically, the information in my sql connect window doesn't match up with my output (SQL Connect) information.

                                    i.e.
                                    (SQL Connect Window )
                                    SQL Connection - Last synchronized at 9:06:08 - 2 object changed

                                    (Output Window - SQL Connect)
                                    ... 1 object changed....

                                    I can't seem to find a constant way to reproduce the error, but I will provide more information if I find some.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  bug  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Creating a new database project before creating the database

                                      Creating a new database project for a database that doesn't yet exist creates an empty folder in the solution directory. After creating the database i SSMS, a new database project cannot be added to the solution with the same name without first removing the directory created in the first failed attempt.

                                      Suggested resolution; remove empty project directory when no new project was added to the solution or prompt and create database.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  enhancement  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Is that SQL Connect that runs continuously on my database server?

                                        I just found that when I open a solution having a SQL Connect project, my database is getting suddenly hit multiple times every second with that query:

                                        -- Copyright © 2009 – 2012 Red Gate Software Ltd.
                                        SET XACT_ABORT ON ;
                                        SET LOCK_TIMEOUT 100 ;
                                        BEGIN TRAN ;

                                        IF OBJECT_ID(N'tempdb..#RG_NewSysObjects', N'U') IS NOT NULL
                                        DROP TABLE #RG_NewSysObjects ;

                                        SELECT *
                                        INTO #RG_NewSysObjects
                                        FROM [xxxx].sys.objects ;

                                        SELECT ls.name AS prevName ,
                                        curr.name AS name ,
                                        ls.object_id AS prevId ,
                                        curr.object_id AS id ,
                                        ls.SchemaName AS prevSchemaName ,
                                        sysSchemas.name AS schemaName ,
                                        ls.type AS prevType ,
                                        curr.type AS type
                                        FROM #RG_LastSysObjects AS…

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          5 comments  ·  question  ·  Flag idea as inappropriate…  ·  Admin →

                                          SQL Connect uses this query to determine when a change has occurred on the database, and to indicate that you might want to press the Synchronize button.

                                          You can now use the Visual Studio options window to control if this query executes. You can select Tools → Options and locate SQL Connect in the tree to disable the query.

                                          Note: By disabling the query, you won’t see any indication of when you need to synchronize.

                                          Hope this helps,
                                          Kevin Boyle,
                                          Developer, SQL Connect Team

                                        • Display the version number of SQL Connect in the sync view

                                          I don't easily find (I may be blind) the version number of the current Connect installation. Can you please show it when syncing.

                                          2 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          • Don't see your idea?

                                          SQL Connect

                                          Feedback and Knowledge Base