Viewing 15 posts - 2,371 through 2,385 (of 6,216 total)
Not the greatest, but sometimes you have to make do. Two concerns. One is that you're doing more writes to the drives that the logs are on - how big...
March 23, 2003 at 4:32 pm
You'll have to either use an aggregate function in the select, or add the column in the group by.
Andy
March 23, 2003 at 12:54 pm
Have a lot of options. You can employ true column level security within SQL (not my favorite), use views, or simpler to me - handle the security within the application...
March 23, 2003 at 9:58 am
We still haven't got a review of it done, I'm hoping to at least test drive it in the next week or so. Did you by chance try SQL Compare...
March 23, 2003 at 9:55 am
Files copied from CD will have the readonly bit set, might try clearing it.
Andy
March 21, 2003 at 7:55 pm
In your publication find the articles tab, you can set some snapshot options there. Don't know that my usage is typical, but I always run a post snapshot script to...
March 21, 2003 at 7:53 pm
I don't think getting the error indicates a problem, just that it can't achieve single user mode. I usually leave the repair errors option unchecked, if the integrity check reports...
March 21, 2003 at 11:24 am
You want SQL to have as much memory as possible. With 4g you should just use /3GB in the boot.ini, no need for AWE. That gives SQL 3g, 1g for...
March 20, 2003 at 12:54 pm
March 20, 2003 at 9:47 am
That's a hard question to answer fairly. I consider .Net technically better (inheritance, try/catch, real threading). If you're a VB6 developer, Vb.Net is a nice upgrade. In my opinion if...
March 20, 2003 at 5:02 am
Beyond me as well. Trying brute force, you could grab the script for each proc, then iterate through and comment out one line containing a declare, then try to run...
March 19, 2003 at 6:54 pm
Sorry, left that out, you need to change the procs on the subscriber. SQL2K is better than SQL7, at least you can easily add/drop cols. Perhaps in the next version...
March 19, 2003 at 12:33 pm
Easiest way is to drop the publication, make the change, then re-snapshot. You can shortcut some by stopping the logreader, making sure all transactions have been distributed, then removing the...
March 19, 2003 at 7:35 am
Not really/yet. I'd recommend starting with the wizards - doing it manually is a LOT of work, and doing it on a test machine so you can set it up...
March 19, 2003 at 5:57 am
We'll to the list. Honestly I think right now it's column based - we might look at doing something a little more DBA'ish for the various contact methods.
Andy
March 19, 2003 at 5:50 am
Viewing 15 posts - 2,371 through 2,385 (of 6,216 total)