/***** Voher Serverobjekte -> Verbingundsserver -> Ranking löschen **********/
/****** Object: LinkedServer [RANKING] Script Date: 10/31/2009 12:24:45 ******/
EXEC master.dbo.sp_addlinkedserver @
[Only registered and activated users can see links. Click Here To Register...] = N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]product=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]=N'SQLNCLI', @
[Only registered and activated users can see links. Click Here To Register...]src=N'GALAX-PC\SQLEXPRESS', @catalog=N'RANKING_DBF'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'collation compatible', @
[Only registered and activated users can see links. Click Here To Register...]value=N'false'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'data access', @
[Only registered and activated users can see links. Click Here To Register...]value=N'true'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'dist', @
[Only registered and activated users can see links. Click Here To Register...]value=N'false'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'pub', @
[Only registered and activated users can see links. Click Here To Register...]value=N'false'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'rpc', @
[Only registered and activated users can see links. Click Here To Register...]value=N'true'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'rpc out', @
[Only registered and activated users can see links. Click Here To Register...]value=N'true'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'sub', @
[Only registered and activated users can see links. Click Here To Register...]value=N'false'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'connect timeout', @
[Only registered and activated users can see links. Click Here To Register...]value=N'0'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'collation name', @
[Only registered and activated users can see links. Click Here To Register...]value=null
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'lazy schema validation', @
[Only registered and activated users can see links. Click Here To Register...]value=N'false'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'query timeout', @
[Only registered and activated users can see links. Click Here To Register...]value=N'0'
GO
EXEC master.dbo.sp_serveroption @
[Only registered and activated users can see links. Click Here To Register...]=N'RANKING', @
[Only registered and activated users can see links. Click Here To Register...]name=N'use remote collation', @
[Only registered and activated users can see links. Click Here To Register...]value=N'true'
GO