Viewing 15 posts - 36,286 through 36,300 (of 39,771 total)
search sp_help_revlogin on technet. use this to script out the logins. Then change pwds and if you want, delete 1 a week after trying to find where they are used....
June 4, 2003 at 9:25 am
Excellent list of lessons learned that everyone should follow. Whether you are a PM or a developer. My wife follows these as a consultant, often having PMs that don't, and...
June 4, 2003 at 9:22 am
they have a low end version that just reads for around US$400. The higher end version will undo transactions by generating a script to undo the action.
I thought lockwood was...
June 3, 2003 at 3:52 pm
strange. sounds like a bug somewhere. Is this ss2k? service pack?
Steve Jones
June 3, 2003 at 3:50 pm
space maybe? Only local disks should show up. What does xp_fixeddrives return?
You can also just type the path.
Steve Jones
June 3, 2003 at 3:49 pm
First, I would care about the log file. It's easy to throw away if you don't need it, but if younever capture it, you may be asking for trboule.
second, if...
June 3, 2003 at 3:48 pm
If I were interested and I read the post, I'd be turned off. It sounds like they want everything and don't want to give anything. The explanation given later is...
June 3, 2003 at 3:43 pm
create trigger mytrig on tableA for update, delete as
insert mytable
select id, name, etc
from deleted
Steve Jones
June 3, 2003 at 3:37 pm
June 3, 2003 at 3:34 pm
Not that I'm aware of. Could do a select at some point and step through that.
Steve Jones
June 3, 2003 at 9:42 am
Sounds like this will get completely cumbersome to manage. What about storing groups with their items and then "linking" to users? Maybe even have an "owner" flag in the link...
June 3, 2003 at 9:41 am
Why is the same named object required in modern dbs?
Steve Jones
June 3, 2003 at 9:37 am
has anything changed on your workstation?
Steve Jones
June 3, 2003 at 9:35 am
June 3, 2003 at 9:35 am
If you don't have an area of expertise or experience, like data warehousing, passing that exam is of limited benefit. You look like a "book" person. I'd pick the exam...
June 3, 2003 at 9:33 am
Viewing 15 posts - 36,286 through 36,300 (of 39,771 total)