SQL -Server 2008 -57
Security
Under
Linked Servers

Created a new Linked Server in ADS.
Then used Script object to window as Create and tried to drop and recreate the Linked Server.

Got the below error message

>[Error] Script lines: 4-9 --------------------------
 You cannot specify a provider or any properties for product 'SQL Server'. 

when I compared with SQL Management Studio and script generated by ADS has extra parameters marked in red. See attached Pic also.

USE [master]
GO
master.dbo.sp_addlinkedserver
@server= N'tar_ls_1',
@srvproduct= N'SQL Server',
@provider= N'SQLOLEDB',
@datasrc= N'tar_ls_1'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'collation compatible',
@optvalue= N'false'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'data access',
@optvalue= N'true'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'rpc',
@optvalue= N'false'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'rpc out',
@optvalue= N'false'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'use remote collation',
@optvalue= N'true'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'collation name',
@optvalue= N'Turkish_BIN'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'connect timeout',
@optvalue= N'0'
GO
master.dbo.sp_serveroption
@server= N'tar_ls_1',
@optname= N'query timeout',
@optvalue= N'0'
GO
USE [master]
GO
master.dbo.sp_addlinkedsrvlogin
@rmtsrvname= N'tar_ls_1',
@locallogin= null,
@useself= N'false'
GO