Activity overview
Latest activity by johnchantha
We want to know if SQL Doc and SQL Dependency Tracker can tracks
objects across databases on the same server for SQL Server 2008 R2.
Below is the sample/demo script.
As part of the reversed engineering, I only know ATable in ADatabase (see below).
If I am to drop Atable from ADatabase, what is the impact to other objects across databases BDatabase and CDatabase (see script).
My initial test appears to indicate that the current version of both SQL Doc and SQL Dependency Tracker have no functionality to perform this task.
Please advise.
Thanks
John Chantha
use master
go
create database ADatabase
use ADatabase
go
create table ATable (Id int identity(1,1) not null, IdValue varchar(10))
Insert into ATable(IdValue) values('A Value')
create view vw_A
as
select * from ADatabase.dbo.ATable
go
use master
go
create database BDatabase
go
use BDatabase
go
create view vw_B
as
select * from ADatabase.dbo.vw_B
go
use master
go
create database CDatabase
go
use CDatabase
go
create view vw_C
as
select * from BDatabase.dbo.vw_B
go / comments
We want to know if SQL Doc and SQL Dependency Tracker can tracks
objects across databases on the same server for SQL Server 2008 R2.
Below is the sample/demo script.
As part of the reversed enginee...
Sql Dependency Tracker and SQL Doc: dependency across databa
Sql Dependency Tracker and SQL Doc: dependency across databases
Can SQL Dependency Tracker v 2.7 tracks objects across databases?
i.e. I have these scenario below:
serverA with tableA
serverA with...