Viewing 15 posts - 4,816 through 4,830 (of 6,216 total)
In the db itself, or from the log file? Log Explorer by Lumigent might help. If you've deleted it and the log has been truncated I think you are out...
March 4, 2002 at 5:02 pm
I'll definitely be considering the separate db idea. The sound file might be associated with any one of my 200+ db's, but I can tag the row in the sound...
March 4, 2002 at 4:49 pm
Not sure what you're asking. If you run the distribution agent before the snapshot is complete nothing will happen. After that you can run it as little or as often...
March 4, 2002 at 4:43 pm
Dont know that I would consider lines of code as my basis, rather the "elegance" of the solution. Guess it also depends on what you call easy to maintain -...
March 4, 2002 at 8:16 am
Interesting article. Not sure I agree with you that static SQL is easier to maintain than dynamic. In my experience dynamic is usually called for mainly by search forms which...
March 4, 2002 at 7:30 am
I know we don't use NT authentication for any of our stuff on the web, its all SQL login driven. NT is viable if you're just on the intranet, but...
March 4, 2002 at 7:16 am
Hey Dan,
You can ping the IP address from the client, correct? Have you tried connecting via Query Analyzer on the client? DSN's use ODBC, QA does also. There's no magic...
March 3, 2002 at 10:38 am
More secure...maybe not. Easier to manage, maybe. Allow me to ramble. Application allows users to record phone conversations (with the permission of the other person of course) which gets written...
March 2, 2002 at 9:07 pm
Wasnt sure, had to go check - Access2K supports row level locking. For those of you who don't use Access very often you might want to take a look at...
March 2, 2002 at 8:51 pm
Access is reasonably secure - even has an option to encrypt the mdb. I agree that MSDE gives you a better/easier upgrade path to SQL than Access does. Page locking...
March 2, 2002 at 8:46 pm
Yes, you can make a pretty good living in the database business. Couldnt say for which is most popular, most of us visiting this site obviously use SQL Server and...
March 2, 2002 at 5:42 am
Kowabunga!
I know Im the only one who likes blobs. Nothing to stop you from using NT security in the db. Another advantage is you can full text index. We're looking...
March 1, 2002 at 6:05 pm
Might also look at partitioning the data, putting some elsewhere. If you've got a large qty of data not likely to be used, split it out and load it on...
March 1, 2002 at 6:02 pm
Yes. One setting is never going to fit all circumstances.
Andy
March 1, 2002 at 2:21 pm
Possibly. Besides, if MS does implement their plan of using a variant of MSDE for the file system, it WILL be in the db anyway!
Andy
March 1, 2002 at 2:10 pm
Viewing 15 posts - 4,816 through 4,830 (of 6,216 total)