Recent content by SQLWilts

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

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

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

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

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

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

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

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

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

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

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

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

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

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