Search
-
tSQLt migration fails when using user-defined data Types in a test stored procedure
Completed the following tutorial to configure tSQLt with a database dependency so I can run tests via tSQLt adapter: https://documentation.red-gate.com/rr1/worked-examples/tutorial-running-tests-in-readyroll-with-tsqlt-adapter I tried to deploy but get the following error when running the test stored proc scripts: Column,… -
User Defined Table Type Dependencies not always deployed
Discussion by c.jordan.mc · · Home› Discontinued and Previous Versions› SQL Compare Previous Versions› SQL Compare 11We often use the SQL Compare command line application to deploy changes from one SQL Azure Database to another. In some cases, when deploying a change to a user defined table type, the dependencies are are not properly deployed resulting in an error. The example we have seen several times is that a stored procedure… -
Re: Using DM on a server which requires a proxy for internet
Is it possible to define a proxy to update the server? -
SQL Compare SDK resetting User Defined Security Policy
We have a home grown application that uses the SQL Compare SDK to do database compares and run the code to update our schema changes from test to production. When we run this it is resetting our user defined security policy to disabled. Is there an option to set that will not change this setting? -
Re: Relative file path in XML for FileListGenerator?
I understand how relocating the file will resolve the issue; however, it seems that having to copy the file into the application-wide external file path defeats the purpose of having the ability to define a custom path for user defined generators. It seems logical that a user defined generator definition and any artifacts… -
Use SSN dataset on numeric column
Hello, I want to use the SSN dataset on a column defined as number(19,0) but I can't select the SSN dataset. When the column is defined as a nvarchar, I can select the SSN dataset. Creating my own dataset did not solve the problem/ Is there any way out if this, except for changing the type of my column? Success, Kees -
i define this:DATE$ $TIME$,get 2016/2/11 . want 2016-2-11
in Snippets manager i define this: edit $DATE$ $TIME$ now it i can get edit 2016/2/11 21:13 but i want to get the follow: edit 2016-2-11 21:13 what can i do next ? -
Version 6.4.0.478 qualify object name issue for user defined
Version 6.4.0.478 qualify object name issue for user defined table type and table value parameter (TVP). I applied "qualify object names" to some SQL which contained a user defined table type, and a declared table value parameter. When I asked it to qualify, it removed the TVP and replaced it with the name of the user… -
Confusion about UsageCounter vs UsageReporter
The documentation examples for feature usage reporting use "UsageCounter.ReportUsage" to report feature usage. The SDK templates define a class that inherits from UsageReporter and define static methods FeatureUsed and DynamicFeatureUsed. There is no documentation on the purpose of these methods, or on the… -
Re: Error (IISController): while profiling asp.net application
Comment by anigalla · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsDear Brian Donahue, when i checked, it is showing "Not Defined" for "log on as batch" in domain security policy. to my understanding, this policy haven't Defined so far. am i right? please look into this whether we have any other choice? thank you.
946 results
