July 8, 1999

Differences Between NT Servers and NT Workstations

Question: What is the difference between NT servers and NT workstations? Are they different machines or just different operating systems? Answer: NT servers and NT workstations run the same operating

Executing an Existing DTS Package

Question: How can I execute an existing DTS package from Visual Basic? Answer: Get an object reference to the package. I do this in Visual FoxPro: loxx=createobject(‘DTS.Package’,’CmdExample’) Then I ask

Oracle 7

Question: I am new to SQL. I need to use Oracle 7, but I need a user name and password. How can I get started? Answer: You need to ask

Suggesting a SQL Reporting Tool

Question: I need to get a handle on my choices for a SQL reporting tool for ad hoc reports. The quick-and-dirty requirements are that it must be able to develop

Moving SQL 6.5 to a RAID 5 Machine

Question: We are currently running SQL 6.5 and want to upgrade to SQL 7.0. The machine hosting SQL 6.5 is not robust enough to handle SQL 7.0. We are running

Common Stored Procedures

Question: I have three databases in SQL Server 6.5. All have the same structure of tables and stored procedures, but whenever I change stored procedures in one I must do

Data Type for Time

Question: What is the data type for time? Example: 8:45 am Answer: What you really have is the tail end of a datetime data type. You can get it back

Remotely Shutting Down NT Using VB

Question: I am writing an application that needs to be able to shut down any NT workstation or server remotely. Do you have any ideas on how to do this

SQLMaint Update Error

Question: When I run SQLMaint to update statistics on one of our SQL 6.5 servers, the table statistics get updated but it returns an error message: [4] Update Statistics…[Microsoft SQL-DMO]