Search results for query: *

I copied the db local(non networked machine) zipped it up, put it on a stick, copied it to the network production box, unzipped it and then tried to attach. I appreciate your help!!

It gives me the redx saying that the ldf does not exist and I get the following error. Could not open new database axdb_30. create database is aborted. Device activation error. The physical file name d:\xxx\axdb_30_log.ldf may be incorrect.

It would not let me copy the db while sql service was up and running. So I stopped services then copied.

I deleted any instance of the log file off of the server. When I right click on database/attach, and point it to my mdf it pulls the log file from the same location. If I clear the path the okay button goes grey. I don't see a way to remove it ldf file from attach function?

When I do the attach it pulls the ldf in by default if I uncheck it(puts a redx in) I get the following error. Defice activation error, the physical name(log file name) may be incorrect. Is there another way to attach outside of the right click attach db method?

I am new to this so please excuse the ignorance. I have an sql db on a standalone server that is not on our network. I copied the mdf & ldf and copied them onto a stick and put them on the network production sql box. I tried to do an attach database and received the following error error...

What would my table look like. Would it look like this? Would you have an small example as to how I would populate the grid. Time Segment 08:00 1 08:15 2 Again, I appreciate any help!!!

I have a query that prioritized and determines actual hh:mm:ss each job takes. For example pri job time 1 abc 04:20:00 2 bca 01:10:00 I want to be able to popluate this data into a grid or calendar control based on a start time of 08:00am in 5 minute increments. Here...

Thanks that works great

I am running cr9.2 and am having difficulty with multiple paramter selection criteria The goal is to have the user have the ability to choose any combination (Both all/none all/1 all 1 value) {QryRep.ReqDate} in {?StartDate} to {?EndDate} and IF {?Cellname} <> "All" then {QryRep.Cellname} =...

That is it ibass. Perfect. Thanks

Whouldn't I need to change the backround color of the text box and not the font. There is nothing in the text box. With Webdings I have used the = to give me a circle but I do not know how to change the font. If I use a text box I need to be able to create a formula to change the backround...

I am attempting to create a corporate dashboard with metrics and a red/yellow/green circle next to the metric depending on the value. Is there a way to format a circle(Formated square) to do this. I had thought about the webdings but can't figure out how to change the font color for the...

I need help with the correct syntax. Mr. Greer was nice enough to point me in this direction. I am pulling data from my mainframe and can actually save in .ps format. I just need assistance on how to handle multiple lines of data. This is what I have in the .ps file %!PS /Courier 12...

I guess I am missing the correct .ps format. Can I take the text file, add some code, save it as a .ps file then run it through the distiller? I am trying to grab straight text from a mainframe (FTP'd to the in (Watch directory) and convert into pdf. Is there some simple code to put in the...

Hello all, I am trying to use distiller for the first time. I have created a watch dir and am trying to process a file. The file is a.txt and only has the word test in it. When I process the file I get the following errors. Start Time: Friday, July 22, 2005 at 2:39 PM Source: a.txt Destination...

I have DTS importing a couple of excel files into SQL for which I have linked in a view, I then take the view and dump it into excel which works great. The last step I take the excel file and e-mail it out. I get the following error, error sending mail: MAPI error: Could not open the attached...

Is there a way of doing this in DTS. I want to merge 2 text files that are tab delimited and using 2 fields(Sales order & line) as the link between the files. After the merge I want to save in excel format and then send it out in an e-mail. (I have the e-mail figured out). Any help would be...

Is there a property that will allow me pass the logon & password to connect to the SQL database in the below asp code. I am having to login to get the page to load when connecting to an sql database. When I use access and use a trusted connection I do not have the problem. I have tried the ole...

I have an iis5 server that is running great and connecting to both sql & access dbs, so I do not think it has anything to do with sp3, that is unless iis6 is looking for something on sql that iis 5 does not need. I have the access db's stored locally on the iis server and the big databases I...