Showing posts with label particular. Show all posts
Showing posts with label particular. Show all posts

Sunday, March 11, 2012

Can Log Shipping be done for a particular table.

Hi,
I have a question. Its about Log Shipping.
I know that log shipping can be done for a database,
But Can Log Shipping be carried out for a table.
If any one knows anything about it, please comment.

Thanks
~sdas

Log shipping is done per database.

Replication allows you to selectively choose which data to replicate to the target.

It's probably what you want.

Sunday, February 19, 2012

Can I set user rights to table access ?

I know that you can specify user rights on the particular database. But how about table access.
Can I set rights to a particular user either for read, write for a particular table only?Originally posted by Patrick Chua
I know that you can specify user rights on the particular database. But how about table access.

Can I set rights to a particular user either for read, write for a particular table only?

yes u can...create a new user login for your database which u want to grant restricted access to.Goto your database -> user -> select the new user's properties --> goto permission. From there you can control the access of all tables.