Viewing 15 posts - 6,046 through 6,060 (of 6,215 total)
Sorry for the slow reply. I have limited experience with clusters, but if you're running active active seems like it should be possible. Let's see if Brian K can shed...
August 20, 2001 at 4:43 pm
I'll have to show my lack of knowledge here. I thought each copy of the cluster kept its own binaries, then you just had a shared quorum disk?
Andy
August 20, 2001 at 4:41 pm
Drop the SQL folders, then clean out all the MSSQL... keys from the registry. Keep cleaning until it installs!
Andy
August 20, 2001 at 4:35 pm
I havent done much with 6.5 DMO either - with luck never will! You could also just test the server version first by using ADO to execute 'select @@version', then...
August 20, 2001 at 4:33 pm
Or you could just execute sp_spacedused, which should match what you get in EM. Not pure DMO, but easy!
Andy
August 20, 2001 at 4:31 pm
An alternative is to go with a higher fill, but rebuild more frequently. It also depends a lot on what your primarykey is - if you're using something that always...
August 20, 2001 at 4:29 pm
Yes, it will work. Step one is to establish connectivity. After that you can do replication, log shipping, whatever. As far as bottlenecks, it really depends on the number and...
August 20, 2001 at 3:05 pm
You need to drop and recreate your view. Once you encrypt it SQL no longer stores the plain text of the view/proc/function in plain text. If you're using encryption you...
August 18, 2001 at 8:17 am
Got a note from Mark today, DBCC fixed it - syssubscriptions was corrupted.
Andy
August 17, 2001 at 3:49 pm
Never tried it. Bad idea I think, unless one will be heavily used and the other lightly. Each is going to suck up memory. Hard enough to tune a DBMS...
August 17, 2001 at 3:48 pm
Looks like you have an actual data or disk error. BI_Data contains your data, is not the distribution db? Tried running dbcc checkdb to repair any errors? If nothing found...
August 17, 2001 at 5:08 am
So, you just have one client machine polling or many? You really have two issues:
1) Reduce bandwidth usage
2) Optimize the selection process
For #1 (assuming only one client polling) I don't...
August 17, 2001 at 5:04 am
Have you tried including the path to each file? Just tried on my workstation at work, emailed myself autoexec.bat and boot.ini with no problem. I didnt see anything for 7.0/2000...
August 16, 2001 at 5:59 pm
Definitely try it with a sql login before you spend too much time on troubleshooting.
Andy
August 16, 2001 at 5:43 pm
Viewing 15 posts - 6,046 through 6,060 (of 6,215 total)