Hi, Just for your information... I have created stored procedures on the publisher that delete the unecessary data from the db. The stored...
yes it was the solution. <br />but these jobs are running on every weekend. I don't want to come in on every sunday morning an re-create the...
The logreader worked fine. I saw that the distribution database growing. The status of the agent was running and the last action sad "15 transactions...
sql sp3 (on Windows 2000 Sp4) is installed on each server. I read about the sp3a but as Microsoft sad it is not important to apply this sp to sql...
Hi, I have two SQL 2000 server. The first one is used by the production and the second one is used for reporting. There is a transactional...
do xou know what is the cause of this problem?<br />currently my replicated database is corrupted again. If I run the dbcc checkdb with...
W2K SP4 and SQL2K Sp3 Zsolt
The msg is the following<br /><br />Error: 8908, Severity: 22, State: 6<br />Table error: Database ID 9, object ID 1333631844, index ID 0. Chain...
Hi, I have an active-active SQL cluster server. The 1st node contains only one (user) database. The second node has a replicated database of this...
Hi, thanks for the suggestions. The server has a dual 2,8 Ghz P4 processor with 4 GB RAM WE have an MSA1000 Storage system. The server is purchased...
Hi, I have database that is often written and red by the user. The server is responsible for the production. The client program collects many...
no, in SQL 7 I was able to import this txt directly. Zsolt
I have solved the problem. I have created an ODBC connection to this text file with Ms Txt Treiber driver. I chose this ODBC as source and the DTS...
i have recreated this package but I received the same error message Zsolt
Hi, We have upgraded our SQL 7.0 server to SQL 2000. I had some DTS packages which are import data from text files to the SQL server. These packages...
I execute it from the server. The file is available and the access rights are correct I have copied this DTS package from SQL 7.0, I have re/created...
Hi, I have created a DTS package that is importing data from a txt file. When I execute the package it works correctly, but when I schedule it I...
Hi, We trz to create a transactional replication between 2 SQL 2000 Server. I want to publish everzthing *tables, views, stored procedure(. After...
Hi, how can I copy DTS packages from Sql 7.0 to Sql 2000? Zsolt
Separate names with a comma.
