sp_help problem

At Query Anlyser,from Master database, this works
select * from test..tt
but not this
sp_help 'test..tt'
test is dbname and tt is table name
any reason?

Quote:

---

any reason?

---

Because!

:D

The sp_help procedure looks for an object in the current database only.
So it is by design.

And So it will work if U do this:

Code:

---

USE test
EXEC sp_help 'test..tt'

---

Best regards,
Krzemo.

Another way to do is like so

EXEC test..sp_help 'tt'

Quote:

---

Originally Posted by antares686

Another way to do is like so

EXEC test..sp_help 'tt'

---

Thanks
It worked