Need Tech Review of MSSQL Backup Chapter for OReilly Book

My name is W. Curtis Preston, and I'm the author of "Backup & Recovery"
(formerly "Unix Backup & Recovery") from O'Reilly & Associates.
(http://www.oreilly.com/catalog/unixbr/ )

We're updating the book for 2006 and adding a chapter on SQL Server
backup and recovery. Someone has already written what appears to be a
strong chapter. The problem is that I'm not qualified to review it,
since I'm not that familiar with SQL Server

Can anyone in this group step up to the plate and review the SQL Server
chapter? You would be mentioned in the acknowledgments of the book and
receive an autographed copy of the book.

We're looking for two tech reviewers.We've got tech reviewers now. Thank you, everyone!

Need Info on Tools for MSSQL Reporting etc.

Hi All,

Am looking for inputs on tools for MSSQL. Some of my requirements are

1) Database Audits or to audit database settings and Logins
2) Performance Monitoring
3) Query Tuning
4) Data Compare
5) Load Testing - to see how an sql instance/server reacts to higher load/volume.

I am looking for reviews/web-links from any first-hand experience wherever possible.

TIA,

Warm Regards,
Ranjit.redgate has many excellent tools for sql server. their data compare tool is quite good. www.red-gate.com

Friends of mine like the tools from ApexSQL, but I haven't used them much.

BPA is a free tool from MS for analyzing server settings for "best practices" (like blank sa password, etc).

Finally, a plug for my own too: if you have a need for documenting your databases, you might check out sqlspec, a tool I wrote myself at the link in my sig below. :}

Need help, crystal 8.5 trying to open diferent DSN...

Hi...

I have an application in VB6 and CR8.5 with MSSQL, this app is multi-company, means that have to open 1 or more MSSQL databases, opening the first DSN (ODBC) is ok (opening directly is another headache), but when I try to open a diferent DSN to open another DB by code I get the message "Server has not yet been opened".

Note that I am using Crystal Designer and Viewer control, it seems that the crystal is only opening the DSN that is set by default in designer window... I dont know what am I doing wrong...

Thanks in advance

PD1: sorry my english is not good at all...

PD2: This is the code to open report:
--- CODE ----
Dim m_Report As New tax_rpt_anulados 'set original report to variable

m_Report.Database.LogOnServer "pdsodbc.dll", "DSNname","DBname", "username", "password"
m_Report.RecordSelectionFormula = "{tax_anulados.tipoComprobante}=1"
m_Report.ReportTitle = "Title of report"
CRViewer1.ReportSource = m_Report
CRViewer1.ViewReportHi again guys, dont worry about this question I already solved...

Thanks anyway...