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
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 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?
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 two other...
For some reason, my previous reply to msg 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 following error<br>"SQL Server Enterprise Manager could not complete the wizard because @@servername for '' is NULL.<br>Use sp_addServer to set @@serverName"<br><br>Any ideas about why this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.