Search results for query: *

I have done that when i access the site it shows it is trusted but still fails

IE 5.5

We have just upgraded from Access 97 to 2002. we used to open different databases from our intranet to install on a users computer. However when we open the new format over the web we get the following message: Microsoft Access cannot open this file. This file is located outside your intranet...

Good Morning Guys, Thank you for all your suggestions yesterday in regard to the above matter. I managed to re attach the database yesterday afternoon after finding a process on the internet in a different forum. It is undocumented commands for SQL which allow you to attach a database in...

I have copied the mdf file to a new location on my laptop and tried to reattach from here but it is still looking for the log files. It looks like the locations are embedded within the mdf file. I think it is stale mate.

We have deleted the tranasation logs this is the main problem. We have multiple tranasation logs. When trying to reattach we get the error message: Device activation error. on both drives where the tranastion logs used to be before beig deleted. Is their any other way of restoring from a .mdf...

Thanks MeanGreen, However we have tried this and we get a message saying unable to attach to log files.

To All, We recently created a database with multiple log files to allow for overspill as the transaction log grows. over the weekend we had failures due to the transation logs to large. We detached the database and deleted the transaction logs which we have done in the past. When we have come...

To Anyone, I am curerntly designing a DTS package using SQL7. I need to be able to set a Global Variable using active x script as teh transfermation runs. I know i can do it using VB but do not want to do it this way. Any ideas!

We are currently in the process of rebuilding the server. We have detached the database and also the msdb database and saved teh files in the directory. Once the rebuild is finished we are going toi reattach these systems. With any luck we will have solved the problem. Many thanks for your...

We have reconfigured all the DTS Packages with the new server name. We also this morning created a new server on a bog standard stand alone PC and installed SQL Server 7.0 with the same spec as the new server and carried out the same process and we have recieved no problems on this server. One...

Yes we do!

Thank You for your comments Terry we realised this was not a wise move however we have serious performance issues now and also xp_sendmail does not work. It also takes twice as long to DTS a text file into the database than our old server and the new one is double the spec. Do you think that...

We recently moved are database from one server to another both are running SQL Server 7.0. In order to save time we also detached the msdb database and moved it over to the new server. However we have now found that the xp_sendmail and maintenace are no longer working also DTS packages take...

Am currently writing an application to keep track of connection times and disconnect after an idle period has passed. However when i get a connection it does not bring up the call back screen asking if i want call back. I need this fuctionality so the users are not paying for the calls. Does...

Thanks for the suggestions but this is what i currently do at present and is not really an answer to my question i need to know how to get over having various data type in a table and then trying to bulk copy a text file in to that table!! Regards Leigh

To Ashley, Thanks for the response however the file is stored locally on the server. This is done as a batch file seperatley before the dts process. Their is also no indexes on this table as i only use it as a holding area before i query it to populate the final table. So this is why i was...

Am currently using a DTS package to import various csv files into a MSSQL7 database. However one of these files has 3,900,000 rows and takes 18minutes to run i really would like to speed this process up and have been looking into BULK INSERT. however because the table contains different data...