Search
-
SQL Doc v3 is released.
We are pleased to announce a new version of SQL Doc is now available. What's new?Range of new HTML documentation formatting options for greater customizationNew user interface with enhanced navigationFlexibility to include or exclude any section of any object from the documentationDocument new SQL Server features:… -
How to Package Data Only
I have two databases with different data in. V2 is in production whilst V3 is in development. I want to update the production database with the new data, but for customer security reasons no computer can see both databases at the same time. Therefore, I need a package. Fortunately, the new data are in separate tables, that… -
Re: Exception System.AccessViolationException when profiling app
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsHi Tobias, Oh dear. Well, ANTS Profiler may be encountering a new bit of Intermediate Language that it does not understand because it is an older version of Profiler. You could try upgrading to version 2.71 from our FTP site at ftp://ftp.red-gate.com/old/ants, or you could try it with a demo of version 3. It is possible to… -
Re: Doing Compare on database instance
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Compare Previous VersionsHi, It's sort of odd that v3 would work and v5 would not, as v5's detection and connection code is vastly improved. I'd suggest trying the usual things first, though, to rule them out. Typically SQL Compare works best with SQL Server 2005 when it has the SQL Server discovery service running and the network configuration… -
Re: Dependencies of views
Comment by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Comparison SDK Previous VersionsHi Waldo, Thanks for pointing this out. There isn't a public API for getting the dependency tree from the SQL Compare Engine, even though we both know the information is there somewhere in a private object. I hadn't looked into it in awhile, but back in v3, analyzing a dependency chain was a complicated matter of popping… -
Re: Duplicate grants
Hi, thank you for your forum post. Grants were split into Object Grants and System Grants in V3.1.8 back in May 2017, along with various bug fixes in the versions released between V3.1.8 ->V4.* ->V5.* ->V5.7.0. Are you still using the existing project created in V3.*? If my memory is correct (thinking back to May 2017)… -
Re: Only one field description change allowed
Can you please clarify "multiple edits"? I do not fully understand what/where you are editing. Is this about editing extended properties directly on the SQL Server? As SQL Doc is almost completely rewritten for v3 it would not be possible to simply go through SQL Doc's code and compare to see what has changed and solve the… -
Re: Server has 100 Databases...
Comment by LehighDBA · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI'd like to follow a hierarchy of Server.Database. But yes, setting it up in a better manner, i.e. by starting w/ Right-Clicking on the Server and Adding to Source control would be ideal. I have to get them all in there. So an automated way would be best. I could pre-create all the folders in TFS so the hierarchy method… -
Re: How to set DriftOptionBlockDataLoss to false in VSTS release plugin
OK, I need more information about what you did. I created a new SCA project and deployed it to a database. This worked fine with the SCA build and release tasks (v3) for the table. I then added a new column, as you did, and deployed it. That worked. Next, I added an index on the target, then added another new column on the… -
What Ports does Monitor tool Require?
Discussion by david.hicks · · Home› Discontinued and Previous Versions› SQL Monitor Previous VersionsHello, Can anyone confirm what port(s) sql monitor will require be open? I have a very restrictive client and i will need to specify required port(s) we will use. I have located the following in another post but any additional info would be great. •TCP port 135 used by the Remote Procedure Call (RPC) service. Also make…
135 results