Anyone of how to link a SQL2K server to a SQL7.0 server ...
I have tried and the two servers from the NT level can see and talk to each other ... but trying to link the servers is not working ...
Thanks
I am running a SQL 2000 server (Server A) on Win2000. I have a seperate server(Server B) running SQL 7.0 on NT6.0. When I attempt to create a linked server From B to A, I am unable to connect but I am able to create a linked server from A to B and connect( but I can go the opposite direction from A to B and connect). We have another server (Server C) that is running SQL 2000 and NT6.0. We can connect from B to C (so we are assuming that issue is not one of version compatability between versions 7.0 and 2000). The server Network configurations on all the servers are the same. The only difference is Win2000. Are there any other factors we may not have considered?
Thanks.
Hi,
I have to move 2 fields from sql 7 to sql 2k .
the field is text.
feild a is text
field b is text.
I have to add field a and field b and move it to another field (say field c which is also text )in sql 2k.
How to go about it?
TIA.
Jsi
Does any body know if it is possible to register SQL 2000 server from SQL v7.0 enterprise manager.
Thanks
I don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 1 Replies View RelatedI don't have any extra machines, so I'm thinking of evaluating SQL2K on one of my existing boxes with SQL 7 already installed. My experience is that SQL 6.5 co-existed extraordinarily well with SQL 7. Does the same apply to the SQL 7 / SQL 2K combination? Thanks!
View 3 Replies View RelatedCan we restore a SQL 2k Backup in SQL Server 7.0 database?
Will there be any issues on it?
hi,
iam under process of upgrading sql7 to sql2000.
already i upgraded clients to sql2000. then i got problem with some of our applications to connect to sql7 server. then i replaced in clients new ntwdblib.dll with old one then it works fine. to overcome this problem shall i install MDAC2.6 on server, where sql7 is there.
Is there any problem to SQLserver7.0 with MDAC2.6 ? because i want to install MDAC2.6 on production server with sql7.0.
thanx
keerthi
I'm converting DBs from SQL7 to SQL2K; the previous owner & server issues had created secondary data and/or log files. The size of the databases, and the configuration of the new server, do not warrant those secondary files. In restoring the databases from SQL7 to SQL2K, either by detach/copy/attach or backup/restore, is there a method for deleting the secondary files without, of course, losing any data?!
TIA,
Al
Just wanted to know if anyone is aware of any issues with NT40/SQL70 & Win2K/SQL2K servers in a Windows 2003 domain? ... or if anyone can point me to some links to read up on ... thanks in advance for any response.
View 2 Replies View RelatedBelow is the script. The problem is when I simulated the Oracle linkdrop, my SQL2K never have to a chance to head to the GOTO section as itdies with this error msg and exit. Any idea on a workround? Thanks.Server: Msg 7399, Level 16, State 1, Procedure USP_Link_Check, Line 8OLE DB provider 'MSDAORA' reported an error.[OLE/DB provider returned message: ORA-12154: TNS:could not resolveservice name]OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializereturned 0x80004005: ].----------------------------------------------ALTER PROCEDURE [USP_Link_Check] ASDECLARE @myERROR int -- Local @@ERROR, @myRowCount int -- Local @@ROWCOUNT--- Verify network connectionsselect *from openquery(OraLink,'select count(*) from Oracle.table')IF @myERROR != 0 GOTO HANDLE_ERRORHANDLE_ERROR:Print ' Error in Oracle Link'RETURN @myERROR---------------------------------------------
View 1 Replies View RelatedHi, can someone help me on this
View 10 Replies View RelatedThe company for which I work did not have a DBA until I started a few weeks ago. Whoever installed SQL2K used the wrong CD so they have been running Personal Edition on their servers. I have installed a new SQL2K standard instance and have restored everything except the jobs and DTS packages. Can the msdb from the Personal edition be restored to the standard instance?
View 3 Replies View RelatedIs it possible to downgrade SQL from Enterprise to Standard Edition, or do you have to remove the previous installation (uninstall) and reinstall. Meaning you would also have to restore all user databases? Thanks.
View 1 Replies View RelatedWe are currently running these specs...
CPU: Dual 2.4Ghz Xeons
RAM: 4GB
HD: Raid 5
OS: Windows 2000 SP4
SQL: SQL 2000 32bit
Our RAM is constantly at 75% of the physical memory. The CPU usage ranges from 10-90%. I need recommendations on brand and specs. I would like to keep the cost under $10k.
It needs to have RAID 1 for the OS and at least 200GB RAID 5 or 10 for the data. We would also like to have hot swappable drives.
Here's the configuration I am considering...
Brand: Dell (Not sold on this yet)
CPU: Dual Quad 2Ghz Xeons
RAM: 8GB
HD 1: 36GB RAID 1
HD 2: 300GB RAID 10
OS: Windows 2003 64bit
SQL: SQL 2005 64bit
What are the pros/cons of upgrading from SQL 2000 32bit to SQL 2005 64bit? Also, any recommendations on the hardware?
Hi ,
On my Desktop i registered Production Server in Enterprise Manager
on that Server if i go to SecurityLinked Servers
There is another Server is already mapped, when i am trying to see the Tables under that one of the
Linked Server i am getting the Error message saying that
"Error 17 SQL Server does not exist or access denied"
if i went to Production Server location and if i try to see the tables i am able to see properly, no problems
why i am not able to see from my Desk top
i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)
And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem
What might the Problem how can i see the Tables in Linked Server from my DESKTOP
Thanks
I am using Linked Server in SQL Server 2008R2 connecting to a couple of Linked Servers.
I was able to connect Linked Servers, but I cannot point to a specific database in a Linked Server, also, I cannot rename Linked Server's name.
How to point the linked server to a specific database? How to rename the Linked Server?
The following is the code that I am using right now:
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver
@server = N'Machine123Instance456',
@srvproduct=N'SQL Server' ;
GO
EXEC sp_addlinkedsrvlogin 'Machine123Instance456', 'false', NULL, 'username', 'password'
Hi,
I have a server that has sql server 2000 standard edition, and I just got a new server but this time I'm going to use sql2005 Express (free version).
My databases are not 2gigs in size, so I should be fine.
What is the best method for me to convert the databases? Is it to just detach the database and re-attach in sql2.5?
Is there a way to bypass the syntax checking when adding a stored procedure via a script?
I have a script that has a LINKed server reference (see below) .
INSERT
INTO ACTDMSLINKED.ACTDMS.DBO.COILS ..etc.
ACTDMSLINKED does not exist at the time I need to add the stored procedure that references it.
PLEASE to not tell me to add the LINK and then run the script. This is not an option in this scenerio.
Thanks,
Terry
We have a current install of SQL2005 Developer on a Win 2003 Server Enterprise and it works as advertised. It is accessed as Test05
Yesterday a SQL2000 Developer Edition was also installed on the same Server as named instance Test05Test052000.
The 2000 seems to start and run OK and can be connect to by Management studio etc from that same box. However it can not be connect to via the network. Any ideas?
Hi All,
One of my clients has installed SQL5K at their HeadOffice. However there are some production units are there running under SQL2K. We have one stored procedure which used to update the masters from HO to Units. Under SQL2K it was working fine, but when we run the procedure on HO under SQL5K, it returns the following error message.
**************************************
OLE DB provider "SQLNCLI" for linked server "charlie1" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "charlie1" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 4
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "charlie1". The provider supports the interface, but returns a failure code when it is used.
*************************************
The above also ocurs when I simply issue the command :
SELECT * FROM [server2K].[Mydatabase].[dbo].[MyTable]
I've tried to add the server with "sp_addlinkedserver" it was added successfully. The login info is same across the servers.
Please help me out I am stuck badly.
Thanks
Raoshan
An unknown person at a client's site installed IIS on a production SQL Server. I would like to remove it (it's not being used and the service is shut down). Does anyone know of any troubles with uninstalling IIS? Will the removal also hose SQL?
Thanks in advance?
Steve
How can I copy a SQL 7 database from one server to another? Please tell me all the ways because I've tried the obvious and it doesn't work. (backup and restore - won't go from one server to another, DTS transfer object Wizard - does a whole pile of errors and doesn't do stored proceedures and trigures). Thanks for help in advance. Also, what is the email address to post to the listserv and where is the FAQ for SQL7? Most of my listserv's tell you where to post right at the bottom of the digest I get - any chance you guys would do that with this list? Thanks again.
View 6 Replies View RelatedIf I change the network name of a machine running MS SQL 7, will the SQL server still work afterwards?
If not, where can I find the procedure to achieve this?
thanks for your suggestions!
Bart Vierbergen
I have setup SQL2000 Personal edition on my notebook.
I cannot connect to an existing SQL7 server on the network anymore. I
used to run SQL7 Desktop edition which ran just fine.
I also noticed that when I start my machine it take about 2 minutes
until the SQL service is started.
Any ideas why this is not working anymore?
Thomas Schoch
Elephant Software AG
Switzerland
Hello all,
Is there any special procedure to install a SQL7 (plus sp3) and a SQL8 server on a Windows 2000 Server.
I did succed installing both of them, but all of my applications are behaving strangely ()error msg ect)...So I may supose that there some kind of predefined process to have those kind of installation working properly..?
Any idea would be welcomed !
Thanks a lot in advance,
Regards,
Benj.
Can you please advise on how to copy tables from DB1 to DB2 on the same SQL 7 Server. The programer had me drop the tables from DB2 and wants me to copy the tables from DB1 to DB2.
Thanks for any help.
How to restore a database dump file (.BAK) that backed up from SQL2000 server to a SQL 7.0 server?Please help.Saiyou
View 1 Replies View RelatedHi
We have two servers each running SQL7. I cannot run a trace on one server from the other. Whatever server name I enter in the drop down box, the trace only records activity on the server that profiler is running on. Even if I put a non-existent server name in the box (!), the trace accepts the name but still only runs on the host server.
Any explanations please.
Keith
I have been asked to install Sql 7 on a Win2K server. I am looking for White papers, articles, postings etc which identify potential issues or known issues. I have looked through MSDN, Win2K, Microsoft Sql7 and TechNet for specifics. Any suggestions?
Thank you,
Troy
Hi,
Does anybody know if SQL7 server in running in 6.5 compat mode allow
row-level locking ?????
Thanks
Mahesh
Is there a way I can load a SQL2000 DB backup onto a SQL 7 server? Thanks.
View 1 Replies View RelatedCould anyone inform me how much the conventional memory SQL7 Enterprise on Advanced Server 2000 can have?
The SQL is on an active/active cluster. Currently each runs at 2GB of memory, with available memory for failover. I am planning to add another 2GB to each SQL node. Is this possible? Are there any configurations I need to do? Do I need to set AWE enabled? and How much?
Your help is greatly appreciate.
Jim