Recent content by Miriam

Thanks a lot, I will try. Can you please answer on my additional questions: Do I have to add it in REPL-Distribution job as additional step for each subscriber? If yes, does it mean what this DTS will run EVERYTIME the replication ran? Do I have to add it after "Run agent" step and...

In Enterprise Manager right click on Data Transformation Services [folder itself] - Open package... Miriam.

Hello, Does somebody knows is it possible to automate the run of DTS package right after replication is finished? I am replicating the stored procedures from my load server to production servers. If any changes in any stored procedure have been done I have to reinitialize all subscribers and...

Hello, One of ny database become corrupted and market suspect. Error messages were: Error: 823, Severity: 24, State: 2 I/O error (torn page) detected during read at offset 0x0000011cfa4000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\MyDatabase.MDF'.. Error: 3313, Severity: 21...

Glen, Thank you for quick response. Yes, it is up to date. SysAdmin said me that it updated automatically everyday/week. He does't know how it came in. I have 3 SQL Server Production servers and on each of them the same story with this junky messages. I will look for ad-aware. Thanks, Miriam

Hi, In System Log on my Porduction server I see many messages like this one: Application popup: Messenger Service : Message from TELEISP to 12.8.3.69 on 9/27/2002 4:12:22 PM NEVER PAY FOR LONG DISTANCE AGAIN! *Unlimited long distance calling has finally arrived! *Works from any home or office...

Hello, I have merge replication set up to push a table out to subscribers on the same server. The SA password was changed and now the distribution agent for the subscriber cannot connect. I'm getting an error: "Login failed for user 'sa'" Where I can change this password in the...

I forgot to mention that I have SQL Server 2000 SP2 on W2K server. Thanks, Miriam

I check all catalogs today morning. Most of them is finished the population. But one is still running for 3rd day. This catalog has only one table. Table has about 4,5 million records; the index on column with varchar type. I read about [sp_fulltext_service ‘resource_usage’] system stored...

Hi, I am populating full-text catalogs. It takes days already. Is it somehow I can improve the speed of this process? Thanks in advance, Miriam

Terry, Thanks a lot for advice and explanation. I will change the data type. Miriam

Terry, Thanks a lot, it's works. But it's works perfectly ONLY if I have MyData=0.4199999999999999 (16 digits after .) If MyData =0.41999999999999999 (one more zero - my actual data) it's round the result. I think my task just impossible. Miriam

Hi everybody, I need to convert float data type to string, but I don't want round the data. For example: MyData = .3999999 or =.5 I want to have MyResult = .399 or .500 (with no round!) I tried STR, CONVERT, CAST function and combination of this function and LEFT, LEN finction and etc...

Hello, I have to change SA and SQLDBA [SQL domain administrator] password on production servers. I have replications set up between servers: transactional and merge; I also have many Jobs scheduled. What the problems I have to expect? What the important steps I have not forget? Any advice...

Wow, it is really scary. And I feel sure that Norton Antivirus cannot catch the hackers. Am I wrong? I found many very, very interesting threads on this forum about security and hacking. I will check it for me. Thank you to everybody, Miriam Someone was right: don’t trust the people if you...