Viewing 15 posts - 61 through 75 (of 1,079 total)
Good to see 90% got it right so far.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 31, 2017 at 7:14 am
Confirm the namespace ID in your rsreportserver.config file.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 28, 2017 at 8:12 am
Yes, the runtime redistributable, or the alternative, just sending them a generated PDF 😉
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 27, 2017 at 2:04 pm
The MSI to deploy is called ENU\x64\SQLSysClrTypes.msi, and part of the SQL 2014 Feature pack - https://www.microsoft.com/en-us/download/details.aspx?id=42295
You'll need admin rights to install yes.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 27, 2017 at 12:44 pm
1. Restore the principal DB on your sSecondary instance with NORECOVERY
2. Restore a transaction log backup to the secondary also WITH NORECOVERY
3. Make sure the mirroring endpoints are...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 16, 2017 at 10:54 am
No one can advise you on what index is needed without seeing your queries.
Use the stairways - http://www.sqlservercentral.com/stairway/72399/ on indexing, this will help you understand how to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 9:46 am
Log Shipping is controlled through an executable "sqllogship.exe", so I don't see how you can change the output format, unless you create a manual process with T-SQL or PS.
For...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 8:32 am
Your post came up when I posted mine... 🙂
The textfile,servers.txt, is it a...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 7:24 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 7:08 am
As Grant said, Powershell is your friend.
Start with defining a central db where you'll store all your collected data and tables to store data (redacted for your requirement...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 7, 2017 at 6:45 am
You can run this as a job every x minutes to check for a specific job name, it will also omit any current running version of this job.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 6, 2017 at 7:38 am
I have one table where there is a column that have email id's for...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 6, 2017 at 7:21 am
Not familiar with the PS method you posted, but I know there are alternatives to acomplish this:
https://github.com/dapaxx/reportsync
http://www.forrards.com/howtoeasilymigratessrsreportsbetweentwoservers/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 6, 2017 at 7:16 am
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 5, 2017 at 11:29 am
Hi All ,
I would like to know how often we need to update statistics for all...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 5, 2017 at 6:25 am
Viewing 15 posts - 61 through 75 (of 1,079 total)