How can you show a table description (not the name) in SQL Server 7.0 the way you can with Sybase Database Server and the DB2 Server?
If you want all the details about a table in SQL Server 7.0, run
EXEC sp_help <table>
Also, you can see this information in the SQL Server Enterprise Manager in the Databases, Tables folder. Simply right-click on any table to get a description or the data from the table.
Through DTS, I've created a job in SQL Server that uploads my data from a .csv file into a table, and now I want to rename this file as the current date with a .txt extension (e.g., 11-15-99.txt). The date needs to change with the system date, and the file needs to rename as soon as the data successfully finishes uploading.
You need to add an ActiveX script task to your package and execute it after you import the data from the .csv file to the table (as if it's using the On Success precedence constraint). Then in the ActiveX script task, you can use native VBScript functions to go out to the file system and rename the file.
I'm running a data warehouse application on SQL Server 6.5. A nightly process inserts rows and aggregates the data into weekly, monthly, and yearly tables. I consistently get the following error in the Windows NT application error log:
WARNING: Open Objects parameter may be too low.
Error: attempt was made to free up descriptors in localdes Error: run sp_configure to increase parameter value.
I set the OPEN OBJECTS parameter at 5000. How can I determine the appropriate parameter value?
Microsoft fixed the problem with temporary tables and open objects in Service Pack 3 (SP3) for SQL Server 6.5. Make sure that you've upgraded to at least SP3, although Microsoft recommends SP5. I don't know of any way to monitor how many object handlers are currently open within SQL Server. Your best bet (if you have enough memory) is to bump up open objects to a higher number to represent the maximum number of open tables, stored procedures, views, etc., that you have open.
In SQL Server 6.5, I often get Open Data Services (ODS) error code 17832. I've sniffed the entire network and I can't find a problem. Now the event log is full of ODS messages with the same error code. What can I do?
The ODS messages are just informational; you can't do anything to stop them from appearing. Look at article Q109787 at http://support.microsoft .com/servicedesks/msdn/ for more detailed information about this error. Article Q109787 says that a variety of SQL Server communication-related errors are possible and that, in general, these errors don't indicate a problem with SQL Server, but rather a network, network configuration, or a client-application
problem.
Editor's Note: Send your SQL Server-related questions to questions@sqlmag.com.
End of Article
Prev. page
1
[2]
next page -->
