"Trusted for delegation".

MSSQL2K5
SP1
Im reading in BOL regarding Linked Servers:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9e302c29-639d-4509-ba1e-cf45
2582c5c3.htm
and it says:
Requirements for the First/Middle Server (SQLSERVER1)
a.. The server must have an SPN registered by the domain administrator.
b.. The account under which SQL Server is running must be trusted for
delegation.
What is "trusted for delegation"? Where do I configure it?
TIA, ChrisRChrisR wrote:
> What is "trusted for delegation"? Where do I configure it?
This is a user object setting in Active Directory, usually set with
Active Directory Users & Computers.
http://support.microsoft.com/kb/305144/en-us|||Cool, thanks.
<tom.freedman@.gmail.com> wrote in message
news:1154456842.034250.326350@.i42g2000cwa.googlegroups.com...
> ChrisR wrote:
> This is a user object setting in Active Directory, usually set with
> Active Directory Users & Computers.
> http://support.microsoft.com/kb/305144/en-us
>

"INSTEAD OF" Triggers don't seem to work (maybe I misunderstand?)

SQL Server documentation (BOL) states that an "instead of" trigger represent
s
code
that will execute instead of the action requested by the statement that
caused the
trigger to fire. For example, in the case of an "instead of update"
trigger, the
update statment which caused the trigger to fire, would be prevented from
updating the table, simply by virtue of the fact that an "instead of update"
trigger exists. Am I understanding this correctly?
I have an "instead of update trigger" which does not prevent the update
unless I explicitly do a ROLLBACK TRAN. Is this the expected behavior?
TIA,
R. AldersonAn Instead Of trigger should prevent the update. Can you post your code?
Try the following:
Set Nocount on
use pubs
go
Create Table foo (foovalue int)
go
Create Trigger trFoo on foo
Instead Of Update As
Select 'trFoo trigger Fired'
go
Insert Into foo (foovalue) values (1)
Select * from foo
Update foo Set foovalue = 2
Select * from foo
Drop Table foo
Your result should be :
foovalue
--
1
trFoo trigger Fired
foovalue
--
1
showing that the update of foovalue to 2 did not take place.
Tom
"rca" <rca@.discussions.microsoft.com> wrote in message
news:3C9E59C2-8BCB-4A86-A3FA-F2ED58014214@.microsoft.com...
> SQL Server documentation (BOL) states that an "instead of" trigger
> represents
> code
> that will execute instead of the action requested by the statement that
> caused the
> trigger to fire. For example, in the case of an "instead of update"
> trigger, the
> update statment which caused the trigger to fire, would be prevented from
> updating the table, simply by virtue of the fact that an "instead of
> update"
> trigger exists. Am I understanding this correctly?
> I have an "instead of update trigger" which does not prevent the update
> unless I explicitly do a ROLLBACK TRAN. Is this the expected behavior?
> TIA,
> R. Alderson