Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SQLWilts

  1. SQLWilts

    ADO Connection failed to create object

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

    ADO connection failed to create object

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

    Renaming files in a batch process

    smah, Thanks for your reply. After some thought (and a walk away for a while) I imitated a "Do/While" loop like this: REM get count of files FOR /F %%j in ('dir *.xml.* /A-D-H /B ^| find /C /V ""') DO SET COUNTER=%%j REM Loop until the count = 0 :loopstart REN mycompany-name.xml.%COUNTER%...
  4. SQLWilts

    Renaming files in a batch process

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

    Paramaterised SP returns same results, no matter what parm is used

    It appears to be the way nulls are being handled. I am calling the proc as call myprocname parm1, null, null, null returns 8 rows call myprocname parm1, null, null, 208 returns 4 rows call myprocname parm1, null, null, null returns the same 4 rows as above, but if I use call myprocname...
  6. SQLWilts

    Paramaterised SP returns same results, no matter what parm is used

    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`(...
  7. SQLWilts

    2005 Memory question

    You can use AWE/PAE settings, but on a 4GB machine, it isn't really practical. AWE/PAE allows you to use a lot more of the memory, even on a 32 bit machine. Memory constraints are no longer an issue in SQL 2005 - check out here...
  8. SQLWilts

    SQL server 2000 64 bit on Itanium MySQL linked server

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

    Permission's needed to Migrate Access

    Yup, I agree totally with Riverguy. You will need SA authority over the server in order to be able to do what you need. Sounds like you upsize to a local copy of SQL Developer (about £40) and then pass the upsized DBs to your corporate data security guy. He would then take over the role of DBA
  10. SQLWilts

    Clustered index on a small work file.

    If you are only loading that number of records, then you can do an index rebuild straight after the populate. A clustered index is the physical order of the table, so if you rebuilt that after re-loading the table, then you would be re-loading it. Make sure your statistics are kept up to date...
  11. SQLWilts

    Setting Limits on Memory for SQL Express

    FYI SQL Express only uses 1GB of memory anyway - personally I wouldn't restrict it down any further than that...
  12. SQLWilts

    backup transaction log with users logged on

    Erm, why, may I ask, are you trying to truncate the transaction log? This is only for emergencies and should be avoided if at all possible! If you are using 2005, alter the DB to simple mode - the trans log will commit safely and truncate for you - you won't lose data that way either
  13. SQLWilts

    Cannot resolve collation conflict for equal to operation

    George, I think that you have hit the nail on the head in your bit about: (select max(backup_finish_date) from msdb..backupset where type = 'D' and database_name = dtb.name) AS [LastBackupDate], As you intimated, it appears that it was built by an apprentice in his first year! In fact mate -...
  14. SQLWilts

    Cannot resolve collation conflict for equal to operation

    It appears to be the MSDB database. It is the only DB that has a different collation to the rest. Only way that I know of to change the MSDB collation is - rebuildm! And we can't do that on this live system I'm confused, though, why this happens when we look at any database property in SSMS...
  15. SQLWilts

    Cannot resolve collation conflict for equal to operation

    Thanks for that George - very useful info. I have worked with different colations before, and have even walked through that very dark valley of changing the collation of a database mid way through its life, so I know about the varying levels. My confusion though is why I can right click on a...
See more

Part and Inventory Search

Back
Top