.
.
When I try to perform the following action
Sp_Help Tb_DotnetFunda
The error occurred "
The object 'Tb_DotnetFunda' does not exist in database 'DotnetFunda' or is invalid for this operation."
The reason may be anyone of the following
The table(Tb_DotnetFunda) may not be available on 'DotnetFunda' database.
(or)The current user does not have permission to describe/expand the table structure.
When you use
Sp_Help Tb_DotnetFunda, The current user should have
VIEW DEFINITION permission on this Object.
How to identify whether the current user has the appropriate permission or not:SELECT Has_Perms_By_Name(N'dbo.Tb_DotnetFunda', 'Object', 'VIEW DEFINITION') as 'Permission'
Permission
----------
0
Login as a SysAdmin (sa)
Grant permission to perform this action:GRANT VIEW DEFINITION on Tb_DotnetFunda TO <User Name>
Now, the user can perform the action...
Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions