Viewing 15 posts - 271 through 285 (of 4,477 total)
Try running a trace when you execute the package manually to see what is going on.
Sue
October 2, 2019 at 9:59 pm
Hi All .
How do I keep the retention of SSAS log for 1 month worth of log ?
Thanks
You never mention which log or what version of SSAS so it's...
October 1, 2019 at 7:36 pm
I would guess the changes were made to the config file, ReportingServicesService.exe.config rather than an exe file. After making any changes to the config file, check the Reporting Services log...
October 1, 2019 at 6:54 pm
You don't have to select all the columns - you can select one, two, three or whatever columns as long as they are part of the result set you are...
September 30, 2019 at 11:30 pm
Your missing a comma after the cleanuptime parameter: @CleanupTime = 72
Sue
September 30, 2019 at 5:01 pm
Your welcome Vinay. The bugs in SSMS are pretty bad and they aren't updated in user voice so it's a good idea to learn t-sql equivalents for things you do...
September 27, 2019 at 5:40 pm
The Upgrade Advisor that John mentions is now called Data Migration Assistant. You can download the latest version from this link - the details list the supported versions and 2012...
September 27, 2019 at 5:13 pm
I would try a repair on the Microsoft Visual C++ 2015 Redistributable from Control Panel - select change and then repair. The VS Shell errors are often related to issues...
September 26, 2019 at 10:33 pm
If you are using SSMS 18.2, there is a bug that causes this type of behavior. It sounds like you may be hitting that issue. It's been fixed in SSMS...
September 26, 2019 at 4:39 pm
It's not automatic. With manual failover, an administrator executes ALTER AVAILABILITY GROUP AGGroupName FAILOVER on the secondary. Synchronous commit with manual failover is listed in the Overview Of Failover chart...
September 25, 2019 at 5:37 pm
The Generate Scripts is at the database level so that can also cause some problems - the logins need to be there as that tool generates statements like...
September 25, 2019 at 12:55 am
There isn't a lot of information on it as there is no definitive way to do it - it really depends. On a dedicated server for SSRS, SQL Server could...
September 24, 2019 at 10:22 pm
You would want the log to be at the size it needs for regular operations. If you shrink it regularly you take away the space it needs regularly and in...
September 24, 2019 at 10:07 pm
The Generate Scripts is at the database level so that can also cause some problems - the logins need to be there as that tool generates statements like CREATE USER...
September 24, 2019 at 10:02 pm
Hi All,
Does Ola Hallengren index script takes care of de-fragmenting HEAP tables as well? or just clustered and non-clustered indexes?
Thanks,
Sam
No, just indexes. It's in the FAQ - under Why...
September 20, 2019 at 7:57 pm
Viewing 15 posts - 271 through 285 (of 4,477 total)