Search
-
Re: Restore Issue
[update]This will also be included in the forthcoming 5.2 release, so the solutions below should only be used if using versions 5.0 or 5.1[/update] As a follow-up to this issue, the reason for the problem is that the value of "SQLDataRoot" (in the SQL Server portion of the registry) contains an additional backslash at the… -
Re: Backup reports not working across multiple servers...
Not really. I have never been 'fluent' with Linked Servers as we dont need them a great deal here and your help page seems to be the same as the link to microsoft supplied at the bottom only without the formatting... I have SQL Backup running as a service, using a network logon (eg. domain\SQLB5Admin). This account has… -
Re: Octopus Deployment to Multiple Client Databases on one SQL Server Instance
Sorry for the delay. I've been very busy and on vacation. Catching up on emails etc now. Firstly, following the release of SQL Change Automation in the last few weeks, you should now use this link instead: https://documentation.red-gate.com/sca3/reference/powershell-cmdlets Open disclosure: I've not tested this, but I… -
Potential Bug: Comparing against SSDT misses primary keys.
I have an SSDT project which contains a table defined as follows: CREATE TABLE [dbo].[Reports] ( [ReportId] INT IDENTITY (1, 1) NOT NULL, [Name] VARCHAR (MAX) NOT NULL, [Path] VARCHAR (MAX) NOT NULL, [Enabled] BIT NOT NULL, [SortOrder] INT NOT NULL, CONSTRAINT [PK_Reports] PRIMARY KEY CLUSTERED ([ReportId] ASC));CREATE… -
Data Compare for Oracle 2.1 now available!
Data Compare for Oracle 2.1 (November 2012) (version 2.1.0.291) We're pleased to announce the release of a new version of Data Compare for Oracle. What's new in Data Compare for Oracle 2.1 * Option to ignore whitespace in text data* Deployment of control characters* Option to ignore control characters for comparison*… -
Read Only User - Why have any permissions on the Configuration Tab???
We are in the process of setting up / configuring components in SQL Monitor. One area we were interested in is granting read only access to a defined server group for architects / developers so they could review things for the designated servers we grant access for. Upon testing this functionality out we noticed certain… -
Failed validating database state error
Hi, I've hit an issue with trying to get our main database to automatically build and deploy. We've got this process working with some of our smaller databases but this is the critical one. The annoying thing is that this was working but now it's not. This is the relevant section from the TeamCity build log:… -
SQL Prompt 6.5.0.336
SQL Prompt 6.5.0.336 - 11th June 2015 This build of SQL Prompt includes:* Tab coloring improvements (UserVoice and experimental feature feedback) * GROUP BY and ORDER BY suggestions improvements (UserVoice, UserVoice and UserVoice) * Import/export all options (UserVoice) * SQLCMD mode support (UserVoice and UserVoice) *… -
Connection to source/target working GUI but not with cmd lin
Hello I'm able to compare oracle schemas ,I'm able to connect and compare and generate report on GUI but when doing through command line I'm getting below error Error: Can not obtain Oracle client information from registry. Make sure that Oracle Client Software is installed, or use Direct mode of connecting to server.… -
Backup fails and I'm not sure why
Discussion by st8floorsup · · Home› Discontinued and Previous Versions› SQL Backup Previous VersionsI have the backup script below that never completes if the backup fails for a database and I'm not sure why. It calls this process for all of my databases but the job stops after the first retry if the backup fails. Begin SET @SQL = 'Declare @exitcode int, @sqlerrorcode int, @ErrorMsg varchar(200)' SET @SQL = @SQL + ' Exec…
946 results