Forum Replies Created
Viewing 15 posts - 36,301 through 36,315 (of 39,810 total)
-
RE: Profiler and privacy
Your company should have some policy spelled out, probably for email, that all activities may be monitored, blah, blah, blah. I suspec that this would cover profiler.
Of course, IANAL.
Steve Jones
-
RE: Obtaining total capacity for disk drive in T-SQL
srvinfo gets a bunch of stuff, but takes some parsing.
Steve Jones
-
RE: Best Practices for Reboot Schedule
As an aside, if you've run on SS2K/ W2K for a year, you are missing some valuable security patches. Not that you have to apply them, look at your...
-
RE: Moving my post
Thanks, I'll try. It's one of those things that I wish I'd take the 2 days and do it since I see things I need to move fairly often.
-
RE: HTML Email
Honestly part of the reason is also that this is a community. We hope that you visit the site more, not just read things through email.
Steve Jones
-
RE: Problem Inserting with Multiple Joins
If you run the select without the insert does it return any rows? that's likely where your issue lies.
Steve Jones
-
RE: SQL MAIL - PROBLEMS
.\ is the local machine, so it is using an account on that machine as opposed to the domain.
Steve Jones
-
RE: isql -S error
-
RE: Installation problems on W2K
It can't find the server. Is it started?
Steve Jones
-
RE: Installation problems on W2K
It can't find the server. Is it started?
Steve Jones
-
RE: shrinking database
It's fairly well protected. If you exceed the max, it won't shrink that far.
Steve Jones
-
RE: paging - showing 10 records at a time, etc.
Use some key, order by the key, select the top XX where you are > last key.
Steve Jones
-
RE: SMP
Not sure you need to change anything. Was this a same server upgrade? AFAIK if Windows sees 2 CPUs, then SQL will.
Steve Jones
-
RE: Best Practices for Reboot Schedule
I used to reboot quarterly, apply patches, etc at that time.
However with W2K, it's not that much of an issue. We have been getting enough reboots lately with the patches...
-
RE: Moving my post
Not easy to do in this version of Snitz, but something that we've taken note of.
Steve Jones
Viewing 15 posts - 36,301 through 36,315 (of 39,810 total)