Viewing 15 posts - 1,591 through 1,605 (of 2,840 total)
You can just script the command that the GUI used using script method and see how it is being done. Probably the Schema qualifier is also added to the article...
October 9, 2009 at 1:30 pm
We use different VLANS for different servers or computers. All DBs will stay in the DB Vlan. All DBs will have network teaming set up. But we not use separate...
October 9, 2009 at 1:18 pm
Task manage will not give an accurate value of the memory usage by SQL Server executable. Why dont you check this article to get more[/url] details of what you are...
October 9, 2009 at 1:08 pm
This is just a shot in the dark but are there any blocking in the subscriber DB? Seems like it starts to catch up then it is getting blocked by...
October 9, 2009 at 11:40 am
If you look at the Security of SQL Server, you will probably see BUILDIN/Administrators as one of the sysadmins. There are couple of things you should do.
Run the SQL Service...
October 9, 2009 at 8:04 am
This looks more like you are having problems with getting the right execution plan. Check for parameter sniffing. If sp_recompile is bringing the CPU down that would mean that it...
October 9, 2009 at 7:48 am
Seems more like IO issues than anything else. IS the user DB and the Distribution DB on the same controller? The log files too?
The events that are thrown write...
October 9, 2009 at 7:43 am
Gail, that is a politically correct way to confront the DBA... 🙂 My hats off to you. 😀
October 8, 2009 at 2:44 pm
I hope you read Gails and my statement. That is where your solution is right now.
October 8, 2009 at 2:33 pm
Both the products that are causing the issue are third party products. I think you should get in touch with them to help you out of this issue.
October 8, 2009 at 2:31 pm
When you add the new article to the existing publisher, it will generate a snapshot for only that table. Not for the whole publisher.
October 8, 2009 at 2:19 pm
You cannot replicated stored procedures if you are using SQL 2000. (From my knowledge atleast) So feel free to change the stored proc in the production, script it and run...
October 8, 2009 at 2:17 pm
Stop the log reader agent and Snapshot agent. maybe if the changes get too stale you might have to reinitialize it.
October 8, 2009 at 1:22 pm
This does not look like the transaction log is full. It seems like the your Data file is full. Did you run out of Hard disk space or is there...
October 8, 2009 at 1:18 pm
Grant Fritchey (10/8/2009)
Arggghhh. This is just frustrating.
That was like pulling teeth from a tiger...heheheh
October 8, 2009 at 9:02 am
Viewing 15 posts - 1,591 through 1,605 (of 2,840 total)