> > PS: Using linkedserver this really works fast and nicely but linked servers are not enabled by default and customers think if MS didn't enable it then I shouldn't even if temporarily:(
>
> How should linked servers are disabled by default?
> I installed several SQL Server 2005 lately (default configuration, I just change COLLATION) and can add, remove and do whatever I want to do with Linked servers.
>
>
>
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.
Hi Borislav,
Maybe nowadays I need you to ask me questions:)
Now you made me curious, wasn't it disabled and I was mistaken? If it is the case then you deserve a 5 star rating:) It would be far too easy.
Well I am away from my work computer till Monday, I will check it on return (what I remember is you needed to sp_configure something to make linked servers possible - ole in surface configuration? ).
PS: Funny. Check Thread ID: 1296738 on UT:) Looks like I was denying myself.
Cetin Basoz