Search results for query: *

I already did it and it worked the issue now is that part of my mail messages are not delivered. Tks

Hello, I've an issue with my Exchange 5.5 server, I can see in the outbound meesages queue a big list of blank originators, they appear just like that: <>, I know there is no more support for this verison but maybe somebody knows how to prevent this issue, it is generating a lot of traffic in my...

Hello Guys, I'm not sure what really worked but I've disabled the e-mail checking component and updated the SP3 for office and it is working now. Tks a lot

I have office scan by Trend Micro but this is the only one PC with that issue all other pc's have the same antivirus.

Hello, I have a user who uses pop3 without any problem but sudenly the incoming mail server changes automatically to "localhost" instead of the correct pop3 server address, I have to change it in a daily basis and don't know why this is happening, a virus, maybe? Tks

I'm exporting to a txt file and never importing data to the source files

I've created a DTS that was working great but since last thursday it is creating weird characters non ascii and don't know why, any idea? Tks

I'm not able to save the view or even run it on a DTS, any idea? Tks

Hello I'm creating a view in which I need to replace values in a field named status from 'M' to 'C', is it possible, how? Tks

Tks Alex, I'm not a programmer, I just made some SQL queries, this file I need is a five field file. Export date; Export time; filename; count; balance. I just need to put the information about 5 other previous created files. Exportation date & time, the name of the file (static field) count...

I don't know how does the standard loggin works, I didn't even know about it. Please give me an idea Alex. Tks

I'm creating 5 txt files with DTS getting info from SQL tables, now I need to create a 6th file (log) validating that the first 5 files are well done, but can't imagine if ther is a way, hope my explanation is ok.

You're the best, I really apreciate your help, this is the second time you save me. you really understand the root of the problem. Tks again

Tks George, you're always there! I've made some corrections: SELECT dbo.INVENTORY_TRANS.PART_ID AS Part_ID, dbo.INVENTORY_TRANS.TRANSACTION_DATE AS Last_trans_date, DATEDIFF(month, dbo.INVENTORY_TRANS.TRANSACTION_DATE, GETDATE()) AS Inactivity, dbo.PART.QTY_ON_HAND...

Hello, I'm not fluent on SQL ANSI, so let me explain, I've the following data and need to get only the newest record of each part_id, my sript is at the end. Part_ID Last_trans_date Inactiv Qty_on_hand 000004014658 2006-05-05 00:00:00.000 14 28.0000 000004014658 2006-06-12...

gmmastros you're the one!

Hello I'm trying to right align a column to export into a text file. It is a numeric amount field and also need just 2 decimals.

Try this: CONVERT(CHAR, RECEIVABLE.INVOICE_DATE, 102) if 102 doesn't worked you can try from 100 to ... and replace the field receivable.invoice_date for your field.

I've a similar problem with clients autocreated printers and solved that installing the printer in the server with the right driver in that way the printer doesn't needs to be autocreated it is always there. But if you have Novell you'll problem is bigger because when some users logged in, a...

I want to warn users when a date passed or is today. Tks