Comments
Sort by recent activity
I have, it's ticket https://productsupport.red-gate.com/hc/requests/260283 / comments
I have, it's ticket https://productsupport.red-gate.com/hc/requests/260283
@DanC I copied the whole SQL Compare folder to another folder on my same machine and it still throws Object not found errors. It doesn't even work running from inside the SQL Compare installation folder. > redgate.sqlsnapper.exe SQL Snapper V14.5.22.19589 ============================================================================== Copyright © Red Gate Software Ltd 1999-2021 Registering sqltest._source_redgate Saving Database To Snapshot Finished FAILED Unexpected error: Object reference not set to an instance of an object. Object reference not set to an instance of an object. RedGate.Legacy.CommandLine.FatalExecutionException at RedGate.SQLCompare.SQLSnapper.SnapperCommandProcessor.Run() at RedGate.SQLCompare.SQLSnapper.Program.Main(String[] args) / comments
@DanC I copied the whole SQL Compare folder to another folder on my same machine and it still throws Object not found errors. It doesn't even work running from inside the SQL Compare installation f...
Found it - thank you! / comments
Found it - thank you!
Second this / comments
Second this
This issue is resolved in SQLDataCompare_10.2.0.315.exe
Thank you!!
Traci / comments
This issue is resolved in SQLDataCompare_10.2.0.315.exe
Thank you!!
Traci
Thank you so much for your reply! I tried your query and unfortunately, the sys.sql_dependencies is missing most of the stored procedures in the database. A google search revealed procedures that create temp tables, then run a query that joins in the temp table, will not record those dependencies due to deferred name resolution. If I create the temp table outside the proc, then exec sp_refreshsqlmodule '<procname>', the dependency information does get recorded. Almost every procedure in this database uses a generically named temp table with different column definition, so I may try to programmatically extract the create temp table statements for each proc so it could be re-created with the correct definition just prior to exec sp_refreshsqlmodule. I'll let you know if I make any progress on it, and again, thank you for taking the time to write up that query :-)
Traci / comments
Thank you so much for your reply! I tried your query and unfortunately, the sys.sql_dependencies is missing most of the stored procedures in the database. A google search revealed procedures that c...
Please add my vote for this feature. I would like to be able to call some kind of function from T-SQL for each column in a database to output a list of objects that are dependent on it (so I can see which columns are not being referenced by any stored procedures).
The Dependencies list from Smart Rename is perfect, except it takes way too long to manually check hundreds of columns.
Thank you,
Traci / comments
Please add my vote for this feature. I would like to be able to call some kind of function from T-SQL for each column in a database to output a list of objects that are dependent on it (so I can se...
I too would love an option to disable this "feature!" When I press the ' key, I want one to appear and not act like a cursor-right press! / comments
I too would love an option to disable this "feature!" When I press the ' key, I want one to appear and not act like a cursor-right press!