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
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.