Viewing 15 posts - 16 through 30 (of 67 total)
This is how I get data in CSV format : As you can see the rows are not aligned to proper columns above
June 15, 2020 at 12:27 pm
That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried using...
June 13, 2020 at 5:03 pm
Thanks I will try that. This issue seems with only using excel 2007. If I select excel 2016 (while exporting) on another machine I don’t see this happening.
So appears I...
June 13, 2020 at 4:13 pm
I am exporting data to excel , attaching the screen shot for reference. The defaults are selected while exporting..and the source is a query. The column type that comes automatically...
June 12, 2020 at 5:39 pm
Hi, I used the export wizard for SSMS. This helps but some how I see a single quote in front of the columns - like 'ts
How can I remove this...
June 12, 2020 at 3:03 pm
Thanks for the response I will check them
June 11, 2020 at 8:59 pm
Hi Jeffrey, the user would then collect this data from the shared location and prepare report
June 11, 2020 at 6:18 pm
I feel that this database the repository database must be on the web application server where DPA is installed
June 2, 2020 at 6:31 pm
I do not see any new database, I was also referring to the steps for registering a SQL server instance from the guide by solar winds
Which says below ==>
Oracle Repository...
June 2, 2020 at 6:08 pm
I see, but on the target SQL Server , that I just used for monitoring I do not see any new database created, where would this database be? DPA did...
June 2, 2020 at 5:53 pm
Sure, please share the script to revoke access to the account, that would be very useful for me, since our company wants to restrict access as much as possible
June 2, 2020 at 5:39 pm
Will there be any agent installed on the monitoring (target ) SQL Server ? if yes what is the name of the Agent? I just added one SQL Server to...
June 2, 2020 at 5:20 pm
Thanks for the inputs, sure I'll post back for any specify questions
June 2, 2020 at 3:29 pm
https://localhost/reports_ssrs ==> Yes you are right , when trying to connect this way I get a message not secure.
Thanks for your advise and suggestions Brain.
I will also ask...
May 20, 2020 at 6:45 pm
Viewing 15 posts - 16 through 30 (of 67 total)