Viewing 15 posts - 37,216 through 37,230 (of 39,818 total)
2nd vote for Brian's explanation.
Steve Jones
August 28, 2002 at 10:35 am
sometimes logs don't shrink well. There's a script in our library to help do that.
Steve Jones
August 28, 2002 at 10:30 am
You can also script your own sp_password that would run after 35 or so days to lock out users.
Steve Jones
August 28, 2002 at 10:28 am
This is the reason you DO NOT go into the system tables. They change from version to version.
Better to use the sp_helpsort and parse the string. It will work...
August 28, 2002 at 10:25 am
I think this varies so widely that it's tough to have a good checklist that you're not skipping items. A good idea, just not sure it's something that works well.
Things...
August 28, 2002 at 10:22 am
Not sure this makes sense. You get a restore error while the backup is running? If the backup is running, you will not be able to restore the system. Or...
August 28, 2002 at 10:19 am
Agree with Antares. Query should have done something, but what happened.
Are you sure the query was correct? There was data to return. Perhaps you check the "check query" button and...
August 28, 2002 at 10:12 am
Can't use a text datatype as an output parameter. Return it as a result set.
Steve Jones
August 27, 2002 at 10:45 am
There are threads. Two differnt philosphies.
1. Build dynamic sql statement and execute it.
2. Prebuild stored procs for each combination. Call these from one central proc based on parameters passed in.
Steve...
August 27, 2002 at 10:00 am
I read a bunch of Mr. Celko's posts in Usenet when I was getting started and learned a lot.
However, as mentioned above. I like the punch card formatting for #1....
August 27, 2002 at 9:02 am
Change the password often. Develop a plan to avoid having this be cumbersome.
Profile and audit your server. If you catch people, deal with it administratively.
This is a reason why shared...
August 27, 2002 at 8:53 am
Save it as a text file, or perhaps grab it using the MS HTTP control in DTS.
Interesting idea, though.
Steve Jones
August 26, 2002 at 10:04 am
Why change these? Are they instances?
Steve Jones
August 26, 2002 at 9:28 am
Viewing 15 posts - 37,216 through 37,230 (of 39,818 total)