Viewing 15 posts - 91 through 105 (of 4,477 total)
Those reports aren't rdls. SSMS reports use the Report Viewer control so they are rdlc files. They are stored in the file Microsoft.SqlServer.Management.Reports.dll
You can use a .Net decompiler and point...
May 6, 2020 at 7:25 pm
I've had problems before with bugs in prior versions of SSMS still showing up when I didn't uninstall the older version of SSMS. They've made the monthly releases of SSMS...
April 9, 2020 at 10:44 pm
Just trying to update the last post date for this since this is stuck at the top of the active threads list. And I'm sick of seeing it at the...
April 9, 2020 at 8:20 pm
Download the current (or a more recent) version of SSMS. You can find the downloads at this link:
Download SQL Server Management Studio (SSMS)
Sue
April 9, 2020 at 8:17 pm
If you are always having to specify the port you may want to check to make sure UDP port 1434 is open on the firewall for the browser service.
Sue
April 9, 2020 at 7:59 pm
As I understand licensing, and the manner in which we pay for it, every developer, tester, QA person, and so forth have Visual Studio licenses.
Regarding SQL and OS licenses,...
April 8, 2020 at 7:31 pm
Try adding the parameter that the error tells you to try:
Install-Module SQLServer -AllowClobber
Sue
April 6, 2020 at 6:54 pm
As Ken indicated, it's part of the SQLServer module. Execute Get-InstalledModule and see if the SQLServer module is installed. If not, install that module be executing Install-Module SQLServer.
Sue
April 6, 2020 at 3:43 pm
Publisher or subscriber makes a difference and I'm not clear which you are referring to. But if you are testing this against a subscriber, the first thing to check would...
April 3, 2020 at 3:15 pm
As long as it's for a brief period of time, Disable the replication agent jobs. Then re-enable them when you are done. And you may want to leave the cleanup...
April 2, 2020 at 8:12 pm
If it's a default instance I believe it will use the default port. If you have a default instance and using a different port, you often need to create alias...
March 13, 2020 at 10:47 pm
One option with Powershell is to use dbatools and the cmdlet Update-DbaInstance. You can find more information on that cmdlet in this link: Update-DbaInstance
An example of how...
March 12, 2020 at 7:05 pm
Dear Sue,
Thanks for your response.
The configuration "remote proc trans = 0" was ran on both distribution and Publisher server. However, i did not run the process as 'sa' user...
March 11, 2020 at 3:36 pm
In your first post, you said you tried the solution in the link - there are two different solutions listed. One being setting remote proc trans = 0 and the...
March 11, 2020 at 3:13 pm
It's safe to use. The logic is that the FILEPROPERTY function when used with SpacedUsed returns the number of pages used. A page is 8K. So if you multiply by...
March 11, 2020 at 12:26 am
Viewing 15 posts - 91 through 105 (of 4,477 total)