Search results for query: *

Sorry to post this here as well as in the NT4 forum, but I was wondering if someone here has experienced similar. I have an NT4 box that is using UDL and ADO to connect to an SQL server.All works well in the staging environment - which is (I thought) identical to production (although obviously...

Hi, I have an NT4 box that is using UDL and ADO to connect to an SQL server. All works well in the staging environment - which is (I thought) identical to production. However, Production gives the "429 ActiveX component can't create object" - and I'm stumped. The MDAC reports as the same on both...

Has anyone done this... I am just kicking ideas around and any input would be appreciated: I have a number of files that are produced by a batch process every night. There will be > 15 of them, but I do not know exactly how many there will be. Their names are like: mycomapny-name.xml.1...

Hi, I have MySQL 5 running on a windows box. I have a weird caching scenario going on here, which I am convinced is the client - but any help pointers would be appreciated. I have a SP which does a simple select according to parms CREATE PROCEDURE adcentre.`search_classifiedListings`(...

Has anyone tried to do the above? I have a windows 2003 64 bit Itanium box running SQL Server 2000 SP4. I need to create a linked server (for reporting services reasons) to a windows 2003 32 bit Intel box. I have downloaded the MSDASQL 64 bit installer - I can now choose the OLE DB Provider...

Hi, Odd one here: We have a number of SQL 2000 instances which we use SSMS to manage. Normally there are no problems, but on this occassion we have hit an odd problem. When we right click on any (system or user) database we get the "Cannot resolve collation conflict for equal to operation"...

Hi, It appears that if my PC starts running low on memory, it just stops doing anything "additional". For example, this morning I found that when I right clicked/open new window in IE6, it just wouldn't! then, after a while, it just refused point blank to display a right click window. Next, when...

Hi, I am trying to get analysis services manager working from a virtual machine. This VM works fine and can see the whole network. The problems is that the VM needs to be able to see a certain registry key. I can not see the HKLM\software\microsoft\OLAP Server reg key from the VM, although I am...

Hi, I have been trying to connect via a VM on my pc to analysis services 2000 on a server. I have analysis services installed on the PC and up to the same service pack level. Whenever I try to connect using AS manager, I get the message that the network registry is not available yah de yah, so I...

Hi, I have been working with SQL server for about 12 years now, but have never really kicked around trace flags - which I suspect this issue is associated with. I have a number of very busy SQL servers but the only thing in the error log is the backup info (log and DB). I want to see all SQL...

Hi, I'm new to MySQL and am going round in circles here! I restored a DB from a dump and then founf that the developers login could see the database but not the tables. I have run grant all and followed it up with a flush privileges, but to no avail - they can still log in, see the database, but...

Hi, I have torn down replication and am now rebuilding it on one of our servers. I am getting a "cannot allocate enough disk space" error when trying to create the distribution DB. I have created a DB via management studio and EM - no probs. I open a new query and run a create database script...

Hi, I have created a number of custom toolbars using macros (keystrokes, not mouse clicks :)) and they work fine. I am now looking at passing the laptop building process to our helpdesk. The macros go across no trouble, but where are the icons held? Are they in the username.ini? Otherwise, the...

Hi guys, I am not getting an answer from the people who are supposed to give us support, so I thought I would ask here. I am trying to create a setup system for our helpdesk so that they can build (and rebuild) a number of Goldmine undocked laptops - with a lot of customisation. For some...

OK, I'm sure it has been asked before, but I can't find the answer. Our developers do not have the ability to restore disk backups to the development server. This is intended behaviour, and a form of data security (the data has to be "depersonalised" before they can work on it). And I know that...

Hi, I have a number of users for whom I want to tie Goldmine down to a very few activities. I am doing this via a custom toolbar. Most things I can do by recording macros, but I have hit a small problemette. I want to add a number of commands on this toolbar which will dive straight into certain...

Hi, I have an issue where a number of reports dont work when you press the back or forward button on your browser. I have found that it is because the browser thinks that it is in the internet zone. I cannot add the server as a trusted site, as our system is tied down. A way round it is to add...

Hi, I am a newbie at AS, so please bear with me. I am not sure whether this should be in the AS section, or here - but as the AS side looks OK, here, I am. I am in the process of converting DTS 2000 to SSIS 2005. I have exported/imported the OLAP cubes to a seperate server - no problems. I can...

OK, so I am embarrassed to ask this... I have a number of jobs that run DBCC commands against all databases on an instance. Problem is that the command is failing somewhere (it is doing a checkdb against all tables/dbs) - and I don't know where - as in which table in which db is failing. The...

Hi, My experience is all SQL server, so please excuse my complete ignorance. I have "adapted" a SQL Server query to delete duplicates from a table. I have had to use a temp table as I find that I cannot use a self join (I can't read from the same table I am trying to delete from). Anyway, I am...