Recent content by abacaxi

Working with SQL Server 7.0: I have a DTS package that works when executed manually. However, when I schedule it, the package fails right away. Are there any known issues regarding this situation? Any ideas on what I can look at to fix this problem? Thank you, Todd

To all: Thanks for your suggestions! Todd

Good point SQLBill...I just copied and pasted! It sounds like I should detach first? If I run a detach, does it leave a copy on the source server or does it completely detach it?

Terry, Thanks for your feedback. The .mdf file I want to attach is from the same version...7.0 I tried using the sp_attach_single_file_db (obviously modifying the args that are specific to this sp) but I get the same error. Todd

In EM on the DB Server name, what does the red squiggly line mean?? I always see it but my DB Server is running fine!

Hello All: I posted a thread last week about this but just recently tried it. I am on SQL Server 7.0 and need to attach a .mdb file. SQL Server 2000 is nice because it has a GUI option of attaching but not 7.0 So this is the procedure I used while logged in as 'sa' in MASTER: EXEC...

hmmmm...very weird. I don't find the 'Attach' option anywhere, not even in the place you suggested! This is 7.0 with no service packs installed...I wonder if that makes a diff? T

LFCfan, When in EM, I right click on Database and I do not ses it! Todd

Hey LFCfan, Thanks for the quick response and suggestion. I'll give it a try right away! Thanks, Todd

Hello, I have SQL Server 7.0 and I am taking several .mdf files from one SQL Server to another. On the destination server, how can I open incororate these into a database? Can I directly insert them into the Data folder under the MSSQL folder? Or do I have to convert it to some kind of .csv...

Hi, I have years of experience with Active Server Pages(VBScript), COM and some limited C++. I'm beginning to venture into into the Java world. I guess my question for today is: If I have a live Apache web server on Linux, do I need to have any thing on Linnux in order to run the .jsp files...