Viewing 15 posts - 36,556 through 36,570 (of 39,720 total)
I follow something similar and Antares has great advice.
We exclude the mdf, ldf, AND ndf files. We then run backups (full and diff) to the local disk. These are backed...
January 31, 2003 at 9:42 am
Use DTS. I'd load into a staging table and then use T-SQL to do the work, but call it from DTS.
Steve Jones
January 30, 2003 at 3:05 pm
January 30, 2003 at 9:56 am
Thanks for the complement.
Actually I may have an opening in Denver soon.
New equipment is tough. One thing I've really become annoyed at with Compaq/HP is the...
January 30, 2003 at 9:39 am
Also, in the registry (classes_root|Installer) will be the product Ids, under each of these is the product name. You will see SQL Server Desktop Engine listed there.
Steve Jones
January 29, 2003 at 3:21 pm
The SQL Service logs into the NT Domain (or machine) like any other user. Local system is a special account on all Windows servers. It can only access resources on...
January 29, 2003 at 3:19 pm
Not sure and it's been awhile since I worked with 65. Usually this is some name resolution issue. Have you tried logging in as the SQL Service account and sending...
January 29, 2003 at 3:16 pm
My first reaction is yes, you are lazy if you got hit. This patch has been out for some time, and there isn't a good excuse for not patching your...
January 29, 2003 at 2:29 pm
If it's ad hoc, DTS. Regularly, use BCP.
Steve Jones
January 28, 2003 at 6:06 pm
January 28, 2003 at 12:50 pm
Execllent security analysis.
Thanks Brian!
Steve Jones
January 27, 2003 at 11:50 am
Interesting. Haven't used the timestamp column since some Visual Fox work 6 years ago, but that was how Fox determined if you could update the RS as well. Hope the...
January 27, 2003 at 11:41 am
Great comments and thanks. This is one of those areas that I preach, though still can't always control. Unless you have complete control of the server, no one else makes...
January 27, 2003 at 11:39 am
Sorry for the typo, but glad we got you pointed in the right direction.
Steve Jones
January 27, 2003 at 11:34 am
Do you mean the password for a SQL Login? Try MSSQLCrack from NGSSoftware.
Steve Jones
January 27, 2003 at 11:31 am
Viewing 15 posts - 36,556 through 36,570 (of 39,720 total)