Viewing 15 posts - 106 through 120 (of 966 total)
I don't think you can do this inherently with sqlcmd. What you will most likely have to do is either:
Use your previous method to append results to the same file...
August 3, 2016 at 1:35 pm
I don't think this is possible. Looking at the documentation on database snapshots they inherit the security settings of the base database at the time the snapshot was created.
A database...
August 3, 2016 at 1:29 pm
Can you modify the packages? If so you should be able to add an event handler to write to either a log file or the Windows Event Log.
Integration Services (SSIS)...
August 3, 2016 at 1:21 pm
Were the SQL Agent Jobs modified in any way? Did you double-check that the job step properties for the SSIS package have the package marked to run in 32-bit mode?...
July 31, 2016 at 4:56 pm
You could setup your audit to write to the Windows event log. Then the audits could get written out to a CSV or xml file for further processing.
July 31, 2016 at 11:01 am
I forgot about the AES-NI support. Originally I thought that was only coming to Azure. I have been waiting for that for at least 2 years. I even put a...
July 28, 2016 at 5:21 pm
If you use any SSRS components there should be plenty of compelling reasons to upgrade:
- new native SSRS portal
- rebuilt HTML 5 rendering engine
- pinning Power BI reports
- SSRS portal...
July 28, 2016 at 4:11 pm
How are you doing the shrink? You could try DBCC SHRINKFILE with TRUNCATEONLY. That will release space after the last allocated extent. It should be faster. The problem is if...
July 28, 2016 at 3:52 pm
The Windows Application Log should give a reason for service startup failure, like bad username/password, etc. Is anything listed there?
Also, in the LOGS directory where the SQL Server Error Logs...
July 28, 2016 at 3:48 pm
I know that you stated that you are on Express Edition, but I wonder if this is your issue:
"HTTP 503: Service unavailable" error when you open the SSRS web portal...
July 28, 2016 at 1:22 pm
When I say the SSRS logs I mean the logs that are natively a part of SSRS. By default they would be located here:
C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles
Reporting Services Log...
July 24, 2016 at 6:38 pm
Did you save a copy of the reportserver.config before changing it? You should be able to revert to an old copy of the config file, restart the reporting services service...
July 24, 2016 at 5:29 pm
Unless you are using a configuration file you should be careful executing the install using PowerShell. Reserved characters in PowerShell might be messing with something you are not expecting. I...
July 24, 2016 at 5:13 pm
I wonder if it is possible the Windows shortcuts are not loading the correct MMC snap-ins after one of the installs. If you manually open up mmc.exe and add all...
July 24, 2016 at 5:10 pm
A couple of things:
1) It seems like in your function you create an object to reference your instance, but I could not tell that the server object was actually being...
July 6, 2016 at 3:29 am
Viewing 15 posts - 106 through 120 (of 966 total)