Redgate detects CREATE TABLE in script stored in GIT repo

patrickortuso

HI,

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:



Environment:
SQL Server 2008R2
SQL Prompt Version 7.1.0.306
SQL Source Control Version 4.1.15.118 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

Allen LeVan

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.