I actually need to take the backup on another machine and I'm using a UNC path. I actuallu added a backup device first using the command below; USE...
I need to backup the logfile to another computer on the network. How can I do this? Anybody any ideas? Thanks in advance, Fulya
I'm changing the sa password from the server properties, I also tried changing it from the services, but neither of them worked. So you are saying I...
when I change the sa password of the publication server and also change the sa password of the subscription server to the same new password, although...
Thank you very much, Fulya
During the replication , when data is getting transferred from the publisher to the subscribers, is the data encrypted? Thanks in Advance, Fulya
We have a database with SQL_Latin1_General_CP1_CI_AS collation, we want to change this to Turkish_CI_AS collation, after we change the collation of...
Does anybody know any programs that I can use to monitor query performance on SQL 2000? I would like to know which queries are running how frequently...
I have transactional replication configured between 2 SQL 2000 servers. In case of a failure , I would like to know how to backup the distribution...
I'm running SQL 2000 Enterprise Edition with SP3.Following is what I did. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSQL2KTracking...
The service is started and actually when I want to restart it, it doesn't give me any errors, it starts just fine. Any ideas? Fulya...
The problem is , it's showing that it's greyed out. Although the service is started and it shows that it's installed it, inactive and I can't use it....
I have this huge issue with full text indexing. It shows that it 's greyed out. When I want to install it, it shows that it's already been installed...
I found the solution to this on Microsoft's site. http://support.microsoft.com/?scid=kb;en-us;Q300676 But I can't download the file s80305i.exe , can...
Bad news!!! I've tried this first in a test machine. and it worked, I was excited that it worked, but when I actually wanted to implement it on the...
it worked !!! Thank you so much. Fulya
Here is what I did;<br />Right -click and go to properties on the publication<br />Choose filter columns tab<br />I unchecked the column I wanted to...
Service pack 3 is installed on SQL and windows 2003 is the OS
I'm a newbie with replication .Sorry for my lack of knowledge. Do you have any instructions on how to do this? Can I do this from Enterprise...
I have replication setup between two SQL 2000 servers, I want to change the size of a column on the publisher and I get the following error. How can...
Separate names with a comma.
