How can I get the hardware spec of a SQL Server remotely? Mar 04, 1999 A. xp_msver will return most of the information you need. How can I get ISQL.EXE to return a DOS errorlevel for me to test? - 05 Mar 1999 Mar 04, 1999 A. Use the RAISERROR command with the following criteria :... How can I fix a corruption in a system table? Mar 04, 1999 A. A. If the problem can be fixed with an index re-create, then... How can I do a crosstab function using standard TSQL in SQL Server? Mar 04, 1999 A. It's obviously easier to use a product that has this sort of... How can I check whether SQL 6.5 or SQl 7.0 is installed without connecting to SQL and logging on? Mar 04, 1999 A. You could check :... How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
How can I get ISQL.EXE to return a DOS errorlevel for me to test? - 05 Mar 1999 Mar 04, 1999 A. Use the RAISERROR command with the following criteria :... How can I fix a corruption in a system table? Mar 04, 1999 A. A. If the problem can be fixed with an index re-create, then... How can I do a crosstab function using standard TSQL in SQL Server? Mar 04, 1999 A. It's obviously easier to use a product that has this sort of... How can I check whether SQL 6.5 or SQl 7.0 is installed without connecting to SQL and logging on? Mar 04, 1999 A. You could check :... How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
How can I fix a corruption in a system table? Mar 04, 1999 A. A. If the problem can be fixed with an index re-create, then... How can I do a crosstab function using standard TSQL in SQL Server? Mar 04, 1999 A. It's obviously easier to use a product that has this sort of... How can I check whether SQL 6.5 or SQl 7.0 is installed without connecting to SQL and logging on? Mar 04, 1999 A. You could check :... How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
How can I do a crosstab function using standard TSQL in SQL Server? Mar 04, 1999 A. It's obviously easier to use a product that has this sort of... How can I check whether SQL 6.5 or SQl 7.0 is installed without connecting to SQL and logging on? Mar 04, 1999 A. You could check :... How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
How can I check whether SQL 6.5 or SQl 7.0 is installed without connecting to SQL and logging on? Mar 04, 1999 A. You could check :... How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
How can I access data across two separate databases in SQL Server? Mar 04, 1999 A. With SQL 6.5 and below this is easy as long as the databases are... Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
Should I use tempdb in ram? Mar 04, 1999 A. The short answer is no. In almost all cases you are better off... Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
Do SQL Service Packs have to be applied in order or can I just apply the latest one? Mar 04, 1999 A. You can just apply the latest one. Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
Does SQL Server run under Win2000/NT5? Mar 04, 1999 A. SQL 7 works fine under Win2000. For SQL 6.5 you need to upgrade to SP5 otherwise DUMP and LOAD DATABASE commands will fail. Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More
Error message : Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE. Mar 04, 1999 A. This error message is put in the SQL errorlog at startup if the MSDTC service isn't running/configured. Unless you are using DTC this is perfectly normal. More details on DTC can be found in the SQL Server Books Online. (BOL) Load More first previous … 860 861 862 863 864 865 866 867 868 … next last Load More