Viewing 15 posts - 16 through 30 (of 327 total)
When you go to C:\Program Files\WindowsPowerShell\Modules, are there a couple of sqlps files in that directory? And do you have a SQLServer directory?
In Powershell, try updating...
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 11:23 am
Did you install the cmdlet before SSMS?
Yes but when I ran into this issue, I installed again with -force. Is -allowclobber more effective.
I also rebooted....
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 9:11 am
In previous versions of SSMS, right clicking on any item in Object Explorer and Start Powershell would take you to the location in SQLSERVER: in a Powershell session. This isn't working...
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 8:14 am
You're welcome. Glad you are on the right track now.
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 18, 2017 at 9:46 am
"linked server "(null)" - this looks like a double hop issue. From your desktop to the first server with the openrowset code and then to the target. Delegation in Kerberos...
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 18, 2017 at 6:40 am
for some reason the link didn't get inserted
http://www.red-gate.com/library/fundamentals-of-sql-server-2012-replication?utm_source=ssc&utm_medium=publink&utm_campaign=books&utm_content=replication_ebook&utm_term=FundamentalsofReplication
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 5, 2017 at 6:28 am
Redgate has s free eBook on the fundamentals of SQL 2012 Replication:
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 5, 2017 at 6:26 am
Steve Jones - SSC Editor - Wednesday, January 25, 2017 8:51 PMComments posted to this topic are about the item Broken tempdb
I...
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 26, 2017 at 6:31 am
Ditto to processadmin and view server state. sysadmin isn't needed and should be avoided.
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 10, 2017 at 6:30 am
If you really want to get specific, Jonathan Kehayias' article on how much memory SQL Server really needs is a good read:
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 8, 2016 at 6:32 am
You can see it on the SSC site. Click on Scripts in the menu on the left and at the top of the page There is a message for it
Get...
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 5, 2016 at 6:07 am
Thanks. It's really convenient to have right there on the tool bar.
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 4, 2016 at 7:06 am
May be a problem with the web page. I checked the 4 correct answers and got an incorrect.
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, 2016 at 10:18 am
Actually, that is what I finally whittled it down to but I used ADD EVENT sqlserver.error_reported. I ran a profiler trace at the same time the session was running and...
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.
November 4, 2015 at 6:45 am
Thanks again for the such a quick response. I was at lunch so it took a little while before I saw this. I am comfortable enough with Powershell to...
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.
November 3, 2015 at 11:32 am
Viewing 15 posts - 16 through 30 (of 327 total)