R.P.Rozema (1/10/2017)

---

The feature to look for is CDC (Change Data Capture). Introduced in SQL server 2012, it required an enterprise license, but in newer versions it is available in other...

The error message says "Error description: Attempted to perform an unauthorized operation."

Looks like you don't have permissions to install on your machine.

Unfortunately, if you have objects inside an object (and then in your case, another object inside that object), then you have to shrink each object before shrinking it parent.

SSRS won't...

To quote from the SSDT Page:

SSDT works best with Visual Studio 2015

---

If you don't have Visual Studio installed on your machine, installing SSDT will also install a minimal “Integrated Shell”...

There is no native support for reading JSON in SQL Server...

I see your goal, however, I therefore think your datasets and way your using SSRS don't align. SSRS is happy to receive summarised values, if that's all your going to...

MMartin1 (1/9/2017)

---

Thom A (1/8/2017)

---

If your aim is to continue from a "checkpoint" after a failure, I would suggest 1 of two ideas.

1. Log what you have processed thus far, then,...

Should these processes actually be running at the same time? If they are both going to update a column at the same time, then you're going to be getting a...

I'm impressed at your patience so far Sean, this is getting quite the ugly dataset.

As Sean said before, I think at this stage you would be better off redesigning your...

Firstly, the sample table you provided doesn't work for the rdl xml you provided. You are summing BIT columns, which you can't do (BIT can't have a value higher than...

Do you mean that the parameters are not correct on the Sub report? This would mean that have been declared incorrectly in the on click action of the parent report.

Somewhere your logic isn't correct if the data isn't consistent.

What is the actual query your sub report is running? In your post you said it should be running something like,...

ehlinger (1/9/2017)

---

This isn't my database design, however, the actual database itself is in 1st Normal form. To get a quick and easy example I posted this knowing I'd have...

Why not exclude them in your WHERE clause?

SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName

FROM sys.tables t

WHERE t.name NOT IN('Table1','Table2','Table3','Table4','Table5','table6') --You could get these from a table if they could change

Considering you have been here long enough, you really should use the correct forum for your question. For example, some of the other topics you have created are in the...