Viewing 15 posts - 181 through 195 (of 5,103 total)
WayneS (4/28/2009)
noeld (4/28/2009)
Side note: wouldn't it be better to have those 3 different select statements to be in separate procs, with this proc controlling which one gets run?
That is what...
April 28, 2009 at 3:10 pm
Side note: wouldn't it be better to have those 3 different select statements to be in separate procs, with this proc controlling which one gets run?
That is what I would...
April 28, 2009 at 2:29 pm
...all the user created stored procs are encrypted (lock indicator shown in SSMS).
That is not necessarily an indication of encryption.
I have seen the UI show the "lock indicator" simply when...
April 28, 2009 at 11:37 am
Why exactly do you want to do this?
April 28, 2009 at 8:51 am
Shark Energy (4/28/2009)
It seems everything is timing out and I have to keep changing timeout settings. The monitoring...
April 28, 2009 at 8:49 am
By the way when I said "get in the way" I meant "LOCKING/BLOCKING" in distribution database.
April 27, 2009 at 8:44 am
srikanth.katta1 (4/27/2009)
How to configure replication in sql servr 2000 ( step by step with screen shots )
Although this forum is supposed to be for SQL Server 2005 here you go:
http://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm
April 27, 2009 at 8:43 am
I have seen this before and is usually that the Distribution cleanup job gets in the way.
Sometimes I have even disable it for a while to let subscribers catch up...
April 27, 2009 at 8:42 am
That's the strategy we use.
What I really like about it is that you have data readily available at two places and you can fully utilize the resources of both (publisher...
April 27, 2009 at 8:39 am
I do!
How? There are so many processing scripts to manage sql server from perl that even there is a book written about just this:
April 24, 2009 at 3:33 pm
"The process is running and is waiting for a response from the server."
That message usually happens when there is blocking involved.
You should check your server for blocking/locking issues.
April 24, 2009 at 12:21 pm
The job just needs one step to call the sp_validate...
On the subscriber the alert will fire if there are validation errors.
If the alert has notification by email that's all you...
April 24, 2009 at 12:15 pm
Edwin (4/21/2009)
The Publisher tables have more than single primary keys.
For example: Table A has
...
April 24, 2009 at 12:12 pm
J-F Bergeron (4/21/2009)
Nicholas Cain (4/21/2009)
April 21, 2009 at 2:40 pm
It should not be a problem theoretically but Identity columns are still identity even if they are being used indirectly. If you happen to change your inserts to run on...
April 21, 2009 at 2:33 pm
Viewing 15 posts - 181 through 195 (of 5,103 total)