Search
-
Re: Random row selection in table to table synchronization.
table2: accttype acctnum 1 xxxxx123xxxx 1 xxxx452xxxx 1 xxxx654xxxx 2 xxxxx487xxxx table1: name accttype acctnum Joe 1 123456 John 1 456248 Jame 2 154785 Jxxx 1 457885 Now I want to synchronize table1 with table2 based on accttype column. Now when I do table to table sync, the output is: table1: name accttype acctnum Joe 1… -
Backup Succeeds but fails on VERIFY
Please help! We have a backup process that keeps on failing on the VERIFY portion. Tested directing the backup to local disk and network, same behavior. Did the sqbutility too. Backup successfully completes yet on the verify portion, it says that the media family on device is incorrectly formed. Please see below message:… -
Formatter removes table from columns in WHERE clause even when it's ambiguous otherwise
First, here is the sample code: CREATE TABLE dbo.#Isolates ( MICSourceID VARCHAR(3) ,VisitID VARCHAR(256) ,PatientID VARCHAR(256) ,AccountNumber VARCHAR(256) ,UnitNumber VARCHAR(256) ,EmrNumber VARCHAR(256) ,Name VARCHAR(256) ,NameLast VARCHAR(256) ,NameFirst VARCHAR(256) ,BirthDateTime DATETIME ,Sex VARCHAR(256)… -
checking in complaining about stored procs not compiling
Discussion by ChrisAdkin · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI'm using source control 1.1.0.19, with SQL Server 2008 R2 and sub version. When I try to check in, Red Gate source control is complaining that a perfectly good stored proc which I have already checking via a different sub version client will not compile, this is what I'm getting:- Errors occurred whilst parsing file… -
Errors in script
Hi Guys, I am a new user. I get the following errors when I try to run a compare script. Does anyone have any ideas? Thanks, Derek Altering [dbo].[PendingProductionAdjustment_SetProcessedFlag] Server: Msg 207, Level 16, State 1, Procedure PendingProductionAdjustment_SetProcessedFlag, Line 18 Invalid column name… -
Long Running Query Alert - What Does It Capture
WHy does the LRQ (Long Running Query) alert sometimes capture the actual T-SQL code as shown in #1 below and at other times captures the sturcture and not the values as shown in #2 below? The second one does not show you the actual values being inserted. #1: INSERT INTO [dbo].[MYTABLE]( @col1, @col2, @colN) VALUES (1, 'a',… -
Percentage is inaccurate while registering/comparing db?
Discussion by steveschoon · · Home› Discontinued and Previous Versions› SQL Toolkit Previous VersionsI'm comparing a small snapshot (4-6 tables) to a larger database (40-50 tables) using a C# app and the toolkit. It is working fine, except for the fact that the percent complete appears to be inaccurate. Writing everything to the debug window in VS.NET during the compare generates this output: Percentage: 0 Message:… -
Is there a way to see type of a relation?
Is there a way to see what attributes are linked on tables (Primary key - foreign key) and what is the type of the relation (1:1, 1:N etc)? -
error restoring sqb: "Failed to create the data link for fil
i am getting this error after selecting backup file and entering security password. anyone have an idea to get pass this. 09:07:47.451|Info |Logging |1 |Current Logging levels enabled: Verbose,Warning,Fatal,Debug,Information,Trace,Error 09:07:47.708|Info |ngWrapper.LogManager|1 |#1:Loaded assembly System.Data,… -
Re: Does anyone else's Community CLI not work?
Yes. I have inherited a codebase and the upgrade database script runs this. powershell flyway -outOfOrder="true" migrate -url=jdbc:postgresql://${host}:${port}/${database} -locations=filesystem:./${MIGRATION_FOLDER} -user=${user} ${passwordSection} When I ran this, I saw no debug statements at all. Just a silent end of the…
>5988 results
