Sure enough, a change in the drivers took care of the numeric data type issue.

For anyone who's intereted, the original problem appears to be related to Oracle

having thee Number data...

Thanks for the lesson, I couldn't make it work.

Just for the record (for those of us in small shops). Set up a new Operator,

in the e-mail field select the users to be e-mailed (assuming Outlook).

The users...

Couldn't this be accomplised by use of a sproc?

I'd forgotten about that. If I remember correctly one possibility is the decimal value

missing either the 'Precission' or the 'Scale' value. Hope this helps.

Hello.

Should work. The only suggesting I can give is try using the 'Microsoft ODBC Dirver for Oracle'

if you're not already. That was the only hangup I've had...

I don't have a lot experience using the * with the Full-Text Search. But would performing two * searches be faster than what has been suggested? For example:

SELECT...

Our office loves using xp_sendmail for business flow notifications. An overview can be found at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_6hbg.asp

Hello.

I believe CONTAINSTABLE is combining the results of individual searches on all of the columns that have been registered for searching. So, if Record 1 in 'OtherColumn' contains...

Thanks for the reply.

My unit it actually worried about the entire list. Unless I come across a better way I'm planning on importing the list of noise words into...

I would add another reason to performing all the actions on the SQL box. When I faced this issue last summer not only did I see a very large...

Don't know about SQL 7 but in 2000, right click on db, choose Options tag, (or go to Tools and select Options), Compatability Level is at the bottom (6.5 would...

Try the below site for community and test questions.

http://www.mcsebraindumps.com/

Yes you can, and it's done by changing the description (which you did). The only thing I'm not sure of in your description is 'going into disconnected edit'. ...

One reason is that the next step in the primary DTS package must be dependent 'on success' of the previous step (displays as green arrow, can be set from the...