Activity overview
Latest activity by tdennis
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
ENABLE CHANGE_TRACKING causing differences
I'm comparing a SQL Compare snapshot of a SQL 2008 database with CHANGE_TRACKING enabled on 6 tables to a copy of the same database without CHANGE_TRACKING enabled. I've checked all the Ignore Opti...
Enable trace during specific time window?
Is there a way to schedule the trace option to turn on and off? I'm getting a deadlock alert in the night when a particular job is running, and I'd like to see the trace, but I don't want to leave ...
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
Data Compare hangs retrieving schema
Data Compare 10.0.1.119 gets stuck for 30 seconds on each database.
1. Tables & Views : Retrieving schema, Registering databases 83%
2. Compare: Reading DDL triggers 41% and 91%
(one table selected...
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!
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...