Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Retrieve system information
Hi All, Is it possible to retrieve information about the PC(such as Modem, Disk Space, Software installed etc) using SQL server? I need to collect and analyse the information from many PCs (MSDE has installed on each of them). We have try to run "msinfo32" and then save it to text...- qqq
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
compare date
Hi, My question is : how to compare some date with sysdate and if the difference more than 10 days, delete those records. I've create the trigger and following script supposed to do this but it does not. if (sysdate - :old.trans_date_time)<10 then RAISE_APPLICATION_ERROR(-20000,'Cannot Delete...- qqq
- Thread
- Replies: 2
- Forum: Oracle: Enterprise Developer Suite
-
Connect to database
Hello, I have gote a problem to connect to database. When I try to open SQLPlus8 or Enterprize Manager using username "system" and password "manager" it produce error :no listener found or cannot resolve service name. This server and databases were created long time ago by...- qqq
- Thread
- Replies: 8
- Forum: Oracle: All versions
-
establich connection between MSSQL server an 'non MSSQL'server.
My questions is: Is it possible to establish connectivity between MSSQL server and 'NON MSSQL Server(for web application) programmatically. We can do it manually (Control Panel/ ODBC data sourse/System DSN) but we need to do during the installation process. Another words, is it possible to...
