An orphan user is a user in a SQL Server database that is not associated with a SQL Server login. Learn how to identify which databases have orphan users, and how to remove the identified orphan users.
Other News
Searching for Text within the Trigger Body
The following two scripts provide a way for searching a text within a trigger body (LONG datatype column):
Automate documentation tasks
By Garet Griffin – By automating some of the documentation tasks for your databases, you are doing yourself and your sponsor/client a big favour. The procedures below are examples of simple routines that can be stored in the MODEL database, and therefore propagated to all new databases.
XML/XSL Transformations in ASP.Net
By Mark Neustadt – Using XML/XSL is one of the most powerful technologies available to advanced web application developers. If you have a team split into several different sections (technical, production, graphics), using XML/XSL is a saviour. You see, XML/XSL gets us many things, not the least of
XML Matters: reStructuredText
The document format called reStructuredText has been adopted as one of the official source formats for Python documentation, but is also useful for other types of documentation. reStructuredText is an interesting hybrid of technologies — in syntax and appearance it is similar to other “almost-plain
Apache release Web Services Invocation Framework 2.0
The Apache Web Services Invocation Framework team announced the first open release of their Apache WSIF API.
Past, Present, and Future
Michael Otey revisits SQL Server’s six major releases, then looks to the future and the upcoming Yukon release.
Slammer report: More headaches
By Robert Lemos – After a round-the-clock weekend watch for any infection of the so-called SQL Slammer worm–also know as Sapphire and SQL Hell–that hammered other companies’ networks, the software maker apparently had escaped with only minor incidents in its international offices. Until Tue
External Tables in Oracle 9i
Learn how to run any SQL query against external data without requiring that the external data first be loaded into the database.
Browsing OS files from TOAD or SQL*Plus
By Jim Leask – This tip describes the process required to browse operating system (OS) files from a PC application like TOAD or SQL*PLUS. This process will be useful for browsing the Oracle alert log when access via the OS is restricted. It will only work on Oracle version 8.1.6 and above.