Viewing 15 posts - 37,756 through 37,770 (of 39,757 total)
Do you have some knowledge of what new stuff goes into Table A?
Actually it doesn't matter. Do an update join on the tables using the PK. Anything that matches will...
May 20, 2002 at 9:56 am
Rebuild the pacakge. I suspect something is corrupt. If you still get this, try it on another client station.
Steve Jones
May 20, 2002 at 9:54 am
I've started seeing a few jobs in Denver asking for the MCDBA cert, but not many. I think this is mainly to limit the number of resumes from people.
I...
May 20, 2002 at 9:51 am
Haven't heard that, but I did hear that Stored procedure can be written in VB.NET, C#.NET, etc. IMHO a bad idea. Fundamental differences between the languages (set v row based)....
May 20, 2002 at 9:44 am
Agree. There isn't a way to do this (other than dynamic sql, which I don't recommend). Besides, that's what CTRL-C, CTRL-V are for 🙂
Steve Jones
May 20, 2002 at 9:43 am
I tend to be biased towards SQL Server, but Antares has great points.
Oracle is regarded as a more scalable and mission critical product. It has a better track record, but...
May 20, 2002 at 9:41 am
Tough to audit everything. Lumigent provides a product that reads the logs, which will capture most of this if not all. You can also run profiler, but that will be...
May 20, 2002 at 9:37 am
Haven't done that much work with Clusters, but I suspect the profile should be on both.
I agree with Andy. Give CDO a shot and then start a thread here with...
May 20, 2002 at 9:34 am
I like things grouped and since procs are usually some sort of function, I use sp (no underscore) to group them initially, then I go by function (Ins, Upd, Del,...
May 20, 2002 at 9:32 am
How else can you look back except from the future :).
Actually it's not out on the site until the 23. The newsletter subscribers see it a little early, but there...
May 20, 2002 at 9:28 am
May 20, 2002 at 9:25 am
Tend to agree with Andy. Don't forget the SQL Mail is a subsystem added on to SQL Server. I'd be wary of switching profiles as you may cause instability on...
May 19, 2002 at 10:48 am
Rich,
There are a few ways to do this, some easier than others. Partly depends on what access you have. If you can create and schedule or run DTS packages, then...
May 19, 2002 at 9:42 am
Are the profiles on the active server? On both? I think you may have issues with the virtual server performing this switch.
Steve Jones
May 18, 2002 at 10:03 am
You are welcome. Glad it caught some eyes, but I'm not sure it's a bug anymore. I tend to this this is by design to increase performance.
Steve Jones
May 18, 2002 at 9:59 am
Viewing 15 posts - 37,756 through 37,770 (of 39,757 total)