Viewing 15 posts - 36,796 through 36,810 (of 39,771 total)
Does this happen from multiple workstations? Try to narrow this down between the workstation and server.
If it's the server, if you can, detach dbs, uninstall, reinstall, then attach dbs.
If...
December 10, 2002 at 10:04 am
I actually mentioned this on a PSS call and they mentioned it has something to do with the SQL Server being unable to validate your credentials with a domain controller.
We...
December 10, 2002 at 9:54 am
Very interesting. Course, be sure you protect the backup files as well. Especially when they are on tape.
For laptops, we use Pointsec (www.pointsec.com) here at JD Edwards. Help Desk has...
December 9, 2002 at 3:22 pm
That will work as well. Thanks for the script.
Steve Jones
December 9, 2002 at 1:37 pm
The VB program should be running under the context of the user who executes it. This is the account that needs to execute DTS and log into SQL Server, and...
December 9, 2002 at 1:35 pm
December 9, 2002 at 1:30 pm
bcp is your best bet then.
Steve Jones
December 9, 2002 at 11:01 am
I have both, not sure which is better. Good and bad, only using XP for about 6 months.
For SQL developemnt, not sure it matters. The interface is the same and...
December 9, 2002 at 10:15 am
You have to drop and recreate the table. You can make a new table, move the data, and then rename it (after dropping the old table). This is what will...
December 9, 2002 at 10:10 am
I think you can use WinZip after you detach the file and span this across disks.
This is, I assume, for transferring this db to a client or somewhere else. If...
December 9, 2002 at 10:06 am
You cannot "recompile" a table. You drop it and recreate it. You can alter it.
Can you post the code you are trying to run?
Steve Jones
December 9, 2002 at 10:00 am
Is it every time you reboot? So if you shrink and then reboot, does it immediately grow?
You might also try detaching the db, then reattaching with no log. Do a...
December 9, 2002 at 9:57 am
That's a good idea. Not sure how much participation we would get, but perhaps worth implementing.
We're upgrading the forums, so it would probably be after that, but we'll look at...
December 9, 2002 at 9:53 am
Agree with that. That being said, be nice to get some recommendations on other sites to visit for other things.
Steve Jones
December 9, 2002 at 9:33 am
You can easily call a DTS pacakge from VB6. In fact, you can save out the DTS pacakge in VB format, then add it in as a separate project or...
December 6, 2002 at 9:54 am
Viewing 15 posts - 36,796 through 36,810 (of 39,771 total)