If you know the database id ,Instead of giving dbid<>0 just give your database ID then check it will display all the details.....

Regards

Chowdary...

Hi Suneel,

It worked for me,Now the User can able to see the Tables but not the definition of the Tables.

But the User can't able to see the SP's.

If i...

Hi Everyone i got the solution by using the following...

use master

go

deny exec on sp_help to public

use DBName ---DBName is Database name,

go

deny select on sys.all_objects to testuser ---TestUser...

Once again thank you all for ur support...

Hi Mr.Suneel,

Thank you for ur valuable reply,

I have Executed DENY SELECT ON SYS.all_OBJECTS TO XXXXX ,But after executing this he can't able to use SELECT cmd but he can able...

😎

😎

Awaiting for your Valuable Replies.......................:-)

In My DB there are 30+tables but here those tables are not showing same like SP also,

If i login with SA i can able to see those ,But if login...

Dear Gail Shaw Sorry for that,

Denying is worked,But here if i login with that newly created login i cant see the table names and all,Database name we know but we...

GilaMonster ,

Yes,We...

Hi Gail Shaw,

I did R&D and found the solution for that View Definition,

But here that Particular login cannot able to see the DB name,Tbl names,Sp names Etc....

Database name we can...

Thank you Mr.John for your valuable reply.

Can you pls give me the Clear declaration on this as am new to this DBA field i cant able to do that.

Where can...

Follow the below procedure.....

Step 1: Primary server i run below queries.

Note: here MyDB is your database name.

1)delete from msdb.dbo.log_shipping_primaries where primary_database_name = 'MyDB'

2)delete from msdb.dbo.log_shipping_monitor_primary where primary_database= 'MyDB'

3)delete from...

Thank you Mr.Perry Whittle...