Viewing 15 posts - 2,326 through 2,340 (of 6,216 total)
When you make the change in EM, click the script button - 3rd button from left I think, see what it gives you. Remember too that there is no magic,...
April 4, 2003 at 6:49 am
I think that if you need that, you need merge, has a richer set of filtering options. Letting the inserts go through and dealing with them on the subscriber isn't...
April 4, 2003 at 6:48 am
Wow - I've never had to change that. Working is better than not, but I'm not sure you've gotten to the bottom of your issue.
Andy
April 4, 2003 at 6:45 am
Scorpion - if you're doing to do all that, how about wrapping it up into a 'teach us how to fish' article as well? We can always use a little...
April 4, 2003 at 6:41 am
Dronator2k - well said! Hope you're able to find someone that's a good fit. Nothing like reviewing a few dozen posts from someone to get a feel for their knowledge...
April 4, 2003 at 6:38 am
In DMO you get a reference to the object, then use the objects script method. SP_OA gives me a headache.
Andy
April 4, 2003 at 6:37 am
How about using an instead of trigger?
http://www.sqlservercentral.com/columnists/bkelley/triggerswhatsnew.asp
Andy
April 4, 2003 at 6:35 am
I backup up MSDB daily, I dont want to have to remember (or risk forgetting) to run a new backup after I change a job. Doesnt cost much, why not...
April 4, 2003 at 6:27 am
I think empirical is the only way to know for sure. Set it up, test, on to the next config. Intel has a tool called IOMeter that will drive the...
April 4, 2003 at 6:23 am
I doubt it makes much difference, but I agree that I think a good (if not best!) practice is to do the joins in the same order as the tables...
April 4, 2003 at 6:22 am
Statistics are stored differently in SQL2K. Index rebuild will fix it, or you can just run sp_updatestats. Other comments by mdamera are good!
Andy
April 4, 2003 at 6:20 am
I think all of them are $200 or less. Lockwood also has one, should have mentioned:
http://www.lockwoodtech.com/index_sqldiff.htm
Andy
April 3, 2003 at 7:30 am
I think you've got a good case for the instead of trigger. Whether on the table or a view would depend on the frequency - if 10% of the time...
April 3, 2003 at 7:29 am
I currently use SQLCompare and find it quite good, have had a request in for a while to review AdeptSQL - just haven't had time, supposed to be faster, not...
April 3, 2003 at 5:39 am
April 2, 2003 at 2:14 pm
Viewing 15 posts - 2,326 through 2,340 (of 6,216 total)