Activity overview
Latest activity by jasoncleme
ssms right click menu problem
When I have a small resolution example RDP into a server I have noticed that in SSMS when I right click on a table for the menu for objects has a problem.
Not sure if it a Red-gate problem or a SSM...
Recommendation for TFS organization structure for DBAs
Sorry for the misuse of terms. I'm new to source control.
Does anyone have recommendations for TFS organization structure for DBAs only?
Should our source folder pathing be?
$\DBA\username?
$\DBA\S...
Framed HTML Docs Search Function
Well this is a very powerful tool. We are doing a lot with it in a little amount of time that we have owned it. But I have a question.
Is it possible to add a custom search bar to the HTML. I would...
Me and my team are using Red-gate's SQLDOC for our DB Docs. We have a built nightly PowerShell that run SQLDOC command line that is running to over the current post SQLDOCs.
The workaround to to have one sub-folder for each server/project. <#
=====================
Delete Current SQLDOC
=====================
#>
$path = '\\server\d$\PVP\PVP21\webcontent\Powershell\Database_Documentation\DBPrime1\'
Get-ChildItem $path |
Sort-Object { $_.Name -as [Version] } |
Select-Object -Last 1 |
Remove-Item -recurse
<#
===============
Create SQLDOC
===============
#>
$CMD = 'C:\Program Files (x86)\Red Gate\SQL Doc 2\sqldoc.exe'
$arg1 = '/project:H:\My Documents\SQL Server Management Studio\Red-Gate\DBPrime1.sqldoc'
$arg2 = '/filetype:html-frames'
$arg3 = '/force'
$arg4 = '/outputfolder:"\\server\d$\PVP\PVP21\webcontent\Powershell\Database_Documentation\DBPrime1"'
& $CMD $arg1 $arg2 $arg3 $arg4
<#
"C:\Program Files (x86)\Red Gate\SQL Doc 2\sqldoc.exe" /project:"H:\My Documents\SQL Server Management Studio\Red-Gate\DBPrime1.sqldoc" /filetype:html-frames /force /outputfolder:"\\server\d$\PVP\PVP21\webcontent\Powershell\Database_Documentation\DBPrime1"
#>
<#
===============
Rename Directory
===============
#>
cd \\server\d$\PVP\PVP21\webcontent\Powershell\Database_Documentation\DBPrime1
dir | Where-Object {$_.Name} | Rename-Item -NewName "DBPrime1"
/ comments
Me and my team are using Red-gate's SQLDOC for our DB Docs. We have a built nightly PowerShell that run SQLDOC command line that is running to over the current post SQLDOCs.
The workaround to to ha...