Search results for query: *

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...

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...

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...

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, 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...

Hi, I have just uploaded a site and when I view the website url, I just get a list of all the files the site is made of, I do not actually see the index page. Why is this? What do I need to change? Thanks, D Dave Bennett

Hi, I have a simple domain in one office and a p2p network in a remote office. The two offices have some hardware creating a VPN between them. We are using TS from the remote office to run a couple of applications on the server at the main office. I have an XP user who needs to print to...

Hi, I want to format some text using a formula, I'm trying to make the text bold under certain conditions. It is easy enough in CR9 - I just go to format field and click on the formula button, then use the crBold function. However, I am trying to do this in CR7 and I do not know how - or even...

Hi, I am having a problem accessing a share on a Windows 2000 Server, which is on an NT domain. The share has permissions set so that "Everyone" has full permission. But I cannot seem to access the share UNLESS the user is set as a Domain Admin. Any ideas what I should check next...

Hi! I am trying to update one field from another, the trouble is the field I want to copy from has multiple values. I want to update the "date last invoiced" field in my customer table from the "invoice date" field in the invoices table. The customer table has one record...

Hi, I have a problem with a 2000 Pro laptop - every OTHER time I open My Computer or Windows Explorer or Control Panel etc. - explorer.exe will crash and restart. I can then open the item fine, once. Then it will crash when I try the second time! (EG: I can open control panel, then the shell...

Hi, I am about to do some work for a client. I visited the site at the weekend and found out that they do not hold a licence for their Win2k server (their only server). They have purchased one which will hopefully arrive tomorrow... I do not want to have to reinstall windows and re-install...

Hi! I have a report which lists (amongst other things) a few codes. I want those codes to be sent to my subreport when called... I have set the field to be sent (unlinked) and then edited the parameter on the subreport to allow multiple values. However, the subreport only ever shows the first...