Activity overview
Latest activity by Richard
HI Christian Thanks for confirming. I did manage to find a workaround as follows:-
Use SQL doc to create and run the initial project, selecting only the sections I want.
Save the SQLDoc project to somewhere central.
Use a PowerShell script to run the SQLDOC.exe with a project file and the force parameter to make sure it overwrites the original (optional but useful in our use-case).
This is the PowerShell code I've used:- Set-Alias SQLDoc 'C:\Program Files (x86)\Red Gate\SQL Doc 5\SQLdoc.exe' -Scope Script #Get the location of the file to give the PDF $LocationOfProjectFile='Location of sqldoc file\sqldocfilename.sqldoc' #Generate the document SQLdoc /project:$LocationOfProjectFile /force It looks like the sqldoc is used to either include or exclude the the options you want by assigning either True or False to the values. It takes a bit of setting up (going through all the option in SQLDoc) and it's not easy to manipulate afterwards but we got it to work. Hopefully this will help someone else. Regards Richard / comments
HI Christian Thanks for confirming. I did manage to find a workaround as follows:-
Use SQL doc to create and run the initial project, selecting only the sections I want.
Save the SQLDoc project to ...
Using SQL Doc to document view columns
HI all We've got a lot of views (please, don't ask) and we've been asked to document the columns in each view.I'm trying to use SQL Doc to get the columns for the views in a specific schema.I don n...
SQL Compare "oddity"?
Hi allI've just tried using SQL Compare to deploy a changed stored procedure that uses synonyms to go across a linked server.When I tried to use both the "Deploy using SQL Compare" and the "Generat...
Source Control comments and TFS
Hi allI've just enabled the forced comments in Visual Studio for when we commit changes to TFS.This should also work in SSMS for when we make changes to a database and try to commit those changes.U...
Align = in MERGE statement
Hi allWe've been using SQL Prompt styles to give our code a standardised format but there's one small niggle.We can align the "=" in the FROM clause on joins but, when using an MERGE statement, we ...