New answers tagged

0 votes

Error when scripting SQL View dbo.spt_values

I believe it is a network related issue with permissions. Have not been able to identify the root cause, but resolved by deploying and running from the server itself. I've recently bumped into another ...
Don's user avatar
  • 161
0 votes

Error when scripting SQL View dbo.spt_values

If none of the attempts workout, may be you could try drop and re-create the view and see if that is going to resolve. #Script to drop and recreate the view spt_values $sql = @" USE master ...
S.D.'s user avatar
  • 746
0 votes

Powershell dbatools combining result of multiple Get-dbaxxx commands to generate a report

Assuming $Servers is a list of the SQL Server instances, rather than a list of Windows servers, the following will return all the information in the $Results object which can then be written out ...
StuKay's user avatar
  • 101

Top 50 recent answers are included