Search
-
Unhandled exception in cut/paste
-
Re: Risk with column modifications
Thanks for your reply. Scanning the generated SQL is going to be a very inexact science. For instance, for the example that I mentioned in my post, the generated output does not include an ALTER TABLE DROP COLUMN. Instead, it creates a new temporary table that includes all the other columns, SELECTs all the data into that,… -
Re: https...
Hi Danish, That's an interesting proposition. I suppose the data for all of the dropdown list controls is available in the state information, but I don't know of a way to reliably retrieve it. It's either encrypted, or obfuscated in some way. Another thing you could do is to look for HTML source within the… -
Re: Problem with Impersonation and Trusted Connections
Here's an example of the problem. Sample code: string connectionString = "Data Source=localhost;Initial Catalog=db;Trusted_Connection=yes"; using (SqlConnection cx = new SqlConnection(connectionString)) { cx.Open(); string databaseName = cx.Database; string serverName = cx.DataSource; cx.Close(); Database dbi = new… -
Re: TFS/VSTS Deployment Scenario
Since I can't attach a file, below you can see what we did to allow for impersonation to another user from the release agent, should you have the need. We did create a separate TFS task to support it, but this is the meat of it. I would love to see something supported that accomplishes the same thing in the near future… -
Re: Same randomized data in each Image?
Hi @rob_wingate - long time no speak - I hope you're well! What you're describing is deterministic masking. The first thing I would ask before describing this is why you would need to have the names be masked to the same value every time? Is there an intended workflow for this? The reason I ask is that implementing this… -
Re: Need to run post-deployment script without schema change
Hi @tomslickers , I think it can often make sense to create a dedicated InstanceConfiguration database (just picked a random name) to version changes for instance level objects such as linked servers and SQL Agent jobs, for a few reasons: 1. As you've found, sometimes you want to just deploy a change to the instance level… -
Re: Regarding Supported Record Comparison on Oracle DB compare
Hi, thank you for your forum post. There is no comparison size limit in Data Compare for Oracle. However the amount of data can be compared will be restricted by the amount of free disk space for the creation of temporary files that the comparison process creates. By default, Data Compare for Oracle creates temporary *.tmp… -
Re: Cross-Database Queries
Hello, Thanks for your question. For stored procedures, they should all import/baseline successfully, but they will print a warning. This is because SQL Server has a feature called "deferred name resolution" for stored procedures: since stored procedures can create a table and then reference it in the same procedure, they… -
Re: Couldn't start the profiling session
Comment by plmaheu · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous Versions› ANTS Performance Profiler 9I don't see any errors. I put a couple loggers in DEBUG but nothing stands out either. The last lines are: 15 Jun 2017 14:02:01.536 [10] INFO RedGate.Profiler.Engine.Startup.Sessions.BaseSession - InetSrv WOW64 directory is C:\WINDOWS\SysWOW64\inetsrv 15 Jun 2017 14:02:01.540 [10] INFO…
>5989 results