Viewing 15 posts - 2,566 through 2,580 (of 6,216 total)
You could also use an instead of trigger to handle the updates in the view.
Andy
February 11, 2003 at 5:25 pm
Agree. Too bad they didnt add a db_procuser role similar to db_datawriter, would be a nice shortcut at times.
Andy
February 11, 2003 at 5:24 pm
BOL says you have to be in syadmin or dbcreator roles, so db_owner is not enough.
Andy
February 11, 2003 at 5:23 pm
Have not, but my guess would be that it's ok. Good thing is if its not, they'll have to let you format!
Andy
February 11, 2003 at 10:25 am
February 10, 2003 at 6:48 pm
I dont see a join anywhere? Need to join the tables so the update makes sense.
Andy
February 10, 2003 at 3:35 pm
Check the status column of the trigger in sysobjects, something like this:
--will return if enabled, d_delete is the trigger name
select * from sysobjects where name='d_delete' and xtype='tr' and status &...
February 8, 2003 at 5:50 pm
Not quite.
1 - Upgrade existing server to SQL2000
2 - Install SQL2000 on new server, put your data folder in same place as original server (actually this is usually the parent...
February 8, 2003 at 1:08 pm
I'd avoid installing SQL7 on the new machine, why clutter it with the left over stuff you always get from an upgrade? I'd upgrade in place, then move.
Yes, you'll have...
February 8, 2003 at 7:42 am
Tried profiling while you do it via EM? That should give you what you need.
Andy
February 7, 2003 at 4:26 pm
Good and cheap?! We use SourceSafe, price is right since we need the licenses anyway. Seems like there is a free/gnu version control app, havent used it.
Andy
February 7, 2003 at 4:26 pm
Wish I knew more. We've just gotten a few CE devices, havent tried anything with them yet.
Andy
February 7, 2003 at 4:24 pm
Think I'd run sp3 first, then move. Tried to restore sp2 backup over sp3 this week, wouldnt work, had to go back to sp2 plus hotfix to get it done.
Andy
February 7, 2003 at 4:20 pm
Should be able to - just run the job using sp_start_job.
Andy
February 7, 2003 at 5:27 am
Viewing 15 posts - 2,566 through 2,580 (of 6,216 total)