Recent content by bob120579

No, there is no way to get the data at the source, because it was provided to us from an external source. The files are html because they were sent that way as SSRS reports. So just importing them as XML will work? Also, this is just a thought... Instead of parsing, would it work to export...

I have html report files (.html) that i need the actual data that resides in the report to store it in SQL to use as relational data. What is the best way that I can import this data from html into a sql table? I have a whole directory of these files. I just manually exported to excel and the...

How do I compare a field with part of another field? For example I want to know what filenames are included in file path names... If I had a filename (2008file.pst) column in table A and wanted to know if it was included in any records in the path (C:\Folder\2008file.pst) field of table B, how...

SQL Server...The tables that I am pulling from are syscolumns, sysobjects, sysindexes, systypes, sysowners...etc.

I am trying to create a stored procedure based on looking up information in system tables. I am pulling basic information such as Table name, records, field names, field types etc which is the source of data for an SSRS report. This is currently working fine. There is a request to add fields...

32

Are there any considerations or things to set up in SQL Server 2005 when you upgrade the amount of RAM on the server that runs SQL Server? We are upgrading the server from 16 Gigs of RAM to 32. I know if SQL is restarted it should use the maximum amount of memory available in the settings, as...

I actually found the answer...here it is in case anyone is interested.... I just altered the Do...Loop statement to: do while x.AtEndOfStream = False

I have an ActiveX script where I am reading a text file into a variable through an FSO. I have to loop through to check each record's length. The problem is my condition on the loop when i check for end of file. I know when you use a recordset, you can say when the object eof, but i'm not...

Yes, but I understand the mysqlhotcopy does not work well with InnoDB databases and tables, which is what I have set up.

Has anyone ever had a problem with automated backups from MySQL Adinistrator? I set up an automated backup to run every night and it does not execute. I know I needed to store my username and password for the machine before it let me save the Automated backup plan. Is there a setting that I...

Towerbase, The problem is when I try to set up the Automatic backup and schedule it, it says that I need to set up my password in some type of file. But it will let me due a manual backup from there. Ideally, I would like to automate it and schedule it on there, so I do not have to run it...

Anyone have any ideas?????

What needs to be done to create an automated backup in MySQL Administrator? It prompts me and tells me that a file is needed with the password stored.

I have a MySQl database on the backend of an Access front end where multiple users update client information as calls come into the company. All of the data is now linked into Access from linked tables. The problem is the response time when they are adding records. It's not a heavy volume at...