BuboFlash - helps with learning

Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.

Presentation
Question

Answer

Tags

#Agile #Docs #Powershell #SQL

Question

How to begoin to retrieve any information from the server [CONTEXT: Get-SQLServerPrivileges function]?

Answer

Before we can retrieve any information from the server we have to create a SMO Server object:

  # Check if the instance object is already initiated
if($server -eq $null)
  {
    try{
	  $server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $inst
	}
	catch [Exception]
	{
	  Write-Host "$_.Exception.GetType().FullName, $_.Exception.Message" -ForegroundColor Red
	}
}

Tags

#Agile #Docs #Powershell #SQL

Question

How to begoin to retrieve any information from the server [CONTEXT: Get-SQLServerPrivileges function]?

Answer

Before we can retrieve any information from the server we have to create a SMO Server object:

  # Check if the instance object is already initiated
if($server -eq $null)
  {
    try{
	  $server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $inst
	}
	catch [Exception]
	{
	  Write-Host "$_.Exception.GetType().FullName, $_.Exception.Message" -ForegroundColor Red
	}
}

If you want to change selection, open document below and click on "Move attachment"

Documenting SQL Server with PowerShell - Simple Talk
2 3 4 5 6 7 8 9 param ( [Parameter(Mandatory = $true, Position=1)] [ValidateNotNullOrEmpty()] [string]$inst = $null ) # Check if assembly is loaded Load-Assembly -name 'Microsoft.SqlServer.SMO' <span>Before we can retrieve any information from the server we have to create a SMO Server object: 1 2 3 4 5 6 7 8 9 10 11 # Check if the instance object is already initiated if($server -eq $null) { try{ $server = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $inst } catch

Summary

status	not learned	measured difficulty	37% [default]	last interval [days]
repetition number in this series	0	memorised on		scheduled repetition
scheduled repetition interval		last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.