Viewing 15 posts - 1 through 15 (of 327 total)
"Test-DbaLastBackup" - I believe this is in the dbatools module.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 28, 2019 at 11:25 am
Thank you both for your replies. We are going to have conference call with the vendor support and try to find out why an attach or restore won't work. If...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 11, 2018 at 2:36 pm
I just realized that I hadn't posted what I found out. I have a Start-Transcript in my profile and the SQLPS in Management Studio doesn't like that. I removed it...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 17, 2018 at 7:11 am
I don't know if this still holds but the Powershell included with SSMS was a subset. We got around it by having a folder for our scripts and using CmdExec...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 3, 2018 at 6:19 am
'one should everything about something and something about everything'
,
'find a job you like and you'll never work a day again in your life'
Ditto
I've...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
February 8, 2018 at 7:20 am
I finally tracked down what caused this issue, my profile. I used the sysinternals procmon tool to see what was being loaded/unload etc. There is a TON of data in...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
February 1, 2018 at 6:15 am
Thanks Steve but I did that early on in quest to no avail. I am waiting for our Desktop Architecture group to certify the latest version, SSMS 17.4, and I'll...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 2, 2018 at 9:10 am
Yes - I have it in my profiles for Powershell ISE and Powershell cmd window. Unfortunately that doesn't help for SSMS
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
January 2, 2018 at 5:30 am
The manifest is in the same folder and the version of Powershell is 5.1.15063.632.
Unfortunately I can't spend any more time on this. I was hoping to resolve this...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 6, 2017 at 11:12 am
seems I've got them in 2 places:
C:\Program Files (x86)\WindowsPowerShell\Modules\SqlServer
C:\Program Files\WindowsPowerShell\Modules\SqlServer - this folder has the 21.0.17199 sub folder which is the latest release and a Get-Module displays this...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 6, 2017 at 8:29 am
Kev, MG "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies." "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Thanks but the sqlps module was replaced by the sqlserver module. Trying to import the sqlps module will return errors that the SMO objects are already present.
Tony Hoare
December 6, 2017 at 7:22 am
I don't have SQLPS or SQLToolsPS in my 140 folder so both.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 4, 2017 at 1:19 pm
I noticed that when I Start Powershell in SSMS 16.x it executes sqltoolsps.exe in the C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn which also contains SQLToolsPS.exe.config but there are no corresponding files...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 4, 2017 at 12:56 pm
I uninstalled, reinstall and still no change
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 4, 2017 at 12:29 pm
I tried AllowClobber and no difference in behavior. I am thinking I need to uninstall SSMS 17 and reinstall. It is possible that it didn't install correctly.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 4, 2017 at 12:00 pm
Viewing 15 posts - 1 through 15 (of 327 total)