Forum Replies Created
Viewing 15 posts - 37,381 through 37,395 (of 39,720 total)
-
RE: Adding a processor to an existing installation
Windows will not detect the processor until you upgrade the kernel to do so. This is not a trivial task and you need to be sure you have a good...
-
RE: SQL POP Quiz
My vote is for crappy programming!
Must have been a developer, not a DBA
Steve Jones
-
RE: read-only tables
Check the triggers.
Not sure you can mark a table read only. I think you can a filegroup. Or a database
Steve Jones
-
RE: Using UPDATE ?
You are welcome. Keep coming back.
Steve Jones
-
RE: Query Analyzer not working
Can you manually type in the name\instance?
Steve Jones
-
RE: SQL 65 Device Resize
not in v6.5. Need to bcp out, recreate, bcp in.
Steve Jones
-
RE: job hunting
It will depend on you, where you are, and the company.
My experience is that companies ask for the ideal, but rarely get it. Probably changing in this economy with lots...
-
RE: I need opinions from you on which db to choose...
SQL Server will be windows license + $5k per processor to run on the Internet. Unless you have all authenticated users, then you can use CALs, but that probably won't...
-
RE: Cleaning up duplicates
Sounds like a few scripts:
For phones,
select phone, count(*)
from vendor
group by phone
having count(*) > 1
Steve Jones
-
RE: Sa password missing
If you can connect with NT, you can snag the passwords and get them. See the "cracking thread" in this forum.
Steve Jones
-
RE: data encryption
Just a note here. If you don't encrypt at the client, then the DBA can snag it with Profiler anyway. Sort of defeats the purpose.
Steve Jones
-
RE: inactive processes
No way I know of. I wrote a script that would check the last batch time and use exec() to kill the spid.
Steve Jones
-
RE: Check for Zip file to process DTS job
The FileSystemObject has a "fileexists" property you can check.
Steve Jones
-
RE: Cracking
And typical. People laugh at me, but I never leave a consultant alone. Some junior admins have gotten annoyed because I've had them babysit someone while I had to do...
-
RE: Perplexing User-Defined Scalar Function Problem
That's possible. Apologies, but I'm not an Access person. Hopefully Andy or someone else will chime in.
Steve Jones
Viewing 15 posts - 37,381 through 37,395 (of 39,720 total)