Viewing 15 posts - 36,841 through 36,855 (of 39,818 total)
In production, avoided. Though in my world, with dozens of servers, we have to let some people manage their db while we manage the server.
In dev, I try to avoid...
December 10, 2002 at 10:20 am
I've got a review coming out next week or the following.
I spoke with the Litespeed people at PASS and they mentioned that they had worked with MS and taken advantage...
December 10, 2002 at 10:10 am
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
Viewing 15 posts - 36,841 through 36,855 (of 39,818 total)