19 Eylül 2007 Çarşamba
The information used by Microsoft® SQL Server™ and its components are stored in special tables known as system tables.
Note System tables should not be altered directly by any user. For example, do not attempt to modify system tables with DELETE, UPDATE, or INSERT statements, or user-defined triggers.
Applications should not be written to query the system tables directly. Applications should instead use any of these components to retrieve information stored in the system tables:
Information schema views
System stored procedures
Transact-SQL statements and functions
SQL-DMO
Database application programming interfaces (API) catalog functions
These components constitute a published API for obtaining system information from SQL Server. Microsoft maintains the compatibility of these components from release to release. The format of the system tables is dependent upon the internal architecture of SQL Server and may change from release to release. Therefore, applications that directly access the system tables may have to be changed before they can access a later version of SQL Server.
System Tables in the master Database Only
These tables store server-level system information.
sysaltfiles
sysdevices
sysoledbusers
syscacheobjects
syslanguages
sysperfinfo
syscharsets
syslockinfo
sysprocesses
sysconfigures
syslogins
sysremotelogins
syscurconfigs
sysmessages
sysservers
sysdatabases
System Tables in Every Database
These tables store database-level system information for each database.
sysallocations
sysfiles
sysobjects
syscolumns
sysforeignkeys
syspermissions
syscomments
sysfulltextcatalogs
sysprotects
sysconstraints
sysindexes
sysreferences
sysdepends
sysindexkeys
systypes
sysfilegroups
sysmembers
sysusers
SQL Server Agent Tables in the msdb Database
These tables store information used by SQL Server Agent.
sysalerts
sysjobschedules
systargetservergroupmembers
syscategories
sysjobservers
systargetservergroups
sysdownloadlist
sysjobsteps
systargetservers
sysjobhistory
sysnotifications
systaskids
sysjobs
sysoperators
Tables in the msdb Database
These tables store information used by database backup and restore operations.
backupfile
backupset
restorefilegroup
backupmediafamily
restorefile
restorehistory
backupmediaset
Tables Used to Store Replication Information
These tables are used by replication and stored in the master database.
sysarticles
syspublications
sysservers
sysdatabases
sysreplicationalerts
syssubscriptions
sysobjects
These tables are used by replication and stored in the distribution database.
MSagent_parameters
MSmerge_agents
Msrepl_originators
MSagent_profiles
MSmerge_history
MSrepl_transactions
MSarticles
MSmerge_subscriptions
MSrepl_version
MSdistpublishers
MSpublication_access
MSsnapshot_agents
MSdistributiondbs
Mspublications
MSsnapshot_history
MSdistribution_agents
Mspublisher_databases
MSsubscriber_info
MSdistribution_history
MSreplication_objects
MSsubscriber_schedule
MSdistributor
MSreplication_subscriptions
MSsubscriptions
MSlogreader_agents
MSrepl_commands
MSsubscription_properties
MSlogreader_history
MSrepl_errors
These tables are used by replication and stored in the user’s database.
MSmerge_contents
MSmerge_tombstone
sysmergeschemachange
MSmerge_delete_conflicts
sysarticleupdates
sysmergesubscriptions
MSmerge_genhistory
sysmergearticles
sysmergesubsetfilters
MSmerge_replinfo
sysmergepublications
(c) 1988-98 Microsoft Corporation. All Rights Reserved.
14 Eylül 2007 Cuma
7 Eylül 2007 Cuma
Kurcalarken-Gezerken:Nasa Hacker' ı ile Röportaj
Ama benim o hacker'dan çok vurgulamak istediğim yazıdaki şurası:
...
Zincir ve zayıf halka teorisinin kuralının en büyük örneklerinden biri
olsa gerek. Eğer yeterince sistemi tararsanız açık
bulabilirsiniz. Zamanında yahoo' da benzer bir şekilde
normalde internette hiç bir yerde bağlantısı olmayan bir iç proxy ile
hacklenmişti.
...
Bence açık bulmak için çok doğru ve yeterli bir yöntem, yeteri kadar sistemi taramak
3 Ağustos 2007 Cuma
HTML 4.01 Entities Reference
HTML 4.01 supports the ISO 8859-1 (Latin-1) character set.
The lower part of ISO-8859-1 (codes from 0-127) is the
original 7-BIT ASCII
standard.
Most of these characters can be used without a character reference.
The higher part of ISO-8859-1 (codes from 160-255) can all be used using
character entity names.
19 Temmuz 2007 Perşembe
Sql sızma( injection) için gerçek siteleri nereden bulacağım?
Google araması ile sql test sitesi
Microsoft OLE DB Provider for SQL Server error '80040e14'
Column 'soru.cat' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
/sorudetay.asp, line 72
Google araması ile sql test sitesi
Sunucu:Oracle
Hata:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-01756: quoted string not properly terminated
/dockets.asp, line 41