Viewing 15 posts - 16 through 30 (of 1,417 total)
By my knowledge the RDL of the standard reports is not available. You could profile the reports to get the underlying SQL, but you would still need to recreate the...
April 30, 2019 at 11:44 am
Thanks! I was able to solve this by taking database offline then immediately bringing it back online.
This sounds like the storage (SAN/mountpoint?) where the LOG file was located was...
April 30, 2019 at 11:21 am
A listener doesn't prevent access to other databases on the primary instance. Since you disabled the network card on the primary server, the secondary server becomes primary for each and...
April 19, 2019 at 1:01 pm
Create a "Numbers" table holding all the numbers required to display the expanded result. Join this "Numbers" table with the source table on both the ROW_ID and the Last_Row column....
April 19, 2019 at 12:49 pm
Make sure the mail server is configured to allow the SQL server to relay messages. Also make sure you have set up the correct credentials for the database mail configuration....
April 19, 2019 at 12:24 pm
In addition to Grant Fritchey's post: create credentials and use proxy accounts (see: https://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/) to run SSIS packages from SQL Agent jobs.
April 3, 2019 at 10:26 am
I have decided to go for the Powershell route and...
September 13, 2018 at 10:36 am
Viewing 15 posts - 16 through 30 (of 1,417 total)