By Eli Leiba – Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager, but is still worthwhile. Here are the T-SQL steps to take in order to implement FTS in T-SQL.
Other News
ASPReport Enterprise General Info
ASPReport is a data driven, web reporting solution for Microsoft SQL Server. Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of reports in a few minutes rather than months.
Additional Criteria in the JOIN Clause
Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, “Why did they put that in the JOIN instead of in the WHERE clause?” What difference does it make? Well recently I found out that I needed this functi
Print Object Dependencies Recursively
by Ahbaid Gaffoor – Using the procedure below, you can examine the database to provide a listing of objects dependent on the supplied object. This is recursive, so you get a tree of dependencies as your output. Here is the procedure. Note that you should create it as SYS with a publicly executable s
Weekly Review: Oracle’s Modest Proposal
In this week’s commentary: For technology vendors market leadership means marketshare, so it’s no surprise to see Oracle claim standards leadership in Web services orchestration.
Validating XML Against Multiple Schemas using the XmlValidatingReader
The XmlValidatingReader provides an API for validating XML documents against XSD schemas. In many cases a single XML instance document may be validated against a single XSD schema.
IBM’s Web Services Security Answer Lies with Tivoli
By Jim Wagner – IBM will release new software in its Web services suite of applications early next year to address the problem of data security, officials announced Wednesday.<br><br>The Tivoli Access Manager is scheduled for release in the first quarter of 2003, in what officials said would "provid
Brother, Can You Spare a DIME?
by Rich Salz – Last month we talked about the reasons for associating attachments with SOAP messages, and we looked at the initial SOAP Messages with Attachments (SwA) note. This month we look at Direct Internet Message Encapsulation (DIME), a binary message format; and we’ll also look briefly at th
Using Functions
John Paul Ashenfelter continues his SQL tutorial with one of the most useful but most frustrating areas of SQL: built-in functions.
SQL Server Magazine LIVE!
Learn from and interact with the writers from Sql Server Magazine. Check it out for dates and location!