unable to connect sql server 2000 on network
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
We have sql server 2000 instance on a machine say “comp1″.The problem is when i need to connect to it via another computer on LAN using SSMS it is unable to connect but when i connect to the “comp1″ via run and give password then i am able to connect through SSMS Can someone give [...]
Answer Question
| April 11, 2012 1:19 PM
SQL Server 2000, SSMS
How to connect my computer to SQL server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
I need your kind support in connecting my computer to SQL server 2005? I am a bignner and I will be thankful if you explain it step by step? What should I write in the code to recognize my database? Thank you and regards..
Answer Question
| May 16, 2012 10:43 AM
SQL Server, SQL Server 2005
Selection of Friday Date
In lotus designer how we can Select only friday dates in Calender/Time control? (for eg. if we select tuesday date corresponding week’s friday date should be selected.)
Answer Question
| May 10, 2012 10:20 AM
Lotus calendar, Lotus Designer
In lotus designer how we can Select only friday dates in Calender/Time control? (for eg. if we select tuesday date corresponding week’s friday date should be selected.)
Answer Question
| May 10, 2012 10:20 AM
Lotus calendar, Lotus Designer
Printer File
I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.
Answer Question
| March 30, 2012 7:32 AM
AS/400, AS/400 Printer File
I am able generate a report using printer file.Now the concern is how to make second or more page when the records are too many.
Answer Question
| March 30, 2012 7:32 AM
AS/400, AS/400 Printer File
Track SQL Statements run by a specific user through ODBC Connection
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this id on daily basis to [...]
Answer Question
| March 31, 2012 6:45 AM
iSeries DB2, SQL statements
Schedule Job
Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1 user-user1
Answer Question
| March 29, 2012 6:19 AM
ADDJOBSCDE, AS/400, WRKJOBSCDE
Hi I need to Run a Job daily at 11Am Except Saturday & Sunday. How I can do it. And also What is the Use of WRKJOBSCDE and ADDJOBSCDE. Lib1/Prog1 user-user1
Answer Question
| March 29, 2012 6:19 AM
ADDJOBSCDE, AS/400, WRKJOBSCDE
copying tables to excel
How do I copy a table with more than 65000 records into an excel workbook?
Answer Question
| March 29, 2012 9:36 PM
Microsoft Access 2010, Microsoft Excel 2010
How do I copy a table with more than 65000 records into an excel workbook?
Answer Question
| March 29, 2012 9:36 PM
Microsoft Access 2010, Microsoft Excel 2010
Order column in pivote table from vba
I need help to make this, i try with PT4.PivotFields(“Category”).AutoSort xlDescending, “Ventas” but not sorting. Please helpme, With ActiveSheet.PivotTables(“PivotTable5″).PivotFields(“Ventas”) .Orientation = xlDataField .Position = 1 .Function = xlSum .NumberFormat = “#,##0″ .Caption = “Sum Of Ventas” End With ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _ .AutoSort xlDescending, “Sum Of Ventas” [...]
Answer Question
| March 28, 2012 7:15 PM
Microsoft Excel 2007, VBA
I need help to make this, i try with PT4.PivotFields(“Category”).AutoSort xlDescending, “Ventas” but not sorting. Please helpme, With ActiveSheet.PivotTables(“PivotTable5″).PivotFields(“Ventas”) .Orientation = xlDataField .Position = 1 .Function = xlSum .NumberFormat = “#,##0″ .Caption = “Sum Of Ventas” End With ActiveSheet.PivotTables(PivotTable5).PivotField(“Category”) _ .AutoSort xlDescending, “Sum Of Ventas” [...]
Answer Question
| March 28, 2012 7:15 PM
Microsoft Excel 2007, VBA
Rational Software Development Platform
I have version 6 of the Rational Software Development Platform (worbench) and it often fails to compile programs which compile successfully within PDM. Anyone experience this?
Answer Question
| March 28, 2012 2:49 PM
Rational Developer for IBM i
I have version 6 of the Rational Software Development Platform (worbench) and it often fails to compile programs which compile successfully within PDM. Anyone experience this?
Answer Question
| March 28, 2012 2:49 PM
Rational Developer for IBM i
Transaction Log Backup and Removal
How can I backup the transaction logs, so that they automatically truncate the transaction logs? Our EMC Replication Manager has stopped doing daily backups of Exchange 2003 transaction logs, and thus need to find a manual way to ensure backup of transaction logs, data integrity, and truncation of all logs to ensure our exchange stays [...]
Answer Question
| April 29, 2012 7:47 AM
EMC Replication Manager, Microsoft Exchange 2003
How can I backup the transaction logs, so that they automatically truncate the transaction logs? Our EMC Replication Manager has stopped doing daily backups of Exchange 2003 transaction logs, and thus need to find a manual way to ensure backup of transaction logs, data integrity, and truncation of all logs to ensure our exchange stays [...]
Answer Question
| April 29, 2012 7:47 AM
EMC Replication Manager, Microsoft Exchange 2003
How many times can I reinstall MS Office Home and Student 2010?
I read that I can install MS Office Home and Student 2010 on 3 computers. If I install/activate it on my computer, computer crashes, then reinstall/reactivate it on the same computer – would that count as 2 separate installations/activations?
Answer Question
| March 30, 2012 4:09 AM
Microsoft Office 2010, Windows 7
I read that I can install MS Office Home and Student 2010 on 3 computers. If I install/activate it on my computer, computer crashes, then reinstall/reactivate it on the same computer – would that count as 2 separate installations/activations?
Answer Question
| March 30, 2012 4:09 AM
Microsoft Office 2010, Windows 7
Limit the number of record in a table
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of [...]
Answer Question
| March 28, 2012 2:01 AM
Query, Query Parameters
I want to limit the number of records that a user can input in a specific table. for instance, users should be able to subscribe to a race which are limited to 10 tracks. I would i to have a clause or something that might help my to prevent users from exceeding the number of [...]
Answer Question
| March 28, 2012 2:01 AM
Query, Query Parameters
user_change.sql
in order to change the table names to the target system sid after performing a restore of database from another system will the following code work – – Before running this script, replace the following[Br type=”_moz” /> – @NAME@ – your new <SID> in lowercase (prd for example).[Br type=”_moz” /> – [...]
Answer Question
| March 28, 2012 12:16 AM
ECC 6, SQL Server
in order to change the table names to the target system sid after performing a restore of database from another system will the following code work – – Before running this script, replace the following[Br type=”_moz” /> – @NAME@ – your new <SID> in lowercase (prd for example).[Br type=”_moz” /> – [...]
Answer Question
| March 28, 2012 12:16 AM
ECC 6, SQL Server
How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.
Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with Zeroes. [...]
Answer Question
| May 22, 2012 3:50 PM
as400/DB2, SQL/400, SQLRPGLE
Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with Zeroes. [...]
Answer Question
| May 22, 2012 3:50 PM
as400/DB2, SQL/400, SQLRPGLE
Outlook Group Policies not being applied
Hi there, I’m having trouble setting up Outlook 2010 security policies using Local Group Policy. I’m trying to set up some policies for attachment handling. I want to add file extensions to block as level 2 so that the user must save to hard disk before opening. I’m editing the following policies: User Configuration – [...]
Answer Question
| March 27, 2012 2:18 PM
Microsoft Outlook 2010, Outlook policies
Hi there, I’m having trouble setting up Outlook 2010 security policies using Local Group Policy. I’m trying to set up some policies for attachment handling. I want to add file extensions to block as level 2 so that the user must save to hard disk before opening. I’m editing the following policies: User Configuration – [...]
Answer Question
| March 27, 2012 2:18 PM
Microsoft Outlook 2010, Outlook policies
Grouping of a/c.
I am using Oracle and through SQL Worksheet i want to get information as followes. My table Name is bilmst and field 1 enterdate and field 2 a/c. no I want to group no of a/cs fininacial year wise. My financial year starts from 01-jul to 30-jun for example 2005-06 means from 01-jul-05 to 30- [...]
Answer Question
| April 6, 2012 6:55 AM
Oracle, SQL Worksheet
I am using Oracle and through SQL Worksheet i want to get information as followes. My table Name is bilmst and field 1 enterdate and field 2 a/c. no I want to group no of a/cs fininacial year wise. My financial year starts from 01-jul to 30-jun for example 2005-06 means from 01-jul-05 to 30- [...]
Answer Question
| April 6, 2012 6:55 AM
Oracle, SQL Worksheet
Quick Test Professional
I have installed QTP 10.0 in windows 7 Home Premium 64 bit OS. But it is not recognizing the objects neither in Internet Explorer 9 nor in Internet Explorer 8. So, how to make it work with web objects?
Answer Question
| March 27, 2012 6:41 AM
QTP, Windows 7 Home Premium
I have installed QTP 10.0 in windows 7 Home Premium 64 bit OS. But it is not recognizing the objects neither in Internet Explorer 9 nor in Internet Explorer 8. So, how to make it work with web objects?
Answer Question
| March 27, 2012 6:41 AM
QTP, Windows 7 Home Premium
Convert RTF to PDF on i5
Is there application which convert RTF documents to PDF and is running on i5. RTF files are on IFS folder and there is thousands of files to convert.
Answer Question
| May 3, 2012 6:28 AM
AS/400, i5/0S, iSeries applications
Is there application which convert RTF documents to PDF and is running on i5. RTF files are on IFS folder and there is thousands of files to convert.
Answer Question
| May 3, 2012 6:28 AM
AS/400, i5/0S, iSeries applications
Network in VMware workstation
I have installed Win Xp Sp2 using VmWare workstation 6.5 in windows 7 Home Premium 64 bit OS. But, I am not able to access the internet in that Xp OS. When I pinged, am getting the reply, but when I tried to access websites using Internet Explorer it is saying that wepage could not [...]
Answer Question
| April 6, 2012 6:18 AM
VMware, VMware Workstation, Windows 7 Home Premium
I have installed Win Xp Sp2 using VmWare workstation 6.5 in windows 7 Home Premium 64 bit OS. But, I am not able to access the internet in that Xp OS. When I pinged, am getting the reply, but when I tried to access websites using Internet Explorer it is saying that wepage could not [...]
Answer Question
| April 6, 2012 6:18 AM
VMware, VMware Workstation, Windows 7 Home Premium
Creating Views in MYSQL via Sysdate
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
