Not a reply to your last question, just additional comments on CR.

1. As for searching the Business Objects knowledge base, good luck ! I either get 600 links or none...

Regarding the use of Triggers:

The one reason I avoid triggers like the plague is because these are unseen, i.e. if a stored procedure (for instance) is found to be causing...

To actually send an email notification via SMTP, WITHOUT requiring that Outlook be running on the host machine of SS2K and WITHOUT having to configure an email account in SS2K,...

Check out this link [font="Courier New"]http://www.sqlservercentral.com/Forums/Topic527864-110-1.aspx[/font]

This allows you to send (NOT receive) e-mail notifications using SMTP without having to have OUTLOOK running on the host machine for the SQL Server...

Forgot to tell you, the hint I have posted to SEND emails does NOT require that Outlook be installed and running on the MS SQL 2K host machine.

Of course, those...

Begin with:

Sending SQL Server Notifications with CDOSYS

By : Desiree Harris

http://www.sql-server-performance.com/articles/dev/sending_sql_notifications_CDOSYS_p1.aspx

CDO: Collaborative Data Objects, being replaced by WebMail but I have no experience with the latter.

[font="Courier New"]

-- ...

My mistake. I stand corrected.

Regards

Set @strSQL =

'SELECT * from history_view WHERE ' Phone_Number like ''%' + (@history) + '%'''

This can only work if the select statement retrieves ONLY...

I suggest the following link:

MSDN -> MSDN Library -> Win32 and COM Development -> Messaging and Collaboration -> CDO For Windows 2000

Although the Collaborative Data Objects is getting old (soon...

Drifting away.

The subject is the Netiquette for the forum. Especially how to askii a proper question to get an ansii... (shamelessly stolen tag line).

The recent postings just add pages which...

Forgot about the ever-changing status of defaults.

Thanks

This was a quick reply. Thanks. (Even though I did not specify when I "expected" an answer, as posted in the Forum Etiquette topic 😉 )

So I take your answer...

Peso,

This is interesting.

Running it up to 10:

[font="Courier New"]

AsIs Rounded ...

The major beef I have had with CR 8.0, 8.5, 9.0 was orphaned headers when using groups, i.e. the columns names were printed at the bottom of the page and...

I have found the following articles very helpful:

[font="Courier New"]http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

http://aspalliance.com/904

http://blogs.techrepublic.com.com/datacenter/?p=133%5B/font%5D