**Update**

Hi
I'm working with SQL2000, and I defined the below structure:
MasterTable(No numeric(3),desc char(40)) No is PK
DetailTable(No numeric(3),code numeric(4),other char(40)) No&Code are PK
and I defined an Update Cascade for their relation.and I have an update
trigger on MasterTable.
My question:
when I update the MasterTable, which one occures first(the casecade
action,or update trigger on that)?
I would be grateful if somebody could give me a hint.
ThanksReferential Integrity frist, then the After trigger.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public(selected)
- db_owner(selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.
hi,
u can set a trigger on restorebackup table.
hope this help
from
doller
|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public (selected)
- db_owner (selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.hi,
u can set a trigger on restorebackup table.
hope this help
from
doller|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.

**let user to backup a DB and not allowed to restore it**

Hi
I defined following properties to let a user to backup and restore the DB
which he is the owner of it.
in server role tab: - database creator (selected)
in database access tab(for DB1): - public (selected)
- db_owner (selected)
- db_backupoperator (selected)
now ,how can I set property in a way that just let the owner user, to
backup from DB1 but not able to restore one the backup over DB1?
Any help would be thankful.hi,
u can set a trigger on restorebackup table.
hope this help
from
doller|||Hi,
With a Db_owner and db_backupoperator role assigned an user can not restore
the SQL Server database. For
Restore database the user either needs to be iin one of the server sides
role - db_creator or Sysadmin role.
But any way by using Db_owner and db_backupoperator role you can Backup the
database.
Thanks
Hari
SQL Server MV
<R> wrote in message news:opswvowel3mw7tkz@.system109.parskhazar.net...
> Hi
> I defined following properties to let a user to backup and restore the DB
> which he is the owner of it.
> in server role tab: - database creator (selected)
> in database access tab(for DB1): - public (selected)
> - db_owner (selected)
> - db_backupoperator (selected)
> now ,how can I set property in a way that just let the owner user, to
> backup from DB1 but not able to restore one the backup over DB1?
> Any help would be thankful.