Search
-
Finally, Enumerations in SQL Server!
Hello All, I create a little trick to provide myself some Enum functionality in SQL Server and I figured I'd pass it along. SQL Server does not have developer Enumerations (ie. A set of unique values that can be referenced via Intellisense to change a string into an integer value, or codeset key value). So, I thought about… -
Re: Database Release from package - PostUpdate Schema check failed
Ok.... I found the issues.... I want to write down what I did, to be able to actually trace the errors, and this is only gonna be valid for the VSTS plugins. I'm also gonna rant a little here and there, please forgive that... just read past those parts. Step by step : 1st: In your VSTS release process, add a variable:… -
Re: SQL Compare HTML Report Images
-
SQL Prompt 6.4.1.164
SQL Prompt 6.4.1.164 - 15th January 2015 This build of SQL Prompt includes:* Execute current statement * Insert semicolons * Code highlighting * Use object definition case * Rename variables and aliases * Suggestions improvements * Qualify object names improvements * Remove square brackets * Nullability of columns * Choose… -
Re: Profiling A Web Service
Comment by MathiasWestin · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsHi! I get an error message stating 'the application has not loaded the .NET Framework'. I can't find any information in the eventlog or any where else for that matter that gives me any clues to where the problem is. Found a post in this forum explaining how to start the log in ANTS Profiler, it looks like this: 2006-04-18… -
Re: Error when selecting backup file to restore
Any news on this issue? I'm having the exact same error message. I'm on a licensed version. Virtual Restore has been working fine for a few weeks, but it's failing now. Here's some Virtual Restore logging showing the crash: (will also ticket this at customer support to make sure it's being picked up :)) 20:59:25.195|Info… -
Re: Top Queries is not displayed for the specific DB instance
Hello. I am using SQL Monitor 9.0.13.21542 and I am also getting the "An error occurred while attempting to display this data" for TOP QUERIES. It only happens when there are bad data in RedGateMonitor Database, since if I change the startTime QueryString in the URL it works fine. By the way, in the Chrome DevTools, the… -
Re: Error trying to use .sqlgen file with Test step
Thanks Rob, yep I can now use the data gen project file, although now I am getting another error which is somewhat unhelpful (see call stack below). If I run the equivalent SQLDataGenerator call in powershell on the Build machine, it runs successfully. Excerpt of logs: 2016-10-04T14:55:50.2029072Z ##[debug]Calling:… -
Trouble with ClusterSharedVolume in Azure
I have SQL Backup 8.4.1.527 installed on a SQL Server 2016 cluster in Azure with Cluster Shared Storage (using CSVFT file type) mounted as a sub-folder of the C: drive. I've detailed the problem in reply to another thread https://forums.red-gate.com/viewtopic.php?f=20&t=78193&start=15 as the error I first saw was "SQL… -
BUG: Migration Scripts, User Defined Types and Stored procedures
When sql compare is run and a migration script exists as well as a change to a User Defined Type that is used by a Stored Procedure that is also changed then the Upgrade script generated uses an Alter statement on the STored Procedure and does not drop the Stored procedure before trying to drop and create the user defined…
>1649 results