Viewing 15 posts - 38,446 through 38,460 (of 39,720 total)
Shouldn't be any different. Still need to add a reference to the COM component for DTS or DMO.
Steve Jones
January 28, 2002 at 1:20 pm
Common Language Runtime. This is the platofrm on which the compiled applications (in C#, c++, VB, Perl, etc) run. This is an abstraction from Win32 so it can be written...
January 28, 2002 at 12:33 pm
I agree with your points. I'd consider encyption for non-key fields, like salary. However, I'd want to place the key management in someone else's hands. After all if I hold...
January 28, 2002 at 12:32 pm
January 28, 2002 at 12:30 pm
Rather than the machine name, rigorously enforce user names that are unique to each user and apss this in.
Steve Jones
January 28, 2002 at 12:28 pm
I agree with Brian, but you need a couple boxes to test the failover and then how you fail back. Keep in mind that replication will fail once the primary...
January 28, 2002 at 10:53 am
I think the IDEA of .NET is great. However, I am skeptical of the security and programming of the MS people as THE END ALL tool. They have a poor...
January 28, 2002 at 10:52 am
Interesting article. I like your point of view and tend to agree. The DBA is often responsible for the data as well as the system, and that is not the...
January 28, 2002 at 10:48 am
Haven't really worked with multiple instances, but I'd be inclined to let SQL manage memory.
Unless you ahve a good reason not to.
Steve Jones
January 28, 2002 at 10:46 am
Just my 2 cents.
I hate NULLs. I do allow them in places, but mostly for backwards compatibility. My personal feeling is that a value should always be known. Knowing it...
January 28, 2002 at 10:45 am
If there is caching, it is your app doing something funky within iteself or in ADO.
I've written a number of apps and this does not happen. When SQL Server caches...
January 28, 2002 at 10:41 am
I like to reduce Round Trips. Andy Warren has a few articles on this subject. I'd make one sp with 40 parameters. Not that the network overhead is big, but...
January 28, 2002 at 10:38 am
I agree with Brian. Give us your thoughts and we'll point you in the right direction, but we should not be answering questions for you about the test.
Steve Jones
January 28, 2002 at 10:36 am
I'd do a replace after the BCP. Look for "," and replace it with ,.
This is the simplest way.
Steve Jones
January 28, 2002 at 10:35 am
How is the server configured to startup? I think I ran into this when the server was running under local system, or perhaps a non-administrative account.
Try setting the server to...
January 28, 2002 at 10:33 am
Viewing 15 posts - 38,446 through 38,460 (of 39,720 total)