SSMS default maximum number of characters displayed in each column is 256.
You can change this option on: Option/Query Results/SQL Server/Results to Text
but, the maximum value is 8192 characters.
This is a solution when you need to print more that 8192 characters:
Using PRINT
declare @pText nvarchar(max) = @myVarToPrint;
declare @pTextNewLine nvarchar(2) = CHAR(13) + CHAR(10); -- ** it is a good practice to use CR and LF together. CHAR(13) + CHAR(10)
declare @pTextMax int = 256; -- ** default maximum number caracters displayed - SSMS -- but you can change it
declare @pTextPrint nvarchar(max);
declare @pTextCR Int
select @pText = @pText + @pTextNewLine;
while (LEN(@pText) > 0)
begin
SELECT @pTextCR = CHARINDEX(@pTextNewLine, @pText);
IF ((@pTextCR =-1) OR (@pTextCR > @pTextMax)) SELECT @pTextCR = @pTextMax;
select @pTextPrint = SUBSTRING(@pText,0,@pTextCR),
@pText = SUBSTRING(@pText, @pTextCR+len(@pTextNewLine), len(@sql));
print @pTextPrint
end
Using the NOWAIT option with the SQL Server RAISERROR statement
declare @pText nvarchar(max) = @myVarToPrint;
declare @pTextNewLine nvarchar(2) = CHAR(13) + CHAR(10); -- ** it is a good practice to use CR and LF together. CHAR(13) + CHAR(10)
declare @pTextMax int = 256; -- ** default maximum number caracters displayed - SSMS -- but you can change it
declare @pTextPrint nvarchar(max);
declare @pTextCR Int
select @pText = @pText + @pTextNewLine;
while (LEN(@pText) > 0)
begin
SELECT @pTextCR = CHARINDEX(@pTextNewLine, @pText);
IF ((@pTextCR =-1) OR (@pTextCR > @pTextMax)) SELECT @pTextCR = @pTextMax;
select @pTextPrint = SUBSTRING(@pText,0,@pTextCR),
@pText = SUBSTRING(@pText, @pTextCR+len(@pTextNewLine), len(@sql));
RAISERROR (@pTextPrint, 0, 1) WITH NOWAIT
end
source:
https://www.mssqltips.com/sqlservertip/1660/using-the-nowait-option-with-the-sql-server-raiserror-statement/
https://stackoverflow.com/questions/7850477/how-to-print-varcharmax-using-print-statement
Maintain database indexes
You can just create script or run right now the reindex.
Verify the configuration to filter databases or to change the FILLFACTOR.
PRINT '-- ***************************************** --'
PRINT '-- Reindex all tables'
PRINT '-- on selected databases'
PRINT '-- ***************************************** --'
PRINT '--'
PRINT '/*'
PRINT @@servername;
PRINT Getdate();
PRINT '*/'
SET NOCOUNT ON;
-- CONFIGURATION
DECLARE @runScriptRightNow INT = 0;
DECLARE @fillfactor AS NVARCHAR(10) = '99' -- occuped% -- https://docs.microsoft.com/en-us/sql/relational-databases/indexes/specify-fill-factor-for-an-index
BEGIN TRY DROP TABLE #dbs; END TRY BEGIN CATCH END CATCH;
SELECT [name] INTO #dbs FROM sys.databases
WHERE database_id > 4
AND name NOT IN ('MyDatabaseNoReindex')
ORDER BY [name]
-- CONFIGURATION
USE [MASTER];
DECLARE @dbname nvarchar(200);
DECLARE @sql NVARCHAR(MAX);
DECLARE @ToKill AS NVARCHAR(MAX);
DECLARE @templateSelectTable AS NVARCHAR(MAX) = 'SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + table_name + '']'' as tableName FROM [$(dbname)].INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE'''
DECLARE @templateReindex AS NVARCHAR(MAX) ='ALTER INDEX ALL ON $(tablename) REBUILD WITH (FILLFACTOR = $(fillfactor));'
SET @templateReindex = REPLACE(@templateReindex,'$(fillfactor)',@fillfactor)
DECLARE @table AS table (TableName nvarchar(256))
DECLARE @script AS table (Idx int identity,SqlScript nvarchar(max))
DECLARE @Idx int;
DECLARE @SqlScript nvarchar(max)
WHILE (EXISTS(SELECT * FROM #dbs))
BEGIN
SELECT TOP 1 @dbname = name FROM #dbs;
DELETE FROM #dbs WHERE name = @dbname;
SET @sql = REPLACE(@templateSelectTable,'$(dbname)',@dbname);
DELETE FROM @table;
INSERT INTO @table (TableName)
EXEC(@sql)
INSERT INTO @script(SqlScript)
select REPLACE(@templateReindex,'$(tablename)',TableName) from @table;
WHILE (EXISTS(SELECT * FROM @script))
BEGIN
SELECT TOP 1 @Idx = Idx, @SqlScript = SqlScript FROM @script t;
DELETE FROM @script WHERE Idx = @Idx;
IF (@runScriptRightNow = 1)
BEGIN
RAISERROR (@SqlScript, 10, 1) WITH NOWAIT;
EXEC (@SqlScript);
END
ELSE
PRINT @SqlScript
END
END
Same code with safe mode and try again
GO
PRINT '-- ***************************************** --'
PRINT '-- Reindex all tables with safe mode'
PRINT '-- on selected databases'
PRINT '-- ***************************************** --'
PRINT '--'
PRINT '-- ' +@@servername;
PRINT '-- ' +cast(Getdate() as nvarchar(100));
SET NOCOUNT ON;
-- CONFIGURATION
DECLARE @runScriptRightNow INT = 1;
DECLARE @fillfactor AS NVARCHAR(10) = '98' -- occuped% -- https://docs.microsoft.com/en-us/sql/relational-databases/indexes/specify-fill-factor-for-an-index
BEGIN TRY DROP TABLE #dbs; END TRY BEGIN CATCH END CATCH;
SELECT [name] INTO #dbs FROM sys.databases
WHERE database_id > 4
AND name IN ('MyDatabaseNoReindex')
ORDER BY [name]
-- CONFIGURATION$(ESCAPE_NONE(dbname))
USE [MASTER];
DECLARE @dbname nvarchar(200);
DECLARE @sql NVARCHAR(MAX);
DECLARE @ToKill AS NVARCHAR(MAX);
DECLARE @templateSelectTable AS NVARCHAR(MAX) = 'SELECT ''['' + table_catalog + ''].['' + table_schema + ''].['' + table_name + '']'' as tableName FROM [[#dbname]].INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE'''
DECLARE @templateReindex AS NVARCHAR(MAX) ='
DECLARE @tryAgain INT = 2;
WHILE (@tryAgain>0)
BEGIN
BEGIN TRY
PRINT ''-- REINDEX Table : [#tablename]'';
ALTER INDEX ALL ON [#tablename] REBUILD WITH (FILLFACTOR = [#fillfactor]));
END TRY
BEGIN CATCH
SET @tryAgain = @tryAgain - 1;
WAITFOR DELAY ''00:00:10'';
CONTINUE;
END CATCH
BREAK;
END;
'
SET @templateReindex = REPLACE(@templateReindex,'[#fillfactor])',@fillfactor)
DECLARE @table AS table (TableName nvarchar(256))
DECLARE @script AS table (Idx int identity,SqlScript nvarchar(max))
DECLARE @Idx int;
DECLARE @SqlScript nvarchar(max)
WHILE (EXISTS(SELECT * FROM #dbs))
BEGIN
SELECT TOP 1 @dbname = name FROM #dbs;
DELETE FROM #dbs WHERE name = @dbname;
SET @sql = REPLACE(@templateSelectTable,'[#dbname]',@dbname);
DELETE FROM @table;
INSERT INTO @table (TableName)
EXEC(@sql)
INSERT INTO @script(SqlScript)
select REPLACE(@templateReindex,'[#tablename]',TableName) from @table;
WHILE (EXISTS(SELECT * FROM @script))
BEGIN
SELECT TOP 1 @Idx = Idx, @SqlScript = SqlScript FROM @script t;
DELETE FROM @script WHERE Idx = @Idx;
IF (@runScriptRightNow = 1)
BEGIN
RAISERROR (@SqlScript, 10, 1) WITH NOWAIT;
RAISERROR ('GO', 10, 1) WITH NOWAIT;
EXEC (@SqlScript);
END
ELSE
PRINT @SqlScript
END
END
GO
Sources :
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/specify-fill-factor-for-an-index
https://www.mssqltips.com/sqlservertip/1367/sql-server-script-to-rebuild-all-indexes-for-all-tables-and-all-databases/
Create backup operator login
PRINT '-- Create backup operator login'
DECLARE @loginName as NVARCHAR(256) = N'UserDbBackupOperator'
DECLARE @password as nvarchar(128) = N'MyDbBackupStrongPassword'
DECLARE @sql AS NVARCHAR(MAX)
If not Exists (select loginname from master.dbo.syslogins where name = @loginName )
Begin
Select @SQL = 'CREATE LOGIN ' + QUOTENAME(@loginName) + 'WITH PASSWORD=N'''+@password+''', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF';
EXEC sp_executesql @sql
End
select @sql = 'USE [?];IF (NOT EXISTS(SELECT * FROM [?].sys.database_principals WHERE name = '''+@loginName+''')) BEGIN CREATE USER ['+@loginName+'] FOR LOGIN ['+@loginName+'];ALTER ROLE [db_backupoperator] ADD MEMBER ['+@loginName+']; END';
EXEC sp_MSforeachdb @sql
go
Just add backup operator login over all databases
PRINT '-- Add backup operator login over all databases'
DECLARE @loginName as NVARCHAR(256) = N'UserDbBackupOperator'
DECLARE @sql AS NVARCHAR(MAX)
select @sql = 'USE [?];IF (NOT EXISTS(SELECT * FROM [?].sys.database_principals WHERE name = '''+@loginName+''')) BEGIN CREATE USER ['+@loginName+'] FOR LOGIN ['+@loginName+'];ALTER ROLE [db_backupoperator] ADD MEMBER ['+@loginName+']; END';
EXEC sp_MSforeachdb @sql
go
Script to get Linked server list. We have repeated linked server name if it has more than one associated remote login.
SELECT @@SERVERNAME AS 'Server Name'
, sys.servers.server_id AS 'IdLinkedServer'
, sys.servers.name AS 'Linked Server Name'
, CASE sys.servers.Server_id WHEN 0 THEN 'Current Server'
ELSE 'Remote Server' END AS 'Server '
, sys.servers.product
, sys.servers.provider
, sys.servers.data_source
, sys.servers.catalog
, CASE sys.linked_logins.uses_self_credential WHEN 1 THEN 'Uses Self Credentials'
ELSE sys.server_principals.name END AS 'Local Login '
, sys.linked_logins.remote_name AS 'Remote Login Name'
, CASE sys.servers.is_rpc_out_enabled WHEN 1 THEN 'True'
ELSE 'False' END AS 'RPC Out Enabled'
, CASE sys.servers.is_data_access_enabled WHEN 1 THEN 'True'
ELSE 'False' END AS 'Data Access Enabled'
, sys.servers.modify_date
FROM sys.servers
LEFT OUTER JOIN sys.linked_logins ON sys.servers.server_id = sys.linked_logins.server_id
LEFT OUTER JOIN sys.server_principals ON sys.server_principals.principal_id = sys.linked_logins.local_principal_id
Source: https://gallery.technet.microsoft.com/scriptcenter/Get-List-of-Linked-Server-d6c95d9c
Source : http://blog.danskingdom.com/powershell-ise-multiline-comment-and-uncomment-done-right-and-other-ise-gui-must-haves/
| Ctrl + K |
Comment Selected Lines |
| Ctrl + Shift + K |
Uncomment Selected Lines |
# Define our constant variables.
[string]$NEW_LINE_STRING = "`r`n"
[string]$COMMENT_STRING = "#"
function Select-EntireLinesInIseSelectedTextAndReturnFirstAndLastSelectedLineNumbers([bool]$DoNothingWhenNotCertainOfWhichLinesToSelect = $false)
{
<#
.SYNOPSIS
Exands the selected text to make sure the entire lines are selected.
Returns $null if we can't determine with certainty which lines to select and the
.DESCRIPTION
Exands the selected text to make sure the entire lines are selected.
.PARAMETER DoNothingWhenNotCertainOfWhichLinesToSelect
Under the following edge case we can't determine for sure which lines in the file are selected.
If this switch is not provided and the edge case is encountered, we will guess and attempt to select the entire selected lines, but we may guess wrong and select the lines above/below the selected lines.
If this switch is provided and the edge case is encountered, no lines will be selected.
Edge Case:
- When the selected text occurs multiple times in the document, directly above or below the selected text.
Example:
abc
abc
abc
- If only the first two lines are selected, when you run this command it may comment out the 1st and 2nd lines correctly, or it may comment out the 2nd and 3rd lines, depending on
if the caret is on the 1st line or 2nd line when selecting the text (i.e. the text is selected bottom-to-top vs. top-to-bottom).
- Since the lines are typically identical for this edge case to occur, you likely won't really care which 2 of the 3 lines get selected, so it shouldn't be a big deal.
But if it bugs you, you can provide this switch.
.OUTPUT
PSObject. Returns a PSObject with the properties FirstLineNumber and LastLineNumber, which correspond to the first and last line numbers of the selected text.
#>
# Backup all of the original info before we modify it.
[int]$originalCaretLine = $psISE.CurrentFile.Editor.CaretLine
[string]$originalSelectedText = $psISE.CurrentFile.Editor.SelectedText
[string]$originalCaretLineText = $psISE.CurrentFile.Editor.CaretLineText
# Assume only one line is selected.
[int]$textToSelectFirstLine = $originalCaretLine
[int]$textToSelectLastLine = $originalCaretLine
#------------------------
# Before we process the selected text, we need to make sure all selected lines are fully selected (i.e. the entire line is selected).
#------------------------
# If no text is selected, OR only part of one line is selected (and it doesn't include the start of the line), select the entire line that the caret is currently on.
if (($psISE.CurrentFile.Editor.SelectedText.Length -le 0) -or !$psISE.CurrentFile.Editor.SelectedText.Contains($NEW_LINE_STRING))
{
$psISE.CurrentFile.Editor.SelectCaretLine()
}
# Else the first part of one line (or the entire line), or multiple lines are selected.
else
{
# Get the number of lines in the originally selected text.
[string[]] $originalSelectedTextArray = $originalSelectedText.Split([string[]]$NEW_LINE_STRING, [StringSplitOptions]::None)
[int]$numberOfLinesInSelectedText = $originalSelectedTextArray.Length
# If only one line is selected, make sure it is fully selected.
if ($numberOfLinesInSelectedText -le 1)
{
$psISE.CurrentFile.Editor.SelectCaretLine()
}
# Else there are multiple lines selected, so make sure the first character of the top line is selected (so that we put the comment character at the start of the top line, not in the middle).
# The first character of the bottom line will always be selected when multiple lines are selected, so we don't have to worry about making sure it is selected; only the top line.
else
{
# Determine if the caret is on the first or last line of the selected text.
[bool]$isCaretOnFirstLineOfSelectedText = $false
[string]$firstLineOfOriginalSelectedText = $originalSelectedTextArray[0]
[string]$lastLineOfOriginalSelectedText = $originalSelectedTextArray[$originalSelectedTextArray.Length - 1]
# If the caret is definitely on the first line.
if ($originalCaretLineText.EndsWith($firstLineOfOriginalSelectedText) -and !$originalCaretLineText.StartsWith($lastLineOfOriginalSelectedText))
{
$isCaretOnFirstLineOfSelectedText = $true
}
# Else if the caret is definitely on the last line.
elseif ($originalCaretLineText.StartsWith($lastLineOfOriginalSelectedText) -and !$originalCaretLineText.EndsWith($firstLineOfOriginalSelectedText))
{
$isCaretOnFirstLineOfSelectedText = $false
}
# Else we need to do further analysis to determine if the caret is on the first or last line of the selected text.
else
{
[int]$numberOfLinesInFile = $psISE.CurrentFile.Editor.LineCount
[string]$caretOnFirstLineText = [string]::Empty
[int]$caretOnFirstLineArrayStartIndex = ($originalCaretLine - 1) # -1 because array starts at 0 and file lines start at 1.
[int]$caretOnFirstLineArrayStopIndex = $caretOnFirstLineArrayStartIndex + ($numberOfLinesInSelectedText - 1) # -1 because the starting line is inclusive (i.e. if we want 1 line the start and stop lines should be the same).
[string]$caretOnLastLineText = [string]::Empty
[int]$caretOnLastLineArrayStopIndex = ($originalCaretLine - 1) # -1 because array starts at 0 and file lines start at 1.
[int]$caretOnLastLineArrayStartIndex = $caretOnLastLineArrayStopIndex - ($numberOfLinesInSelectedText - 1) # -1 because the stopping line is inclusive (i.e. if we want 1 line the start and stop lines should be the same).
# If the caret being on the first line would cause us to go "off the file", then we know the caret is on the last line.
if (($caretOnFirstLineArrayStartIndex -lt 0) -or ($caretOnFirstLineArrayStopIndex -ge $numberOfLinesInFile))
{
$isCaretOnFirstLineOfSelectedText = $false
}
# If the caret being on the last line would cause us to go "off the file", then we know the caret is on the first line.
elseif (($caretOnLastLineArrayStartIndex -lt 0) -or ($caretOnLastLineArrayStopIndex -ge $numberOfLinesInFile))
{
$isCaretOnFirstLineOfSelectedText = $true
}
# Else we still don't know where the caret is.
else
{
[string[]]$filesTextArray = $psISE.CurrentFile.Editor.Text.Split([string[]]$NEW_LINE_STRING, [StringSplitOptions]::None)
# Get the text of the lines where the caret is on the first line of the selected text.
[string[]]$caretOnFirstLineTextArray = @([string]::Empty) * $numberOfLinesInSelectedText # Declare an array with the number of elements required.
[System.Array]::Copy($filesTextArray, $caretOnFirstLineArrayStartIndex, $caretOnFirstLineTextArray, 0, $numberOfLinesInSelectedText)
$caretOnFirstLineText = $caretOnFirstLineTextArray -join $NEW_LINE_STRING
# Get the text of the lines where the caret is on the last line of the selected text.
[string[]]$caretOnLastLineTextArray = @([string]::Empty) * $numberOfLinesInSelectedText # Declare an array with the number of elements required.
[System.Array]::Copy($filesTextArray, $caretOnLastLineArrayStartIndex, $caretOnLastLineTextArray, 0, $numberOfLinesInSelectedText)
$caretOnLastLineText = $caretOnLastLineTextArray -join $NEW_LINE_STRING
[bool]$caretOnFirstLineTextContainsOriginalSelectedText = $caretOnFirstLineText.Contains($originalSelectedText)
[bool]$caretOnLastLineTextContainsOriginalSelectedText = $caretOnLastLineText.Contains($originalSelectedText)
# If the selected text is only within the text of when the caret is on the first line, then we know for sure the caret is on the first line.
if ($caretOnFirstLineTextContainsOriginalSelectedText -and !$caretOnLastLineTextContainsOriginalSelectedText)
{
$isCaretOnFirstLineOfSelectedText = $true
}
# Else if the selected text is only within the text of when the caret is on the last line, then we know for sure the caret is on the last line.
elseif ($caretOnLastLineTextContainsOriginalSelectedText -and !$caretOnFirstLineTextContainsOriginalSelectedText)
{
$isCaretOnFirstLineOfSelectedText = $false
}
# Else if the selected text is in both sets of text, then we don't know for sure if the caret is on the first or last line.
elseif ($caretOnFirstLineTextContainsOriginalSelectedText -and $caretOnLastLineTextContainsOriginalSelectedText)
{
# If we shouldn't do anything since we might comment out text that is not selected by the user, just exit this function and return null.
if ($DoNothingWhenNotCertainOfWhichLinesToSelect)
{
return $null
}
}
# Else something went wrong and there is a flaw in this logic, since the selected text should be in one of our two strings, so let's just guess!
else
{
Write-Error "WHAT HAPPENED?!?! This line should never be reached. There is a flaw in our logic!"
return $null
}
}
}
# Assume the caret is on the first line of the selected text, so we want to select text from the caret's line downward.
$textToSelectFirstLine = $originalCaretLine
$textToSelectLastLine = $originalCaretLine + ($numberOfLinesInSelectedText - 1) # -1 because the starting line is inclusive (i.e. if we want 1 line the start and stop lines should be the same).
# If the caret is actually on the last line of the selected text, we want to select text from the caret's line upward.
if (!$isCaretOnFirstLineOfSelectedText)
{
$textToSelectFirstLine = $originalCaretLine - ($numberOfLinesInSelectedText - 1) # -1 because the stopping line is inclusive (i.e. if we want 1 line the start and stop lines should be the same).
$textToSelectLastLine = $originalCaretLine
}
# Re-select the text, making sure the entire first and last lines are selected. +1 on EndLineWidth because column starts at 1, not 0.
$psISE.CurrentFile.Editor.Select($textToSelectFirstLine, 1, $textToSelectLastLine, $psISE.CurrentFile.Editor.GetLineLength($textToSelectLastLine) + 1)
}
}
# Return the first and last line numbers selected.
$selectedTextFirstAndLastLineNumbers = New-Object PSObject -Property @{
FirstLineNumber = $textToSelectFirstLine
LastLineNumber = $textToSelectLastLine
}
return $selectedTextFirstAndLastLineNumbers
}
function CommentOrUncommentIseSelectedLines([bool]$CommentLines = $false, [bool]$DoNothingWhenNotCertainOfWhichLinesToSelect = $false)
{
$selectedTextFirstAndLastLineNumbers = Select-EntireLinesInIseSelectedTextAndReturnFirstAndLastSelectedLineNumbers $DoNothingWhenNotCertainOfWhichLinesToSelect
# If we couldn't determine which lines to select, just exit without changing anything.
if ($selectedTextFirstAndLastLineNumbers -eq $null) { return }
# Get the text lines selected.
[int]$selectedTextFirstLineNumber = $selectedTextFirstAndLastLineNumbers.FirstLineNumber
[int]$selectedTextLastLineNumber = $selectedTextFirstAndLastLineNumbers.LastLineNumber
# Get the Selected Text and convert it into an array of strings so we can easily process each line.
[string]$selectedText = $psISE.CurrentFile.Editor.SelectedText
[string[]] $selectedTextArray = $selectedText.Split([string[]]$NEW_LINE_STRING, [StringSplitOptions]::None)
# Process each line of the Selected Text, and save the modified lines into a text array.
[string[]]$newSelectedTextArray = @()
$selectedTextArray | foreach {
# If the line is not blank, add a comment character to the start of it.
[string]$lineText = $_
if ([string]::IsNullOrWhiteSpace($lineText)) { $newSelectedTextArray += $lineText }
else
{
# If we should be commenting the lines out, add a comment character to the start of the line.
if ($CommentLines)
{ $newSelectedTextArray += "$COMMENT_STRING$lineText" }
# Else we should be uncommenting, so remove a comment character from the start of the line if it exists.
else
{
# If the line begins with a comment, remove one (and only one) comment character.
if ($lineText.StartsWith($COMMENT_STRING))
{
$lineText = $lineText.Substring($COMMENT_STRING.Length)
}
$newSelectedTextArray += $lineText
}
}
}
# Join the text array back together to get the new Selected Text string.
[string]$newSelectedText = $newSelectedTextArray -join $NEW_LINE_STRING
# Overwrite the currently Selected Text with the new Selected Text.
$psISE.CurrentFile.Editor.InsertText($newSelectedText)
# Fully select all of the lines that were modified. +1 on End Line's Width because column starts at 1, not 0.
$psISE.CurrentFile.Editor.Select($selectedTextFirstLineNumber, 1, $selectedTextLastLineNumber, $psISE.CurrentFile.Editor.GetLineLength($selectedTextLastLineNumber) + 1)
}
function Comment-IseSelectedLines([switch]$DoNothingWhenNotCertainOfWhichLinesToComment)
{
<#
.SYNOPSIS
Places a comment character at the start of each line of the selected text in the current PS ISE file.
If no text is selected, it will comment out the line that the caret is on.
.DESCRIPTION
Places a comment character at the start of each line of the selected text in the current PS ISE file.
If no text is selected, it will comment out the line that the caret is on.
.PARAMETER DoNothingWhenNotCertainOfWhichLinesToComment
Under the following edge case we can't determine for sure which lines in the file are selected.
If this switch is not provided and the edge case is encountered, we will guess and attempt to comment out the selected lines, but we may guess wrong and comment out the lines above/below the selected lines.
If this switch is provided and the edge case is encountered, no lines will be commented out.
Edge Case:
- When the selected text occurs multiple times in the document, directly above or below the selected text.
Example:
abc
abc
abc
- If only the first two lines are selected, when you run this command it may comment out the 1st and 2nd lines correctly, or it may comment out the 2nd and 3rd lines, depending on
if the caret is on the 1st line or 2nd line when selecting the text (i.e. the text is selected bottom-to-top vs. top-to-bottom).
- Since the lines are typically identical for this edge case to occur, you likely won't really care which 2 of the 3 lines get commented out, so it shouldn't be a big deal.
But if it bugs you, you can provide this switch.
#>
CommentOrUncommentIseSelectedLines -CommentLines $true -DoNothingWhenNotCertainOfWhichLinesToSelect $DoNothingWhenNotCertainOfWhichLinesToComment
}
function Uncomment-IseSelectedLines([switch]$DoNothingWhenNotCertainOfWhichLinesToUncomment)
{
<#
.SYNOPSIS
Removes the comment character from the start of each line of the selected text in the current PS ISE file (if it is commented out).
If no text is selected, it will uncomment the line that the caret is on.
.DESCRIPTION
Removes the comment character from the start of each line of the selected text in the current PS ISE file (if it is commented out).
If no text is selected, it will uncomment the line that the caret is on.
.PARAMETER DoNothingWhenNotCertainOfWhichLinesToUncomment
Under the following edge case we can't determine for sure which lines in the file are selected.
If this switch is not provided and the edge case is encountered, we will guess and attempt to uncomment the selected lines, but we may guess wrong and uncomment out the lines above/below the selected lines.
If this switch is provided and the edge case is encountered, no lines will be uncommentet.
Edge Case:
- When the selected text occurs multiple times in the document, directly above or below the selected text.
Example:
abc
abc
abc
- If only the first two lines are selected, when you run this command it may uncomment the 1st and 2nd lines correctly, or it may uncomment the 2nd and 3rd lines, depending on
if the caret is on the 1st line or 2nd line when selecting the text (i.e. the text is selected bottom-to-top vs. top-to-bottom).
- Since the lines are typically identical for this edge case to occur, you likely won't really care which 2 of the 3 lines get uncommented, so it shouldn't be a big deal.
But if it bugs you, you can provide this switch.
#>
CommentOrUncommentIseSelectedLines -CommentLines $false -DoNothingWhenNotCertainOfWhichLinesToSelect $DoNothingWhenNotCertainOfWhichLinesToUncomment
}
#==========================================================
# Add ISE Add-ons.
#==========================================================
# Add a new option in the Add-ons menu to comment all selected lines.
if (!($psISE.CurrentPowerShellTab.AddOnsMenu.Submenus | Where-Object { $_.DisplayName -eq "Comment Selected Lines" }))
{
$psISE.CurrentPowerShellTab.AddOnsMenu.Submenus.Add("Comment Selected Lines",{Comment-IseSelectedLines},"Ctrl+K")
}
# Add a new option in the Add-ons menu to uncomment all selected lines.
if (!($psISE.CurrentPowerShellTab.AddOnsMenu.Submenus | Where-Object { $_.DisplayName -eq "Uncomment Selected Lines" }))
{
$psISE.CurrentPowerShellTab.AddOnsMenu.Submenus.Add("Uncomment Selected Lines",{Uncomment-IseSelectedLines},"Ctrl+Shift+K")
}