A set of SQL Server 7.0 servers we inherited came with the Named Pipes Net-Library installed during Setup. Now we have to add the TCP/IP Net-Library to these SQL Server instances, and I'm concerned that to add a Net-Library, we have to run Setup...
If you aren't comfortable using Oracle tools to query the Oracle data dictionary, some SQL Server system stored procedures can help you obtain Oracle metadata from the linked Oracle server. The following procedures accept from four to seven...
One of my tables showed 33 dependent stored procedures before I dropped the table for a maintenance and change cycle. Is executing a CREATE on the stored procedure the only way to reestablish those stored procedure dependencies...