Activity overview
Latest activity by gemu
SQL Clone working for one, forbidden for other
Hi,I'm having some issues getting the SQL Clone up and running for a specific user. The agent is installed on the device with administrative user and when logged on with user A it works perfect. SQ...
problem solved, its showing up now / comments
problem solved, its showing up now
SQL Source Control not picking up a User-Defined Table Type
Hi,We make use of a User-Defined Table Type in our stored procedures. User Defined is enabled in the filter, we only exclude roles, users and security policy. Any idea why source control is not pic...
i'm having the same issue here... Has anybody opened a ticket for this?
03 Sep 2019 21:10:38.895 [110] ERROR DatabaseObjectIndexer - Exception while indexing database dbBlaBla: System.EntryPointNotFoundException: Unable to find an entry point named 'sqlite3_open_interop' in DLL 'SQLite.Interop.dll'. at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db) at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool) at System.Data.SQLite.SQLiteConnection.Open() at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen() at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand() at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise() at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken )
/ comments
i'm having the same issue here... Has anybody opened a ticket for this?
03 Sep 2019 21:10:38.895 [110] ERROR DatabaseObjectIndexer - Exception while indexing database dbBlaBla: System.EntryPointNot...
Tianjiao, I'm not aware of any filters in SQL Data Compare, only a list of options where nothing is mentioned about sequences. Just to be clear what we mean with sequences: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2016 Code snippet for our sequence object:
CREATE SEQUENCE [dbo].[a_seq_example] <br> AS [BIGINT]<br> START WITH 1<br> INCREMENT BY 1<br> MINVALUE -9223372036854775808<br> MAXVALUE 9223372036854775807<br> CACHE <br>GOIt seems as if redgate is unaware of the sequence object and it is not syncing (or taking into account) the properties of the sequence object in sys.sequences. Can we get some clarification on how redgate data compare deals with sequence objects? This is important for us to know. If redgate product suite is incompatible with sequences we need to rethink our database design or look for other solution.
/ comments
Tianjiao, I'm not aware of any filters in SQL Data Compare, only a list of options where nothing is mentioned about sequences.Just to be clear what we mean with sequences:https://docs.microsoft.com...
Monday said:
I was just working on a script to generate the NuGet package version and I ran across this page today. https://docs.microsoft.com/en-us/nuget/reference/package-versioning I assume your issue is that the -Suffix must start with a alpha character. The one that worked started with -e the ones that failed start with -0.
Thank you, that was indeed what I was missing. / comments
Monday said:
I was just working on a script to generate the NuGet package version and I ran across this page today. https://docs.microsoft.com/en-us/nuget/reference/package-versioningI assume...
not in a valid NuGet version format?
Hi,
I'm running SQL Change Automation 3.1.9.3341When i execute New-DatabaseBuildArtifact i get
New-DatabaseBuildArtifact : Cannot validate argument on parameter 'PackageVersion'. '0.31-034435810a01...
SQLDoc.exe terminated with the exit code 70
Hi,I get following in my logs:New-DatabaseDocumentation : SQLDoc.exe terminated with the exit code 70: An unhandled exception occurred.
See the log information above for more detai...
Hi, Thanks for commenting on the UNC path, this is in line with my assumption then.
Now on the problem, that there was an issue with creating or attaching the VHD was already the assumption based on the stacktrace. As its not documented here which privileges are actually required from the local administrator role we hoped to get some more info on this.
The root cause we eventually identified was a missing privilege: ‘perform volume maintenance tasks’
We have a GPO set up to allow a specific group of users to perform
volume maintenance tasks and the agent user is not part of the group.This GPO overwrites the default setting and removes the local
administrators group from the ‘perform volume maintenance tasks’ local security
setting.
Regards
/ comments
Hi,Thanks for commenting on the UNC path, this is in line with my assumption then.
Now on the problem, that there was an issue with creating or attaching the VHD was already the assumption based on...
Hi, Thanks for commenting on the UNC path, this is in line with my assumption then.
Now on the problem, that there was an issue with creating or attaching the VHD was already the assumption based on the stacktrace. As its not documented here which privileges are actually required from the local administrator role we hoped to get some more info on this.
The root cause we eventually identified was a missing privilege: ‘perform volume maintenance tasks’
We have a GPO set up to allow a specific group of users to perform
volume maintenance tasks and the agent user is not part of the group.This GPO overwrites the default setting and removes the local
administrators group from the ‘perform volume maintenance tasks’ local security
setting.
Regards
/ comments
Hi,Thanks for commenting on the UNC path, this is in line with my assumption then.
Now on the problem, that there was an issue with creating or attaching the VHD was already the assumption based on...