I have a sql server 2008r2 model.
What do I want to do: I want compile all the views/stored procedures scripts in the order dictated by their dependency. In other words if View1 uses View2 then the script for View2 should run before the script for...
Hello,
I am making efforts not to express my frustration dealing with the PD reporting tool
I want to pull out of my data model a simple a list of tables, and for each table the list of its columns with their information, name, datatype, commen...
Hello,
Is there a way in PD to mark a sql server computed column as persisted? I couldn't find a checkbox on any of the column properties tabs. Here is the link to the ms docs:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-co...
Hello,
If I do a full reverse engineering of a SQL Server 2008r2 database, can I write a report that allows me to find all ***CHAR fields that appear in joins against fields with a different N***CHAR field?
Our database does not use consistently ...
I use MS Sql Server 2008 R2.
I have a table that I want to replace with a table with the same name (the new table has a different structure). Before I create the new table, I want to rename the old one because I want to populate the data in the ne...
This list report produced indeed what I need - I am impressed! One observation though, the report didn't include views in the Source Object column. It showed me stored procedures only. Any idea why? Perhaps this is why the View References list is emp...
This list is empty. Not sure why. After reverse engineering a database, doesn't PD determine the dependencies based on the view source code?Just to expand here, we have views that reference tables in different databases. I am not even sure how this w...
Hi, George, Thank you for your email. I know that the sorting works in that dialog you attached for the standalone List Report, however, for the Table -> List of Columns item inserted in a report, the Sort and Filter dialog doesn't seem to work. As s...