Viewing 15 posts - 36,856 through 36,870 (of 39,771 total)
Can they just take a differential backup? Replication will work, but that may be overkill.
If it's a few tables, you could just create an audit table and use triggers, then...
November 26, 2002 at 1:22 pm
What does the insert trigger do? Does it update the table? Might cause a 2nd trigger to fire there.
Steve Jones
November 25, 2002 at 2:54 pm
No. I asked this question of MS last year for the same reasons. You must license each proc.
Licensing is per physical CPU, however, not logical. The new hyperthreading CPUs appears...
November 25, 2002 at 10:29 am
select * is built at view compile time. You should really specify the columns so you know to add them to the view (with Alter View).
Steve Jones
November 25, 2002 at 10:06 am
November 25, 2002 at 9:45 am
In sysindexes, a row will be added for the table with indid > 0. A 1 is clustered, other numbers are nonclustered.
Steve Jones
November 25, 2002 at 9:36 am
Very very true. Be sure that if you move servers, the target server issue may crop up as well.
See my kill that target article for details.
Steve Jones
November 21, 2002 at 1:51 pm
Shouldn't hurt to reinstall SP3 and might help.
Steve Jones
November 21, 2002 at 1:49 pm
connect to master, not the db to be restored.
Steve Jones
November 20, 2002 at 6:48 pm
Look at Brian's book. Basically, you need to be monitoring and baselining over time. Brian has ways to make this easy.
Steve Jones
November 20, 2002 at 6:41 pm
Internet - Use an anon user with Integrated security. Trap the user/pwds in the app and store them (encrypted pwd) in a table.
Intranet - Using Windows auth. Works well.
Steve Jones
November 19, 2002 at 2:48 pm
I think this will still work on 7.0. I reviewed a security book recently (not yet published) and the author had an interesting way to do this. Under NDA, so...
November 19, 2002 at 2:46 pm
Viewing 15 posts - 36,856 through 36,870 (of 39,771 total)