Search
-
SCA doesn't create new schema in an existing database
So I'm trying to bring an existing production database under source control. I created a Visual Studio project and successfully created a baseline from the production database in my local environment. The db didn't already exist locally so was correctly created by SCA. When I try and release via Azure DevOps to our "Build"… -
No Suggestions When FOR_XML used in Sub-Query
Another problem with no suggestions with certain code: SELECT EI.SampleField, (SELECT EI_2.Part + ',' FROM (SELECT 1 AS SampleField, 'Part 1' AS Part UNION ALL SELECT 1 AS SampleField, 'Part 3' AS Part UNION ALL SELECT 1 AS SampleField, 'Part 2' AS Part UNION ALL SELECT 2 AS SampleField, 'Part 1' AS Part UNION ALL SELECT 2… -
Sql Source Control v2.2 Issue with MERGE?
Discussion by EASwiedler · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsEverything was working fine, until I added the following stored procedure: USE [RoamData]GO/****** Object: StoredProcedure [Diagnostics].[Run] Script Date: 09/16/2013 04:27:23 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [Diagnostics].[Run]( @TimeZoneId VARCHAR(50))ASBEGIN SET NOCOUNT ON; DECLARE… -
Profiler crashes when starting a new profiling session
Discussion by wuttke@compra.de · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsHi, I have just updated to V6 and now I cannot start a profiling session, because I receive an error message right after clicking on "start". Logging shows the following: 17 Aug 2010 12:37:34.410 [1] INFO RedGate.Profiler.Logging.LogService - Starting new ANTS Performance Profiler 6 session 17 Aug 2010 12:37:34.430 [1]… -
Errors reported by Query Analyser
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi Crispin, How was your Christmas holiday? Good, I hope. Thanks for the comments about the website. We worked really hard on it. Is your database case-sensitive, by any chance? Regards, Brian Donahue Technical Support Engineer Red Gate Software Ltd. ( +44 870 1600 037 * mailto:brian.donahue@red-gate.com "Crispin… -
ERASEFILES_ATSTART question
Where does ERASEFILES_ATSTART get it's source from? The backup command that's running or the Server Options defined in the GUI? Or somewhere else? I have a server where, due to the size of the files, I put the local backups in several different drives/folders. I changed my backup command from ERASEFILE=23h to… -
Re: Auto Createapplication.dat for serverlist
Here is the schema definition:<?xml version="1.0" encoding="utf-8"?><xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="MultiScriptApplication" nillable="true" type="MultiScriptApplication" /> <xs:complexType name="MultiScriptApplication"> <xs:sequence> <xs:element… -
Re: Keep loosing connection
Comment by Chriswalton007 · · Home› Discontinued and Previous Versions› SQL Monitor Previous VersionsTHe file no longer exisits there, I rebooted the machine which the monitor sits on and the file went. traceid property value 1 1 2 1 2 C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\log_896.trc 1 3 20 1 4 NULL 1 5 1 3 1 2 3 2 F:\SQLLOG\20120127121310-00-DEST051-MONITOR.trc 3 3 250 3 4 2012-01-27… -
Unable to contact Redgate Client
-
SQLMonitor Script Alert Setup
>5989 results