I'm experiencing intermittent connection problems using TCP/IP. We have serveral different servers. Some running SQL Server 7 and a couple of new servers running SQL Server 2000. Clients can consistently connect to the SQL 7 servers but not the SQL 2K servers. Anyone else out there having...
I've worked mostly with stored procedures with parameters that read data from a 'loader DB table' to load data into the application tables of my DB. One problem I'm having is referencing a procedure or table thru a linked server. The connection acts flaky (meaning it drops sometimes for no...
Any good resources out there to assist migrating from SQL 7 to SQL 2000. So far I simply backed up the SQL 7 databases and restored them on sql 2000. Early testing shows no problems.
I'm running SQL Server 7.0 When running a stored procedure that access data or calls another stored proc in a linked server, I sometimes get a timeout error. If I rerun the proc again, it works. Any ideas what the problem or solution is???
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.