If I make changes to the linked server properties in the
Security tab, do I need to reboot for them to take affect?
What is the best practice for this?
This is on a SQL Server 2000 instance.
Thanks.They take effect immediately.(or at leat the next time the linked server =is used) if a query happened to be running while youmade the change =isuspect it would not pick up the change, but the next query certainly =should.
Reboot - No
Mike John
"phil" <pjconrad@.icontrans.com> wrote in message =news:09e901c3941f$a54d9d10$a001280a@.phx.gbl...
> If I make changes to the linked server properties in the > Security tab, do I need to reboot for them to take affect?
> What is the best practice for this?
> > This is on a SQL Server 2000 instance. > > Thanks.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment