SQL Server 2008 R2: Get table_name from view from other database -

-

i have 2 database namely db1 , db2.

presently working on database db1. have view stored in database db2 name view_1. want table names present on view database db1.

my try:

i using database db1.

try 1:

 select table_name   information_schema.view_table_usage  view_name = 'db2..view_1';

try 2:

 select table_name   information_schema.view_table_usage  view_name = db2..'view_1';

but not getting table_name's other database view.

like this

 select table_name   db2.information_schema.view_table_usage  view_name = 'view_1';

Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

python - How to read gradle build progress from it's output? -

-
i execute gradle python subprocess: proc = subprocess.popen(["./gradlew", "assemble", stdout=subprocess.pipe, stderr=subprocess.pipe, ) then run 2 threads read stdout , stderr: class mythread(qtcore.qthread): def run(self): while true: line = self.stream.readline() if line not none , len(line) > 0: // process line else: break i read log correct, can't read output like: > building 53% > :project:assemble i tried replace readline read , not helped. if execute: ./gradlew assemble | hd i not see build progress in hd . is solution read progress?
Read more

c# - How do I debug "System.DllNotFoundException: The specified procedure could not be found"? -

-
i've got pinvoke wrapper set native dll, time try invoke it, crashes, saying system.dllnotfoundexception: specified procedure not found . things i've checked: the dll in same folder exe. dependency walker shows dll has 1 non-system dll dependency, , it's loaded (successfully) process point. it gives same error no matter function try call into, including dummy function no body. (so points 1 , 3 answer here not apply.) i've used dependency walker ensure functions being exported, same names, including case sensitivity. by point, i'm @ wits' end. how can debug , figure out what's going wrong? error message i'm getting spectacular pile of fail when comes usefulness; doesn't tell me name of procedure can't find. i'd debug first in native application. reasons explain later. put simple console app in same directory c# executable. have console app call loadlibrary , getprocaddress on dll p/invoking. same error occur? ...
Read more