Open IT Forum: What cloud concern do you need addressed?
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Looping in SQL
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
SQL server 2008 provide access to SSIS
Client needs access to SSIS sql server 2008 Thanks, Evgenia
Answer Question
| February 23, 2011 2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
Client needs access to SSIS sql server 2008 Thanks, Evgenia
Answer Question
| February 23, 2011 2:36 AM
SQL Server, SQL Server 2008, SSIS, SSIS database
International SQL Server Replication
I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for billers to [...]
Answer Question
| February 22, 2011 8:28 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication
I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for billers to [...]
Answer Question
| February 22, 2011 8:28 PM
Secure Data Transfer, SQL replication, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server database, SQL Server replication
SQL sub query or where exists
I am working on with SQL server 2003 and using winsql to access and run the query. In the following query I am trying to get the data for a Part (PMPRNO) that the Material (PMMTNO) is from the supplier “AMER NAT” an has a status (MBSTAT) of “20″. One other paremeter is I only [...]
Answer Question
| February 24, 2011 2:38 PM
SQL Server 2003, SQL Server Query, Sub Query, Windows Server 2003
I am working on with SQL server 2003 and using winsql to access and run the query. In the following query I am trying to get the data for a Part (PMPRNO) that the Material (PMMTNO) is from the supplier “AMER NAT” an has a status (MBSTAT) of “20″. One other paremeter is I only [...]
Answer Question
| February 24, 2011 2:38 PM
SQL Server 2003, SQL Server Query, Sub Query, Windows Server 2003
Free IT Book: The RAILS 3 Way
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL 2000 database recovery
Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf [...]
Answer Question
| September 29, 2011 1:48 PM
SQL 2000, SQL 2000 recovery, SQL Database, SQL Server 2000, SQL Server 2000 Database
Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf [...]
Answer Question
| September 29, 2011 1:48 PM
SQL 2000, SQL 2000 recovery, SQL Database, SQL Server 2000, SQL Server 2000 Database
SQL reporting
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
Passing an array parameter from crystal reports to a sql stored procedure
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
SQL concatenate results
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
SQL Server 2008 r2 won’t install
I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can’t get past the failure. The following error has occured: An error occurred during the installation of assembly ‘policy.8.0.microsoft.vc80.crt, version=’8.0.50727.4027′, publickeytoken=’1fc8b3b9a1e18e3b’, Processorarchitecture=’x86′,type=’win-32-policy’. HRESULT:0x800736fd I have uninstalled, installed . I am out of [...]
Answer Question
| March 4, 2011 11:00 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server installation, Windows Server 2008, Windows Server 2008 R2
I receive the following error when installing SQL Server. I have installed .net 4.0 full x64 bit as some sites suggest but I can’t get past the failure. The following error has occured: An error occurred during the installation of assembly ‘policy.8.0.microsoft.vc80.crt, version=’8.0.50727.4027′, publickeytoken=’1fc8b3b9a1e18e3b’, Processorarchitecture=’x86′,type=’win-32-policy’. HRESULT:0x800736fd I have uninstalled, installed . I am out of [...]
Answer Question
| March 4, 2011 11:00 AM
SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server installation, Windows Server 2008, Windows Server 2008 R2
Restore SQL Server after OS loss
I have all datafiles and backups but no OS services. What steps would I take to restore the database
Answer Question
| February 21, 2011 11:05 AM
Backup, SQL Server, SQL Server backup, SQL Server backup and restore
I have all datafiles and backups but no OS services. What steps would I take to restore the database
Answer Question
| February 21, 2011 11:05 AM
Backup, SQL Server, SQL Server backup, SQL Server backup and restore
SQL Server and AntiVirus
We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
We have many sql server running on seperate boxes, the Network team wants to install antivirus software on all the sql servers. Is that a good idea? Why?
Answer Question
| March 2, 2011 4:46 PM
Antivirus, SQL Server, SQL Server 2008, SQL Server security, Windows Server 2003
Update a subquery with different tables
I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT =’01′ where MVXJDTA.MITMAS.MMITNO = MVXJDTA.MITSTA.MHITNO (Select [...]
Answer Question
| February 18, 2011 8:04 PM
SQL Query, SQL tables, Subquery
I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT =’01′ where MVXJDTA.MITMAS.MMITNO = MVXJDTA.MITSTA.MHITNO (Select [...]
Answer Question
| February 18, 2011 8:04 PM
SQL Query, SQL tables, Subquery
How to connect Visual Basic 6.0 to wampserver using odbc
Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.
Answer Question
| September 26, 2012 6:52 AM
SQL Server, SQL Server connectivity, VB 6.0, Visual Basic 6.0, WAMP Stack, Windows XP SP3
Sir, please give me the proceedure in connecting visual basic 6.0 to wampserver using odbc. show me on how to configure odbc in order to connect wampserver. Give me an example code of edit, delete and save using visual basic 6.0. Your help is appreciated a lot.
Answer Question
| September 26, 2012 6:52 AM
SQL Server, SQL Server connectivity, VB 6.0, Visual Basic 6.0, WAMP Stack, Windows XP SP3
Open IT Forum: What’s high on your priority list for 2011?
We’re a good month and a half into the year, and we wanted to know what’s at the top of your priority list. Does your company want to deploy at least one new application to the cloud or improve holes in your cloud security? Are you learning a new development language to keep up with [...]
Answer Question
| September 27, 2011 9:04 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We’re a good month and a half into the year, and we wanted to know what’s at the top of your priority list. Does your company want to deploy at least one new application to the cloud or improve holes in your cloud security? Are you learning a new development language to keep up with [...]
Answer Question
| September 27, 2011 9:04 PM
AS/400, Channel, CIO, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SSRS Report switch for Operational DB to DWH
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]
Answer Question
| February 16, 2011 2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]
Answer Question
| February 16, 2011 2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008
Free IT Book: AAA Identity Management Security
This week’s free IT book is your complete, authoritative guide to implementing, configuring, and managing AAA with CiscoSecure ACS. For a chance to win AAA Identity Management Security, answer one of the questions listed below and post the link to your answer in the discussion section of this question. Upgrade Exchange 2007 from 2003 (downgrade [...]
Answer Question
| February 23, 2011 1:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is your complete, authoritative guide to implementing, configuring, and managing AAA with CiscoSecure ACS. For a chance to win AAA Identity Management Security, answer one of the questions listed below and post the link to your answer in the discussion section of this question. Upgrade Exchange 2007 from 2003 (downgrade [...]
Answer Question
| February 23, 2011 1:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Thousands and thousands of simultaneous users hitting a sproc — what do you do?
folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for [...]
Answer Question
| February 16, 2011 12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures
folks, i am not a db guy altogether, but I am a developer, and someone had asked me that question, and i got interested in the resolution. Lets say you have 50K users that hit the same stored procedure at the same time. The stored procedure is computation intensive and goes out to lunch for [...]
Answer Question
| February 16, 2011 12:14 AM
SQL Server, SQL Server 2008, SQL Server stored procedures, Stored Procedures
Oracle 10g terminated_with_error
while iam running a 10g report using the following code : declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(50); BEGIN repid := FIND_REPORT_OBJECT(‘REPORT1′); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘rep_app_oracle_forms’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML’); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); message(rep_status); message(rep_status); WHILE rep_status in (‘RUNNING’,'OPENING_REPORT’,'ENQUEUED’) LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = ‘FINISHED’ THEN –Display report WEB.Show_Document(‘/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_',-1)+1)|| [...]
Answer Question
| February 16, 2011 11:58 AM
Oracle 10g, Oracle 10g error messages, SQL Server Report Builder
while iam running a 10g report using the following code : declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(50); BEGIN repid := FIND_REPORT_OBJECT(‘REPORT1′); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, ‘rep_app_oracle_forms’); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, ‘HTML’); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); message(rep_status); message(rep_status); WHILE rep_status in (‘RUNNING’,'OPENING_REPORT’,'ENQUEUED’) LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = ‘FINISHED’ THEN –Display report WEB.Show_Document(‘/reports/rwservlet/getjobid’ ||substr(v_rep,instr(v_rep,’_',-1)+1)|| [...]
Answer Question
| February 16, 2011 11:58 AM
Oracle 10g, Oracle 10g error messages, SQL Server Report Builder
