SQL Server contains two kinds of roles: standard roles and applicaton roles. Standard roles function like groups. For standard roles, users are assigned to the roles and then permissions are granted to those roles. Both types of roles can be created using the Enterprise Manager.
Community
Me Too.NET
Editorial by Michael Otey – As the saying goes, imitation is the sincerest form of flattery. Microsoft must be blushing a lot these days. No sooner did Oracle and Sun Microsystems finish lambasting Microsoft's new .NET Framework than each company launched its own Internet application platform—ea
FoxTeach/SQLTeach
The Universal Thread reporting team has released the official coverage of the FoxTeach/SQLTeach conference which was being held in Toronto, ON this weekend. The conference focused on Visual FoxPro and SQL Server. Top topics at the conference were about the Microsoft .NET framework, the upcoming
XML & Binary Data
XML solves varieties of problems. Keep in mind that XML is not only for web. It can be used for virtually any kind of application – depends on your imagination. It's best suited to pass data across machines running different platform/operating system, because everybody understands plain text
Jato: Open Source Java/XML Translator
Andy Krumel recently announced the 'Beta 3 preview release 2' version of Jato, a new library for converting between Java and XML. The preview release contains the initial version of the Jato debugger and improved expression support. With development hosted on SourceForge, Jato is "a GPL
A Brief History of SOAP
by Don Box – It's been a little more than three years since I first started working in XML in general and SOAP in particular. For the past year or so, my own SOAP work has been pretty minimal, mainly because without a stable XML Schema specification, the thought of building tons of SOAP support
Advanced Transact-SQL for SQL Server 2000
"Advanced Transact-SQL for SQL Server 2000" by Itzik Ben-Gan (SQL Server MVP) and Tom Moreau Ph.D, published by Apress. Don't let the SQL Server 2000 in the title fool you. There is plenty of information that applies to both SQL Server 6.5 and SQL Server 7.0 in this book. Here is an e
Beginning SQL Server 2000 for Visual Basic Developers
This manuscript is an abridged version of a chapter from the Wrox Press book Beginning SQL Server 2000 for Visual Basic Developers. This chapter explores new XML features in SQL Server 2000 and takes a look at how you can exploit them to your benefit. We will also take a look at how we can use XSL (
Wireless Apps: The Reality Today
It is not difficult to create a Wireless application using existing resources (whatever these may be); in most cases, this involves configuration of the server followed by the appropriate developments. The first Wireless applications to be developed followed this principle; in other words, they used
OASIS release DOM Level 1 conformance tests
The two suites, in ECMAScript and Java, were developed by NIST and submitted to OASIS. The ECMAScript suite is interactive, providing as-it-happens information on test passes and fails. There are over 800 EMCAScript tests, which cover all fundamental, extended and HTML interfaces to the DOM.