Search results for query: *

Thank you so much Robert. -Gigi JK

Hi, I lost a database from SQL Server 7.0 during a re-installation of SQL Server. I have the .mdf and .ldf files on the hard drive. Is there any way I can re-create the database in the SQL server using these files? Thanks -Gigi JK

Thanks. This is exactly how I resolved the issue.<br>-GJK

Is there any way I can output the result of a Master-Detail Query to a text file preserving the master-detail format within DTS? I need to include the count and the company info at the top of the file followed by each employee info.<br><br>Eg. I have two tables Company and Employees<br><br>My...

Create a user with Admin rights. Eg MTSAdmin. And have all the packages including the system package run under this account. Let me know if this does not work.<br><br>-GJK

From my experience, I never had to mess with&nbsp;&nbsp;mess with dcomcnfig when I dealt with .dlls running on MTS. It should work without any adjustments in dcomcnfg. What OS yr clients running on 95/98/NT?

Did you try to create a new package? Run RegClean on the system.

Try Service pack 4 or 6. 5 had lot of problems

Yes. computer name is BPNYDB1.<br>Here is my latest research results with some clues to the problem. But still have the problem and no clue as to how to resolve this. Hop you could help me. <br>Found one more clue that may be causing the problem. I queried sysservers of&nbsp;&nbsp;two other...

For some reason, my previous reply to msg&nbsp;&nbsp;which was answered by jnicho02 is showing only half of it.<br>Here is the full version.<br>Thanks for yr response. I did a SELECT @SERVERNAME and getting NULL as the answer. <br>This is my scenario. I have CDB_Prodn as a Publisher and CDB_Sub...

For some reason. my previous msg is showing only half of it.<br>Here is the full version.<br>Thanks for yr response. You are right. I did a SELECT @SERVERNAME and getting NULL as the answer. <br>This is my scenario. I have CDB_Prodn as a Publisher and CDB_Sub as a suscriber. In CDB_Prodn, I run...

Thanks for yr response. You are right. I did a SELECT @SERVERNAME and getting NULL as the answer. <br>This is my scenario. I have CDB_Prodn as a Publisher and CDB_Sub as a suscriber. In CDB_Prodn, I run sp_ADDSERVR 'CDB_Prodn' and got the result

I am trying to start Replication Wizard on a SQL Server 7.0.<br>and I am getting the&nbsp;&nbsp;following error<br>&quot;SQL Server Enterprise Manager could not complete the wizard because @@servername for '' is NULL.<br>Use sp_addServer to set @@serverName&quot;<br><br>Any ideas about why this...

How do I configure SQL Server 7.0 so that I can send emails from SQL Server using Triggers?<br><br>Thanks<br>-GJK