Search
-
Re: Issue - system_user becomes system_user() which is incorrect
Thank you for taking a look. But I am not sure if you understood the issue correctly. I am not defining the default to be of string type value 'system_user' I am defining the default to be of value returned by the sql server function system_user and therefore the below definition - [User_Created] [varchar](100) NOT NULL… -
Error
Discussion by lkalman@financemgr.com · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsI have User Defined Type showing up that it requires a change. But the Preview show them as the same. Any Idea's -
Re: An internal server error has occurred -- Login error for non-admins introduced with 13.0.47
This problem did indeed seem to resolve with 13.0.48 and above. While I am not sure what was done to fix it, part of the issue identified is that with non-admin users it has to take the extra time to validate all of the groups defined in the the user configuration that it doesn't need to do for admin users. So likely… -
Re: Error: Unsupported column type - Empty
-
Re: Synonym Usage
-
Does not see reordering of columns in table as change
Discussion by mattbreeze · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi there, I am using SQL Compare 9.0.0.79 and I tried synchonising two databases both having a table called Test. In the first database the table is defined: CREATE TABLE [dbo].[Test] ( [a] [int] NULL, [int] NULL ) in the second database it is defined: CREATE TABLE [dbo].[Test] ( [int] NULL, [a] [int] NULL ) SQL Compare… -
User Defined Type
When i have a user defined type i can't change it because the SQL Compare script tries to drop the fieldtype and then recreate it with the new settings. Example FLD_LastName VARCHAR(40) next i need it to change to FLD_LastName VARCHAR(50) I change it in my dev DB and then i want to run SQL Compare to rol it out to… -
profiling an excel add-in
Discussion by fulmerspot · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsI have developed an excel add-in which uses the excel COM automation addin functionality to create user defined functions. The add-in uses managed code (C#) shimmed to present a COM interface to excel. The user-defined functions perform multi variate optimisations which take several seconds to execute, I wish to optimise… -
Availabilty Group Definition
I have recently tried to define a connection in SQL Monitor 4 to a Windows cluster running SQL Server 2012 with availability groups. The connection using the Windows cluster name is successful and attaches to the nodes however it doesn't locate the SQL Server Instances. I removed this connection and connected to each… -
feature suggestion: Code sniffing
Just a wee suggestion that I think would fit into SQL prompt quite well. Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a defined standard, warnings on bad practices etc. You know all those little annoying things like no clustered index, use of…
942 results