Search results for query: *

OK SQLDenis, it was a NULL The business wanted the LinkDate of each file recorded even if it was NULL so I had to allow it to be null and the INSERT Clause did not think NULL = NULL whereas the UNIQUE Constraint does see NULL = NULL so I have changed... AND CAST(nd.LinkDate AS DateTime) =...

OK I've tried both Queries and they both try to insert the identical 242 rows. So there is no difference, I'm still getting unique data that translates to data breaking a Unique constraint. Does anyone know a way of debugging it so it tells me which row of data violates the constraint? Klae...

Oh I've noticed a couple of typo with FileVersion fields ignore them. Klae You're only as good as your last answer!

OK so my original snippet is ... INSERT INTO xemFileStore ([FileName], xemProduct_FK, CRC32, FileSize, FileVersion, LinkDate, [Description]) SELECT DISTINCT nd.[FileName], xp.Product_PK, nd.CRC32, nd.FileSize, nd.InternalFileVersion, nd.LinkDate, nd.InternalFileDescription FROM NewData nd...

Thanks SQLSister and SQLDenis, I've got SELECT DISTINCT for the data to be inserted so I think I've accounted for that. I can see I might need to include the snippet of SQL tomorrow (I'm in UK so its not work hours) because without you helpful people seeing it I'm not entirely sure I know what...

Hello I'm pretty up on my MS T-SQL skills but this one is beating me! I have a table with a PK and the rest of the fields are part of a Unique Constraint. When I INSERT data into this table from the flat table (import is not normalized, SQL Job runs procedures to normalize) I have made sure I...

Hello people, I would like to allow internal clients behind BM to succesfully use a VPN connection out to another Network. Let's say the Internal workstation and BM is site A and I want to VPN out to site B. site B can handle NAT being used by other (than BM) firewall/NAT devices/products. From...

Hello, I want to create an add-in which performs a VBA function when the 'database that has my add-in installed' is opened. I want to 'AutoExec' my VBA function but an AutoExec Access Macro in the mda file does not execute and an AutoExec Access Macro in the user's database cannot reference my...

The MACs had there own shared ISDN connection before through a hardware ISDN router. Since the fibre link has been put in it has been requested that these MACs access the internet through the new link. That is all that is to be changed for the MACs. OS X and everything else is as it was. If...

One of our glorious project managers decided to proceed with a project of moving our inhouse printing services to our main optic fibre network. He did this by only involving our COMMS team who know nothing past the IP stack. we have 5 MACs running OS X which now, on the new network cannot logon...

How did you set the Terminal Services profile? Did you enter it in as a UNC? e.g. "\\FileServer\HomeShare\ProfileFolder". In the "profileFolder" have you put a profile consisting of all the folders and the ntuser.dat (or ntuser.man) file at the root of...

We had to give in, in the end and give our two users local profiles and not roaming ones and disabled Dynamic Local User and had to tell the users that no one else can log into their PCs and they will not be able to roam around the office. the digital certificates work fine on their local...

We have Bordermanager as our corporate proxy and cookie handling is a bit erratic. Any website that extensively uses cookies and session-cookies do not work properly. Insurance sites and other secure sites return "cookie expired for no use in 30 minutes" when you are using the website...

Thanks for replying, They are both in the domain 'BFBC'. The only thing on the Novell KnowledgeBase is that you can select which post office to return in NWadmin95 and to change it it can only be done in NWadmin95 not NWAdmin32 or ConsoleOne apparently the button is only in NWadmin95! Novell...

Hi, We have two post offices on our Groupwise system. (BFBC_PO1 and BFBC_PO2) I have setup access to the address book via LDAP but it is only picking up addresses from BFBC_PO2. how do I get LDAP to return all the addresses from both Post Offices? Klae You're only as good as your last answer!

Hi, We have a Netware 5.1 network and we have some users in our education department (we are a borough council) who needs to use digital certificates through IE5.5. With Novell DLU and Workstation manager the digital certificate becomes corrupt and unuseable. Every one of our users cannot use...

Hi, We have a Netware 5.1 network and we have some users in our education department (we are a borough council) who needs to use digital certificates through IE5.5. With Novell DLU and Workstation manager the digital certificate becomes corrupt and unuseable. Every one of our users cannot use...

Thanks for that Swi. I remembered the DOS command NET USER and used that a day or so ago now, you know when you have something to code and you just go off on one thinking it's really hard to do and you are trying to do it a really hard way when there is a so simple way that you are completely...

Hi Guys, I was wondering what the code involved was for adding and deleting NT users from the local Machine User manager. Any help appreciated thanks. Klae You're only as good as your last answer!

what's tomcat or resin? www.tomcat.com (porn site!) www.resin.com? DNS resolution failed. Klae You're only as good as your last answer!