Viewing 15 posts - 37,516 through 37,530 (of 39,510 total)
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
You are welcome. Check out DBCCCheckIdent. It will allow you to reseed the identity value (useful when trying to synch two servers), especially in a dev environment. It also lets...
May 17, 2002 at 8:53 am
In SQL, the trigger fires once per transacitons. So if you have a multi-row update, you get one trigger firing. The inserted and deleted contain all the affected rows.
Steve Jones
May 16, 2002 at 7:07 pm
Some good ideas. 🙂 Personally, I avoid the phone, though I think I'll start letting my 3yr old answer.
Steve Jones
May 16, 2002 at 7:05 pm
Wow, thanks for the responses and sorry for being so late in getting to them. Here's a few thoughts.
I got a message from one person expressing this was not a...
May 16, 2002 at 9:51 am
Not sure what you mean? What's in tabletest? You should get the datetimes from the table. Getdate is the server date. Not related.
Steve Jones
May 15, 2002 at 3:59 pm
Agree with Antares. Avoid using owners other than dbo in SQL Server. Not sure about Oracle, but it's more headache than it's worth in SQL Server, IMHO.
Steve Jones
May 15, 2002 at 3:57 pm
Just a thought. If you are doing this anyway, I'd create a view in each DB that points to the other db. Easier than rewriting lots of queries of the...
May 15, 2002 at 3:55 pm
Viewing 15 posts - 37,516 through 37,530 (of 39,510 total)