Viewing 15 posts - 121 through 135 (of 966 total)
You could also modify the previous query to use sys.master_files. That will prevent you from having to loop through each database and you may not need a temp table either.
June 29, 2016 at 10:14 pm
It sounds like if you want your subreport to be in a folder on the same report server you can just specify a relative path when you are designing the...
June 26, 2016 at 3:28 pm
Additionally, the example that gsc_dba has is accessing the ReportServer URL, not the Report Manager URL where the path in OPs message is trying via the Report Manager URL. Maybe...
June 25, 2016 at 2:15 am
In your settings for running the script you are specifying the -command parameter. Try changing it to the -file parameter and see if your result is any different.
Additionally, while your...
June 25, 2016 at 2:12 am
I don't think so. This has been asked and answered on MS forums and StackOverflow.
Using an Excel file on a SharePoint as a datasource
Can SSRS use Excel from Sharepoint document...
June 7, 2016 at 6:10 am
I think you are asking for trouble trying to do this. A stand-alone instance will expect the drives you install SQL on to always be available and present. By nature...
June 4, 2016 at 5:11 am
Services running under LocalSystem should show up like this as well.
June 2, 2016 at 8:41 am
The IP that the listener is configured for is a clustered resource. So there will be a NIC on your cluster nodes on the same subnet as the IP the...
June 2, 2016 at 3:22 am
Do did you find out what the cause of your failed maintenance plan was? What did the maintenance plan history show?
June 1, 2016 at 11:26 am
Well, if you have a requirement to send out an e-mail notification and your Auditors want you to disable database mail then there seems to be a logic problem. Wouldn't...
June 1, 2016 at 8:52 am
If you have to target the VS 2010 shell I do not think SSDT will work for you at all. The furthest back SSDT can go back is VS 2012....
June 1, 2016 at 8:36 am
I think the message that CIS is trying to convey is that if it is not needed then it should not be enabled, because it is another function that could...
June 1, 2016 at 7:34 am
When you are able to successfully connect to the initial node, are you connecting to the node name, or the AG listener? Same question for the node you are having...
June 1, 2016 at 3:59 am
There is no such thing as two nodes, each read/write to the same database. That isn't supported in SQL Server and never has been.
That is not necessarily true. SQL...
May 31, 2016 at 2:28 pm
Just to be clear this is an AG you are talking about, correct? You list AlwaysOn, but only state a SQL Server cluster in your original question. That could be...
May 31, 2016 at 2:24 pm
Viewing 15 posts - 121 through 135 (of 966 total)