Access code for RAC products:

• RAC for SQL Server 2000: Rac4Sql2K
• RAC for SQL Server 7: Rac4sql
• QALite.NET: 011-652E4E-414C-030709-003

All products are FREE
As of today we would like to offer all products on this website to YOU free of charge. You may contact us by email with comments. Please note that we reserve the right to answer or not answer any emails as we see fit.

Rac v2.2.3 Update
Due to users requests, Rac will now return a resultset with a single row instead of an error for @tablecheck='y' when the base table/view (@from) and the filter (@where) produce an empty resultset.

e.g.
Exec Rac
@transform='count(*)',
@rows='EmployeeID',
@pvtcol='CustomerID',
@from='Orders',
@where='CustomerID=~VINETZ~',
@tablecheck='y',
@racheck='y'

QALite v1.00.13 Update.

• Fix double inserts
• Fix object qualifier
• Remove [database] reference for Create/Drop/Insert script
• Format DateTime data to ISO [YYYYMMDD HH:mm:ss] to ensure cross locale compatibility
• Add QALite.exe.config to redirect .NET framework to use either v1.0 or v1.1 library - This will allow QALite to connect to SQL 2005 Express
• Enhance general operations

Rac v2.2.2 Update
Rac will now allow the use of "'" (single quote) in @force parameter.

The following Rac sample query uses "^" (carrot) as the escape character for the single quote.

e.g.
Exec Rac
@transform='count(*)',
@rows='EmployeeID',
@pvtcol='CustomerID',
@from='Orders',
@force='~Rac^s Force~ & ~VINET~',
@racheck='y'

Rac v2.2.1 Update
Recently it has come to our attention that using Access ADP to execute a RAC query with more than 10 transforms would return no data. This is an inherited problem in Access ADP due to the fact that it can only process a single resultset returned from a stored procedure. When user specifies more than 10 transforms, a SQL Server warning is returned with the resultset. Thus, Access ADP incorrectly interprets the warning as an empty resultset.

The following Rac sample query that correctly returns data plus a SQL warning in Query Analyzer but not in Access ADP.

e.g.
Exec Rac
@transform='count(*) &
_dummy_ & _dummy_ & _dummy_ & _dummy_ &
_dummy_ & _dummy_ & _dummy_ & _dummy_ &
_dummy_ & _dummy_ & _dummy_ & _dummy_ ',
@rows='EmployeeID',
@pvtcol='CustomerID',
@from='Orders',
@racheck='y'

With this Rac update, user will be able to control the row size through the use of @mxlenagg parameter, thus eliminates SQL warning from returning. Please note that the row size is corrected only if there are more than 10 transforms. The row size is reduced by the number of transforms >10 times the value of @mxlenagg. The default value of @mxlenagg is 50.

e.g.
Exec Rac
@transform='count(*) &
_dummy_ & _dummy_ & _dummy_ & _dummy_ &
_dummy_ & _dummy_ & _dummy_ & _dummy_ &
_dummy_ & _dummy_ & _dummy_ & _dummy_ ',
@rows='EmployeeID',
@pvtcol='CustomerID',
@from='Orders',
@racheck='y',
@mxlenagg=3

For more information on the @mxlenagg parameter, click here

QALite v1.00.12 Update.

• Enhance performance for all string handling routines
• Fix Syntax Coloring bug
• Fix ObjectBrowser to correctly handle irregular database names
• Add QALite Flash screen

QALite.Net v1.00.9 update released.
Based on recent requests and feedbacks, the following features have been added to QALite:

• Allow turning on/off syntax coloring
• Accept command line argument:
  • [-?] |
    [
    [-S server_name[\instance_name]]
    [-E] [-U user] [-P password]
    ]
    e.g.
    QALite -S"myServer\myInstance" -E
• Allow streaming DDL_Insert script directly to file - This greatly enhances performance for large table.

QALite v1.00.6 Update.
QALite is updated to work correctly with either .NET Framework v1.0 or v1.1.

QALite is FREE!
As of today, QALite is offered as a free product. Please register to acquire the registered key.

Download the latest copy here.

ObjectScriptr v1.00.19 update released.
It has been reported that ObjectScriptr is not handling TimeStamp datatype correctly. ObjectScriptr v1.00.19 is designed to remedy this by correctly removing any Timestamp columns from the insert statements.

Download the latest copy here.

Rac for SQL2K v2.2 update released.
We are pleased to announce the release of Rac v2.2 Update. The following additional capabilities have been added to enhance user experience.

• Evaluting the difference between consecutive row dates with @diffsdatepart parameter
• Setting limitation on the number of individual string parts in the concatenated list with @concatenatelimit
• Setting limitation the number of pivot columns to be displayed with @ranklimit
• Turning off shorthand for turning @printagg, @row_totals, and @grand_totals with shorthand parameter, @defaults1
• Minor fixes and enhancements for @rowruns and @diffs

QALite.Net v1.00.5 update released.
The following features have been added to this update:

• DDL correctly generates Timestamp/Rowversion Insert statements
• Minor fixes

Rac for SQL2K v2.1 update released.
There has been reports that a certain combination of Pvtcol could assign wrong values to pivoted columns. This update is to address this issue. Please download the fix and apply to your server.

Note: This applies to Rac for SQL 2000 v2.1 only.

QALite.Net v1.00.3 update released.
The following features have been added to this update:

• Case sensitive server supported
• "\{}" escape characters correctly parsed
• Database compare supported over multiple servers
• Object schema compare supported over multiple servers
• Other minor fixes

QALite.Net v1.00 is here.
It's finally here. QALite is a GUI tool for performing various management tasks against SQL Server, specifically Microsoft Data Engine (MSDE). Armed with Transact-SQL one can do anything through QALite. Download a copy of QALite here.

Rac v2.1 for SQL2K released!
The long wait is over. Rac v2.1 is here. You should now see significant performance gain for large resultset. Many other features have also been implemented in this version. Please see Rac documentation for details.

Note: Upgrade to v2.1 from v2.0 is completely *free*. Please use the same v2.0 access code when prompted.

ObjectScriptr v1.00.18 released!
With popular demands ObjectScriptr has been updated with the following enhancements.

• New logo added
• Allow switching to another SQLServer without completely exiting out
• Overcome textbox buffer limit (64kb) by using richtextbox
• Sample rowcount setting is saved and reloaded on next run

QALite.Net v1.00 almost ready for release!
Much has changed since our last beta. QALite has been *improved* tenfold and will now allow you to generate a script of all missing objects between databases. Please check back in a few days for our exciting release.

ObjectScriptr v1.00.17 released!
ObjectScriptr has been updated to eliminate Calculated columns in the Inserts and to handle object ownerships correctly. Download the latest here.

ObjectScriptr v1.00.16 released!
ObjectScriptr has been updated to handle the Bit datatype correctly. It will now allow you to "script all data" by selecting the checkbox. Thanks to Ken Otto for his report regarding the bug and for his suggestion on "script all data". Download the latest today.

QALite v1.x Beta released!
We're pleased to announce the arrival of QALite. QALite is a SQL Server client tool with a rich set of features. Written in VB.Net, QALite is designed to take full advantage of what .Net has to offer, and to supplement some of the missing features from MS Query Analyzer, such as upload/download blobs. Take a test drive today!

Rac4sql.com is back!
1. We would like to take this opportunity to thank Vivian Solares with Intercosmos Media Group, Inc. and Suzette with directNIC Support for helping us regain control of Rac4sql.com domain name after a long battle with our former ISP. Click here for more details.

2. The long await Rac v2.1 is almost ready for shipping.

3. We have another new product coming out soon. This product is written entiredly in VB.Net which we hope you will like. Please check back as more info will be posted here.

Rac v2.1 Public Beta released

1. Rac Gui:
   • Allow direct copy of data from result grid to Excel, Word, etc.
   
   
   • Context-Sensitive Help is enabled.
   
   
   • Allow main form resizing.
   
   
   • Form size settings are saved and restored on load.


2. Row specification changed for @rows parameter.


3. Declaring the pivot column a datetime column.


4. Declaring the length of @rows terms.


5. Declaring the length of the pivot column.


6. Checking the correctness of various parameter arguments.


7. Checking that the input data is not empty (has rows).


8. Returning/using the count of rows in the resultset.


9. Removal of parameters.


10. Expanded use of differences with Grouped Data.


11. Grouped Data now uses the @rotate option.


12. Creating a delimited text file as the Rac result.


13. Controlling internal RAC processing.

***Please review Rac Help documentation for more details.

ObjectScriptr v1.15 Released
This freeware tool is updated to correctly handle IDENTITY and DATETIME columns in the Insert script. All links are also updated to correctly point to Rac4sql.net.

Racsp;7 Stored Procedure Hotfix (v2.00)
A problem has recently been found in calculating rowfunction average in Rac v2.0. As a commitment to our users, a hotfix to Racsp;7 stored procedure has been recompiled and released.

Please follow the download link to left and get the hotfix (racsp_7).

Rac4sql.com ===> Rac4sql.net
The whole thing started on May 01, 2002. One of the users notified us when she was unable to connect to our site. We fired off 4 urgent requests for support to the provider, DataPacket.Net (DPN). We did not receive a reply until the next day, May 02, 2002.

Your account has violated our service polices specifically our Spam policy.
Data Packet has 0 tolerance for any Spam associated with any domain we host.
Due to this policy violation this is your notice to remove any files you may
need from our server as your account will be removed within 24 hours.

Help Desk
Data Packet Networks
http://www.datapacket.net - Home
http://www.datapacket.net/access.htm - 56k Dialup
http://www.datapacket.net/hosting.htm - Advanced Web Hosting

****************************************************
Affordable internet access & web hosting solutions.

Offending message:
Return-path: <newsletter@sqlservercentral.com>
Received: from mydomain.com (vc1-254-2.adsl.indra.com [204.144.189.139]) by
sw2.swtch.com.au
(Vircom SMTPRS 4.6.189) with SMTP id <B0000785626@sw2.swtch.com.au> for
<x>;
Mon, 29 Apr 2002 13:44:14 +0930
Message-ID: <B0000785626@sw2.swtch.com.au>
Return-Path: <newsletter@sqlservercentral.com>
From: "newsletter" <newsletter@sqlservercentral.com>
To: "Michael" <x>
Subject: SQL Server Central Update for 4/29/02
Date: Sun, 28 Apr 2002 22:34:44 -0700
MIME-Version: 1.0
X-Priority: 3
X-MSMail-Priority: Normal
Reply-To: "newsletter" <newsletter@sqlservercentral.com>
X-Mailer: Internet Mail Service
Content-Type: multipart/alternative; boundary="----_NextPart_0785365680"

As you can see, we were shocked and speechless of the accusation. We fired off another email asking for explanation. Of course, none replied. Later that night in the wee hour, we found some articles suggesting this might have been a virus at work. The info can be found here:
http://www.wired.com/news/technology/0,1282,52174,00.html
http://www.wired.com/news/technology/0,1282,52055,00.html
http://securityresponse.symantec.com/avcenter/venc/data/w32.klez.gen@mm.html

We fired off an email warning them of the potential problem on their servers. Again, not a single reply returned either thanking us for the notification nor apologizing for their horrible mistake. Unable to get anything from them, we decided to sign up with another provider, EhostingBiz.com in hope to avoid major blow out for our users. We then sent a request to DPN to release our domain name by letting us make a change to DNS (domain name server). Well, a total of 13 requests was sent to support@datapacket.net, sales@datapacket.net, help@datapacket.net, and billing@datapacket.net throughout the period of 26 hours. Even now, as we are writing up this notice, not a single reply is received. Of course, for those of you who are trying to contact us between May 01 and May 04, you would not be successful. DPN completely shut us down and held our domain name hostage.

We have filed a formal complaint with the State of Florida BBB ( http://www.orlando.bbb.org) and the FBI Internet Fraud ( http://www1.ifccfbi.gov) and are planning to take legal action against them for this horrible act.

Meanwhile, to avoid further confusion for our users, we have decided to move all Rac4sql.com to Rac4sql.net. We also would like extend our 1 month free support to 3 months for all of our current registered users or anyone who registers in the month of May as a token of our appreciation for your continued support. We hope this notice lays to rest any confusion or doubt you may have had about our commitment in providing you the best possible care.

Once again, thank you for your understanding and continued support.

RAC v2.00.545 Released
Recently, it has been reported that Rac v2.0 setup failed to install on some servers and there was no Error log to tell us what the problem might have been. We have decided to recompile the setup package in hope to remedy this. Also, we have decided to include a fix for the GUI where it sometimes fails to load a SQL script correctly.

Please follow the download link to left and get the latest setup.