Viewing 15 posts - 121 through 135 (of 155 total)
If your using transactional I may have a solution. Break up the replication into two subscriptions and force the snapshots to initiate in a particular order. Once the snapshots are applied...
February 24, 2005 at 7:12 am
You could stop SQL once, get a valid copy of a master, then just back it up from then on to an alternate location (that I would make sure goes...
February 24, 2005 at 6:59 am
I have never seen in an execution plan SQL use the behind the scenes index created on a constraint. If it does what would it look like? I was always told...
February 17, 2005 at 6:55 am
To get a quick look (especially when new to this) at the transaction log size and space used : start Enterprise Manager, open your server, select the database of interest (by...
February 17, 2005 at 6:46 am
How busy is this database? Does the error occur when the most activity is occuring? I know you can have login errors in SQL Agent when to many job try to...
February 17, 2005 at 6:37 am
Thanks for hints. I found the example. It's a lot more invovled than I expected - but I will work through it.
February 15, 2005 at 8:51 am
I'm trying to use a stored procedure (my first reporting services report trying to use one) and I can't figure out how to reference the names of the fields returned...
February 10, 2005 at 9:20 am
Can I resurect this question?
I've started having this same issue - tape backups are running at the time I get the error. But they have been running for some time...
February 10, 2005 at 6:23 am
PerfectDisk is the one I used and it did defrag what windows would not. But, the disks I was working on were impossibly fragmented. I probably really should have copied them...
February 10, 2005 at 5:56 am
I'm just glad I could help. Sometimes I think I'm the only one that strugles with obscure problems. Just don't seem like they happen to other people...
February 9, 2005 at 8:49 am
I had a very similiar problem with transactional replication but I can't remember the stored procedure name. It wound up being a failed SP3 (or 3a) upgrade on the sunscriber. I presume the...
February 9, 2005 at 6:50 am
Autogrow in small increments will cause major fragmentation and interleaving of your SQL files if you have multiple DBs growing. Shrinking log files and letting them grow back routinely will cause...
February 9, 2005 at 6:43 am
Did you resolve this? WHat if hte server runing SLQ is a domain controller? Does it change the way SQL operates? I am having similiar problem.
January 27, 2005 at 12:12 pm
Since noe-one else has given you any ideas yet here are a couple of mine.
I don't reacall that error exactly, but I had a situation once where DB file growths...
January 21, 2005 at 7:24 am
Thanks for the links. I had not found the MS one yet. The other site appears to still be not functioning quite right.
January 21, 2005 at 6:03 am
Viewing 15 posts - 121 through 135 (of 155 total)