Viewing 15 posts - 36,751 through 36,765 (of 39,720 total)
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
Good suggestions. I've got a couple more coming in Part 3.
Steve Jones
December 6, 2002 at 9:45 am
December 5, 2002 at 6:40 pm
Might be best to make this a new thread, but in my case. I've had a process go crazy and perform a one time log expansion (GBs) that is far...
December 5, 2002 at 5:06 pm
December 5, 2002 at 11:57 am
I setup an account for anonymous in IIS and use that to connect. If you make the name and pwd the same on the web server and the sql server,...
December 5, 2002 at 11:55 am
Bakup v truncate depends on needs. I'd say backup, but there are cases I don't.
BTW, MS recommendation for production is to NEVER use autoshrink. Run it as needed manually. Or...
December 5, 2002 at 9:50 am
Viewing 15 posts - 36,751 through 36,765 (of 39,720 total)