sp_help problem

[Madhi]

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?

[Krzemo]

any reason?

Because!



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:

 USE test
EXEC sp_help 'test..tt'

Best regards,
Krzemo.

[antares686]

Another way to do is like so

EXEC test..sp_help 'tt'

[Madhi]

Another way to do is like so

EXEC test..sp_help 'tt'

Thanks
It worked