Viewing 15 posts - 1 through 15 (of 4,106 total)
The looks like the query SSRS fires when someone views My Subscriptions, usually with a parameter at the end for the user. I never followed it enough in any trace...
August 15, 2019 at 7:20 pm
Just running sp_configure (with or without using reconfigure) won't necessarily change the config block in master which is what DBCC CONFIG reports. It's often not flushed to disk until a...
August 14, 2019 at 7:37 pm
Yes. The last two options can be set in a single alter database. But once the query store is enabled, you really need to monitor things to make sure the...
August 13, 2019 at 8:25 pm
You need to enable TDE on the subscriber if you want it encrypted. Enabling it on the publisher does not affect the subscriber.
August 13, 2019 at 4:53 pm
It's in the documentation. One example in this link:
Frequently Asked Questions for Replication Administrators
How do I manage constraints on published tables?
There are a number of issues to consider regarding...
August 12, 2019 at 11:19 pm
No. There is a parameter to disable then on the target instance using -DisableOnDestination but the entire job is copied.
August 12, 2019 at 10:07 pm
You shouldn't need to kludge anything on a clean install. The first thing to check would be the logs from the installation - default location is C:\Program Files\Microsoft SQL Server\nnn\Setup...
August 12, 2019 at 8:48 pm
The answer is pretty clear (and correct) when I read it:
This is similar to another question (https://www.sqlservercentral.com/questions/get-the-datetime), but this time an error is returned. Addition is not allowed...
August 12, 2019 at 7:46 pm
What would be the best way to achieve this considering the data being replicated is missing unique row ids and preferrably we would not wish the source tables to...
August 12, 2019 at 7:41 pm
Could be the underscore in the directory name - Try enclosing the paths in double quotes.
August 12, 2019 at 7:17 pm
Yes. There are additional ports you may need to open depending on what features are being used (service broker, debugger, url access, etc). The follow documentation is a good reference...
August 12, 2019 at 10:48 am
It's hard to tell which piece is missing - the configuration, connecting to listener, etc. This blog has a walk through on how this connection works - try going through...
August 8, 2019 at 9:52 pm
Doesn't matter as a report still needs a datasource or it needs to be embedded in the report. I would check the reporting services log and see if there is...
August 8, 2019 at 7:02 pm
Make sure you have uploaded the datasource for the report before uploading the report. If you are using a shared datasource that already exists, make sure it's referenced correctly in...
August 8, 2019 at 6:36 pm
Create a role with the necessary permissions and add their logins to that role. Roles and groups are usually the easiest way to minimize overhead of maintaining user, permissions. Keep...
August 8, 2019 at 12:03 am