Viewing 15 posts - 36,856 through 36,870 (of 39,818 total)
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
Never seen this one. What version of server, how much RAM? How big is the db?
Steve Jones
December 5, 2002 at 9:26 am
I've often had semi stable code with new products being released and the collisions between the production server and demo server weren't worth it.
Having a decent demo server has always...
December 5, 2002 at 9:22 am
Nice article and good points.
In most businesses, IT does support the business. Exceptions occur, like my company, JD Edwards, where we build software. In this case, part of IT is...
December 3, 2002 at 4:01 pm
LogExplorer could grab this if you know when the db was created and have the tlog from that date.
Or go back to a backup from that date
Steve Jones
December 3, 2002 at 3:57 pm
You could load it up.
Alternatively, enclose all table and field names in [], which will allow you to use reserved words.
Steve Jones
December 3, 2002 at 3:57 pm
do you mean without headers? You can use DTS to grab data out.
Steve Jones
December 3, 2002 at 3:56 pm
Check rights as well. Might be an NT rights issue.
Steve Jones
December 3, 2002 at 3:55 pm
Viewing 15 posts - 36,856 through 36,870 (of 39,818 total)