Posts
Sort by recent activity
SSL Error on database enumeration after upgrade to Windows Server 2019 / SQL 2019
Previously we had our dev server running Windows 2012 R2 and SQL Server 2017 and we connected fine with SQL Data Compare and SQL Compare to the server.We recently redid that server with Windows Ser...
Build failing with referenced object during cleaning of database
This is my first attempt to move our existing DB into using SQL Change automation with Azure DevOps.I set up my pipeline and set up a build SQL Change automation task for my project. When I run it ...
Comment required and Azure DevOps 2019 checking causes exception
Our environment we are working with SSMS 18.8, SQL Source Control 17.2.16, and Azure DevOps 2019 (local server install) and Visual Studio 2019 16.8.5. We require comments on code checkin, and every...
DATETIME2(7) not deploying correctly (11.4.0.1)
I have two databases, both are running SQL Server 2008 (10.0.6241.0). I have columns that are storing data as DATETIME2 with a precision of 7, when comparing the two databases I get every so often ...
DATETIME2 not accurate
I've noticed that DATETIME2 columns are only syncing with a precision of 3 when I have it set to DATETIME2(7) I only get the first 3 of the 7 digits in the SQL scripts SQL Datacompare 11 generates....
SQL Server Metrics all zero for one server
I have SQL Monitor 3.5 set up right now to monitor two servers.
The monitor service and website are on a server external to these two servers.
Right now physcal server 1 is logging data fine, all t...
Missing snippets?
I previously had older versions of SQL Prompt installed, I reinstalled everything with a new system and installed verison 5.3.4.1 and now I have no snippets except a few. There is a whole 12 now, w...