Activity overview
Latest activity by dhathewa
Synchronize Without Preserving Data?
Is there an option to synchronize without preserving data?
If there is, would someone point out how I access it?
If there isn't, it would be a nice feature. It would be best if we could use it on ...
API?
Can I access an API for SQL Dependency Tracker? Here's why I ask:
We have a number of databases with a large number of objects and a full diagram would be unwieldy. I'd like to set up a project w...
Make Triggers Visible as Objects?
I've got triggers on tables that refer back to the originating table. Visibility of the trigger would be handy. Can they be made visible? If so, it's not obvious how this is done.
Will triggers ...
OK... let's try a workaround. For each table, X, that may be referenced by dynamic SQL, I include something like this in the body of the proc:
declare @testfail int
set @testfail = 0
if @testfail = 1 select top 1 * from X where 0 = 1
It seems to provide the dependency tracking information I need but it won't ever return anything and doesn't seem to change the way the proc runs.
Does anyone think there is a disadvantage to this that I've overlooked? There's probably a performance hit but when compared to the performance of assembling and executing a string, I doubt that it's a big deal. / comments
OK... let's try a workaround. For each table, X, that may be referenced by dynamic SQL, I include something like this in the body of the proc:
declare @testfail int
set @testfail = 0
if @testfail ...
I'm unfamiliar with SQL Search but searching and writing down dependencies... well, I could do almost that well with a couple of queries against sysdepends and a spreadsheet and then searching and dressing my spreadsheet up with manually added entries, no?
Or I could just do the basic dependencies into a spreadsheet, search for EXECs and send that list of stored procs offshore to get a list of further dependencies at $15/hour.
OK... I get that there's no feature in the product to do this, which is a huge disappointment, but there are certainly other dbas out there that have dynamic SQL. "Have you considered using SQL Search?" is a disappointing answer. / comments
I'm unfamiliar with SQL Search but searching and writing down dependencies... well, I could do almost that well with a couple of queries against sysdepends and a spreadsheet and then searching and ...
User-Defined Dependency Tracking
I don't think this is redundant, I checked around the forum and help topics and found no info on this item.
Some of our stored procedures do EXECs on strings to manipulate data. There are usually ...