Forum Replies Created
Viewing 15 posts - 36,781 through 36,795 (of 39,944 total)
-
RE: T-SQL or DTS or both?
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
-
RE: Server Hardware Standards
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...
-
RE: MSDE 2000
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
-
RE: services accounts
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...
-
RE: xp_sendmail and SQL 6.5
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...
-
RE: SQL Worm - Are we lazy
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...
-
RE: Backing up a table
If it's ad hoc, DTS. Regularly, use BCP.
Steve Jones
-
RE: SQL Server 2000 SP 3: What's New in Security
Execllent security analysis.
Thanks Brian!
Steve Jones
-
RE: Reaching the Outer Limits
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...
-
RE: Worst Practices - Making a "Live" Change
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...
-
RE: Recover Those Packages!
Sorry for the typo, but glad we got you pointed in the right direction.
Steve Jones
-
RE: How to find and read Binary password
Do you mean the password for a SQL Login? Try MSSQLCrack from NGSSoftware.
Steve Jones
-
RE: Need script to gather db info on multiple servers
Use DTS to run this query on all servers and export to a Excel sheet. Run a separate transform in serial for each server.
Or you could use linked servers and...
Actually I may have an opening in Denver soon.Viewing 15 posts - 36,781 through 36,795 (of 39,944 total)