Viewing 15 posts - 181 through 195 (of 253 total)
Via the gui. The interface did not permit any restore files locations except those on the C drive.
The only thing I can think of is maybe the SQL2000 backup...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 27, 2006 at 9:33 am
That worked. Thanks.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 26, 2006 at 3:45 pm
This is very helpful. Thank you.
I couldn't find this in books online.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
September 21, 2006 at 9:00 am
Thanks a lot! Problem solved.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
April 7, 2006 at 8:58 am
Converting the char values to literals solved the problem.
This is not my code, so I don't know why datetime was used.
Thanks for your help.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 21, 2005 at 4:39 pm
answers:
1. What is the error? Incorrect syntax near 'CHAR'
2. Why are you trying to convert 2005-07-11 00:00:00 to DateTime WHEN you...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 21, 2005 at 1:36 pm
Tim S. Your code did the job. Thanks.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
November 21, 2005 at 10:07 am
Sorry we don't speak the same language.
You can run xp_sendmail from a server connected to a sql database on another server. You need rights to EXECUTE commands from the master...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 13, 2005 at 5:22 pm
<sigh>
Server b only has the SQL server client tools installed...
we are running xp_sendmail on that server. We registered Server a's database
on server b. Both have sp3.
The sql server account has...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 13, 2005 at 3:17 pm
Tried this. Still same error number 18025. Micro$oft has some knowledge base articles about this, but not for my specific problem.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 13, 2005 at 2:18 pm
I did mention that. We could place the views on our network. Another solution is to link our SQL tables to an Access application and let them play in that...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
May 16, 2005 at 10:45 am
Yes. A few spoiled end-users have seen the Query display available in EM. It is similar to Microsoft Access. I wish this display was bundled in QA.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
May 16, 2005 at 10:21 am
This error was caused by an accidental space at the end of the database name. When I backed up the database and restored it without the space, the problem was solved. ...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 27, 2005 at 9:46 pm
Unfortunately, you are correct. After I installed the service pack, the problem went away. Our software does not support that version of SQL2000, but since I don't wish to downgrade...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 9, 2005 at 12:46 pm
I ran Graeme's routine and followed it by a shrinkfile command on the data file. It worked! The routine freed up about 10G. Thanks for all the great advice!
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 1, 2004 at 2:33 pm
Viewing 15 posts - 181 through 195 (of 253 total)