Redgate detects CREATE TABLE in script stored in GIT repo

patrickortusopatrickortuso Posts: 7 Bronze 1

We write many data maintenance scripts and store them in our GIT repository in a folder (_Scripts) below the Red Gate root directory (Source Control Root Path into GIT Repository). This week, we created a script which includes a "CREATE TABLE #tmpList". It seems red gate recognizes the statement and now has become an object it tracks. if we were to tell it to 'drop' it will erase the script file. Is this a normal red gate function or a bug? We do not want redgate to manage theses scripts but we want them in the same location as we do not share all repository levels with all employees/contactors.

Any Ideas?

Below is what the "Commit Page" looks like:


SQL Server 2008R2
SQL Prompt Version
SQL Source Control Version standard
Microsoft SQL Server Management Studio 10.50.2550.0
Microsoft Analysis Services Client Tools 10.50.2500.0
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18204
Microsoft .NET Framework 2.0.50727.5485
Operating System 6.1.7601


  • Hello Patrick,

    We've opened a support ticket for this request as it's going to take more investigating than a forum post response would allow. I'll following up with you through that ticket right after I finish writing this.
    Allen LeVan
    Red Gate Software
    US Product Support
Sign In or Register to comment.