Netscreen PPPoE, DHCP und DNS

Eine Netscreen als Internetzugang per PPPoE. Ein DNS-Proxy am internen Interface und verschiedene Server für unterschiedliche Domain.

# unset pppoe name xyz update-dhcpserver
# get pppoe name xyz | include update
clear ip on disconnect: OFF, update dhcp server: OFF, admin preference 100
Update Local DNS: ON
# get conf | include server-select
set dns server-select domain abc.de outgoing-interface tunnel.2 primary-server 1.2.3.4 secondary-server 4.3.2.1
set dns server-select domain * outgoing-interface untrust failover

siehe auch Juniper Netscreen Commands

Database Definition

[code lang=“sql“]use mydb
go
select s.object_id, s.name, s.schema_id, s.type, s.type_desc, object_definition(s.object_id)
from sys.all_objects s
where type IN (‚P‘, ‚V‘, ‚FN‘, ‚TR‘, ‚IF‘, ‚TF‘, ‚U‘)
and is_ms_shipped = 0
order by s.type, s.name
go[/code]

[code lang=“sql“]use mydb
go
sp_helprotect
go
sp_helprotect ‚dbo.myview‘
go
sp_help ‚dbo.myview‘
go
select object_definition(OBJECT_ID(‚dbo.myview‘))
go[/code]