Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2008-01-14 : 09:58:04
|
| This SP tells only one Table_Cat even though I have access to more than 1. Any way to find out all the Table_Cat the LServer has access to?http://www.sqlserverstudy.com |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-14 : 09:59:34
|
| what sp? what are you talking about?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-14 : 12:13:46
|
| how are you calling it and what is the result you get?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-14 : 12:20:54
|
Have you tried usingsp_helptext 'SP_TABLES_EX' ?Have a look at the statement at line 41 as the error message tells you to.Read about sys.fn_remote_tables function.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-01-14 : 15:30:33
|
| sp_tables_ex only shows the default database on column TABLE_CAT. e.g. MASTERlogin: sasa has sysadmin permissionsI want the linked server to show all the databases on the column TABLE_CAT not just 'master'Hopefully, you understand this time.http://www.sqlserverstudy.com |
|
|
|
|
|
|
sp_tables_ex LServer