How do I confirm all the data moved from Source to target for different tables
How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks
Answer Question
| November 25, 2009 4:35 PM
Data migration, SQL, SQL migration
How do I confirm all the data moved from Source to target for different tables. I am not able to phrase this question. Bottom line I want to make sure all the data was transferred to target database. That is my test to validate. Thanks
Answer Question
| November 25, 2009 4:35 PM
Data migration, SQL, SQL migration
The most-watched IT questions this week: Nov. 24, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy software was asked by JuSi [...]
Answer Question
| December 1, 2009 4:28 PM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Cluster drives moving windows server 2003 r2 32 bit was asked by a reader and answered by Mrdenny. 2. Migrating to virtualized environment purely to retain support for legacy software was asked by JuSi [...]
Answer Question
| December 1, 2009 4:28 PM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
hardware requirement for sql 2005.
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
Answer Question
| November 25, 2009 12:20 PM
SQL Server 2005, SQL Server databases, Windows Server 2003
Hi all, We are planning into SQL 2005 server (windows server 2003)with multipledatabases of sizes of around 10gb.What should be the CPU speeds ,type of CPU and RAM requirements for ir
Answer Question
| November 25, 2009 12:20 PM
SQL Server 2005, SQL Server databases, Windows Server 2003
SQLRPGLE Cursors and Recursion
I’m trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I’m sure it has to do with cursors and the prepare statement in my PI. Here’s the code: pprintPrograms b dprintPrograms PI d program 10a value d spacer 10a value [...]
Answer Question
| April 12, 2012 11:09 PM
iSeries, Recursion, SQL Cursors, SQLRPGLE
I’m trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I’m sure it has to do with cursors and the prepare statement in my PI. Here’s the code: pprintPrograms b dprintPrograms PI d program 10a value d spacer 10a value [...]
Answer Question
| April 12, 2012 11:09 PM
iSeries, Recursion, SQL Cursors, SQLRPGLE
Msg 102, level 15, State 1, Line 14
Hi, I’m ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the ‘ON’ on the line “SET ANSI_NULLS ON”. Could you please help me? I can’t see what’s wrong. Here’s my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT ON; SET ANSI_NULLS [...]
Answer Question
| November 19, 2009 6:54 PM
CREATE TABLE statement, SQL, Stored Procedures
Hi, I’m ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the ‘ON’ on the line “SET ANSI_NULLS ON”. Could you please help me? I can’t see what’s wrong. Here’s my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT ON; SET ANSI_NULLS [...]
Answer Question
| November 19, 2009 6:54 PM
CREATE TABLE statement, SQL, Stored Procedures
The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]
Answer Question
| November 19, 2009 6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]
Answer Question
| November 19, 2009 6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
MS SQL Server to Oracle Applications
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal interface table and concurrent request [...]
Answer Question
| November 18, 2009 9:16 PM
Oracle applications, Oracle migration, SQL Server
We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal interface table and concurrent request [...]
Answer Question
| November 18, 2009 9:16 PM
Oracle applications, Oracle migration, SQL Server
How to encrypt a big list of sp’s at once
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn’t be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I’ll like to know if there is a way [...]
Answer Question
| November 18, 2009 7:52 PM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn’t be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I’ll like to know if there is a way [...]
Answer Question
| November 18, 2009 7:52 PM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization
FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?
I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, “BACKUP DATABASE dbname TO DISK=’C:TESTBK.BAK’ WITH FORMAT “, sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified folder. With the same function if [...]
Answer Question
| November 17, 2009 2:49 PM
SQL Server backup, SQL Server error messages, SQLExecDirect
I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, “BACKUP DATABASE dbname TO DISK=’C:TESTBK.BAK’ WITH FORMAT “, sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified folder. With the same function if [...]
Answer Question
| November 17, 2009 2:49 PM
SQL Server backup, SQL Server error messages, SQLExecDirect
Composite foreign Key in SQL Server
I have a composite foreign key that has to be part of the primary key of the new table… but an error appears in SQL server… CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta) REFERENCES PeliculaEnVenta(IDpel, IDvta)); IDpel AND [...]
Answer Question
| November 17, 2009 1:56 AM
Composite Foreign Keys, Foreign keys, SQL Server 2008, SQL Server error messages
I have a composite foreign key that has to be part of the primary key of the new table… but an error appears in SQL server… CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta) REFERENCES PeliculaEnVenta(IDpel, IDvta)); IDpel AND [...]
Answer Question
| November 17, 2009 1:56 AM
Composite Foreign Keys, Foreign keys, SQL Server 2008, SQL Server error messages
Email Notification
Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job… can anyone help me out with how [...]
Answer Question
| January 23, 2010 12:09 AM
SQL Server database, VB.NET
Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job… can anyone help me out with how [...]
Answer Question
| January 23, 2010 12:09 AM
SQL Server database, VB.NET
passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the linked server, which means I can not access [...]
Answer Question
| January 12, 2010 6:29 PM
SQL 2005, SSIS, Stored Procedures, T-SQL
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the linked server, which means I can not access [...]
Answer Question
| January 12, 2010 6:29 PM
SQL 2005, SSIS, Stored Procedures, T-SQL
Issue with passing data between two SQL Server databases
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I [...]
Answer Question
| June 13, 2013 9:07 PM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server, which means I [...]
Answer Question
| June 13, 2013 9:07 PM
Linked Server, Passing Data, SQL, SSIS, Stored Procedures
pl/slq procedures – POSITIVE and POSITIVEN as IN OUT parameters
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws [...]
Answer Question
| November 12, 2009 7:49 PM
Data Types, Oracle, PL/SQL
Hi, I have a simple PL/SQL procedure with IN and OUT parameter of type POSITIVEN. CREATE or REPLACE PROCEDURE PROC ( inval IN POSITIVEN, outval OUT POSITIVEN ) AS BEGIN outval := inval; END; I pass the value 1 for the IN value using the sql type INTEGER in a jdbc application. But oracle throws [...]
Answer Question
| November 12, 2009 7:49 PM
Data Types, Oracle, PL/SQL
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet Explorer Depends on Adobe Tony Bradley explains [...]
Answer Question
| November 12, 2009 7:00 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet Explorer Depends on Adobe Tony Bradley explains [...]
Answer Question
| November 12, 2009 7:00 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
SA Password change for SQL
What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?
Answer Question
| November 20, 2009 5:52 PM
SA password, SQL 2005, SQL 2005 admin, SQL 2005 SP3
What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?
Answer Question
| November 20, 2009 5:52 PM
SA password, SQL 2005, SQL 2005 admin, SQL 2005 SP3
Can we get sql server authenticated logins and passwords?
Plz forward me the solution of the above query. Thanks & Regards, Gangadharan M
Answer Question
| November 12, 2009 4:54 AM
SQL Server authentication, SQL Server User Accounts
Plz forward me the solution of the above query. Thanks & Regards, Gangadharan M
Answer Question
| November 12, 2009 4:54 AM
SQL Server authentication, SQL Server User Accounts
How do I fetch synonym names with the SQLTables function in ODBC API?
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set — [...]
Answer Question
| November 10, 2009 9:40 PM
ODBC, SQL tables
Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0, <br>SQLCHAR*)”‘TABLE’,'VIEW’,'ALIAS’,'SYNONYM’”, SQL_NTS);</p><p>I am getting back a table and views in a result set — [...]
Answer Question
| November 10, 2009 9:40 PM
ODBC, SQL tables
SQL select for month date range
Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February. The code I am attempting to use is below, but every [...]
Answer Question
| November 10, 2009 10:03 PM
SQL, SQL Server
Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February. The code I am attempting to use is below, but every [...]
Answer Question
| November 10, 2009 10:03 PM
SQL, SQL Server
sql results to text file
I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new [...]
Answer Question
| November 9, 2009 9:17 PM
SQL 2005, sql 2005 Performance Issues
I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new [...]
Answer Question
| November 9, 2009 9:17 PM
SQL 2005, sql 2005 Performance Issues
