Recent content by Sylvor

Hi everyone, Thanks for the responses, I have been looking into this more and now I'm almost certain one of my client machines has some spyware on it that is sending out this email. I have closed off SMTP outbound from any IP except my exchange box (had to set it on for other POP3/SMTP email)...

Hi xmsre, I'm not so sure this is the whole story - I have been getting a lot of those ...@cia.gov / @fbi.gov messages, but they are simply being deleted as they are obviously junk / virus messages. Am I mis-understanding the messages in my queue in Exchange System Manager? I see messages in...

Hi, I have a huge problem here (doesn't everyone?!) - I think my Exchange Server is being used to relay spam messages. I have been blocked by various spam filters (ie: SpamCop) and am having a nightmare trying to find out the source. In my SMTP message queues I can see lots of messages trying...

Hiya all, I ended up using two formulas, the following: IF {SL_TRANSACTIONS.ST_UNALLOCATED} = 0.0 THEN {SL_TRANSACTIONS.ST_COPYCUST} ELSE "0" And then for the actual field I select the minimum: MINIMUM({SL_TRANSACTIONS.ST_DATE},{@frmOrderRef}) Thanks for your advice and inspiration!! David...

Hiya Synapse, BB, Thanks for replying. Yes I am grouping by "Custno" - I am trying to display the oldest outstanding invoice for each customer. The report allows a user to select multiple custnos, and then displays the date of the oldest outstanding invoice for each custno selected. If I use...

Hi, I have a simple little CR9 report which allows a user to enter customer numbers, the report then produces a list of those accounts and what outstanding invoices are on them. I have a formula field which should show the oldest outstanding invoice. It does not work, it shows the oldest...

Hiya DB, Thanks for the link, I already have the reg key that the final poster suggests, although to be honest I have no idea of the relevence of that key. I also have the DTC service running as I should have, I simply cannot understand the difference between running the query in QA and...

Hi anyone :) I have something interesting (annoying) going on with my trigger on SQL2K, I've noticed several threads on this in the past, but no resolution for the posters. I have a simple insert statement which puts a few fields into a table on a linked server. INSERT OPENQUERY(DBODBC...

Bendall, You cannot view the content of a linked server table from Enterprise Manager, you must run a query either using the four-part name of the server or, as it's linked, use OPENQUERY. EG: SELECT OPENQUERY(linked_server_name, 'SELECT * FROM table_name') I appreciate this post is aeons...

Hi, it's me again, Can anybody give me an example of an insert statement using the rowset_function_limited argument? BOL simply shows the INSERT syntax as... And has this to say about Rowset_function_limited Thanks! David Dave Bennett

Hi James, The database is called Advantage database, by Extended Systems. I haven't specifically tried much yet, I've been playing around but I cannot work out how to an insert INTO the linked database FROM the SQL database, using a pass-through query. If I try to do anything (even a select)...

Hi James, I do have the linked server set up, but due to differences in how the schema rowsets are returned between SQL Server and the linked servers OLE DB Provider, the four-part syntax is not supported. I have no choice but to use OPENQUERY. Any other ideas? Thanks! David Dave Bennett

It may be useful for me to show my trigger code CREATE TRIGGER HN_TRAN_STKMOVE ON STK_MOVEMENTS AFTER INSERT AS IF (SELECT sm_status FROM INSERTED) = 'O' RETURN -- Ignore stock movements out (O) IF (SELECT max(loc_usersort1) FROM stk_location INNER JOIN inserted on inserted.sm_location =...

Hi, I am trying to INSERT some data into a table on a linked server. To do this I am trying to use OPENQUERY / OPENROWSET. I can successfully select data from tables on the linked server, but I cannot get the syntax correct on the insert. (The data to insert resides on the MSSQL server and...

Hi, I have a trigger, which runs on one of my MSSQL tables. It pulls out some data, which I want to then insert into another table; this table is on a separate (Extended Systems) Advantage SQL database. Currently I have the trigger working fine and inserting the data into a local temporary...