Explain Stored Procedures in AS/400
Hi, Can any one please explain me 1.What is stored procedures in AS/400. 2.What is the use of Stored Procedure 3.Please give me small example how to code stored procedures in AS/400 4.What is the object type of Stored procedures 5. How can we code stored Procedures and how can we call it. and main [...]

Answer Question   |  February 20, 2009  8:31 AM
AS/400 development, AS/400 stored procedures, Stored Procedures

What Is Your SQL Server 2008 Adoption Rate?
http://benchmarkitconsulting.com/colin-stasiuk/2009/02/19/please-vote-what-is-your-sql-server-2008-adoption-rate/ SQL Server 2008 RTM is over 6 months old now and I’m wondering what people are seeing so far in terms of adoption rate. What I’ve seen so far in the environments that I’ve been working on definitely falls in the 1% – 25% category. What has everyone seen in the environments that they [...]

Answer Question   |  February 19, 2009  8:47 PM
SQL Server 2008, SQL Server 2008 Adoption, SQL Server upgrades

Server 2003 memory performance configuration
We have a SQL application running in an n-tier environment. Some of the users are complaining about application performance. I am going through the environment looking at all of the elements involved in processing this application. The information below shows all of the server systems involved in the application and the page file and RAM [...]

Answer Question   |  February 20, 2009  8:35 PM
Server Performance, SQL, SQL Server, Windows Server 2003, Windows Server Performance

SQL Server 2008 Export data problem
Hi I’m trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy. Firstly I created a new empty [...]

Answer Question   |  February 19, 2009  1:43 PM
SQL Server 2008, SQL Server backup, SQL Server Data Storage, SQL Server Export

Installing SQL Server 2005 Enterprise Manager in Windows XP Pro
how to install SQL 2005 enterprise manager in XP professional.. When I am trying to install it, it is giving me IIS errors

Answer Question   |  February 19, 2009  11:25 AM
IIS, IIS errors, SQL Server 2005 Enterprise Manager, SQL Server 2005 error messages, SQL Server Enterprise Manager, SQL Server error messages, Windows XP, Windows XP Professional

How do I combine multiple rows into one row?
I have a table Col1 Col2 Col3 Col4 Col5 —– —— —— —– —— 1 abc NULL NULL NULL 1 NULL def NULL NULL 1 NULL NULL ghi NULL 1 NULL NULL NULL jkl I want: Col1 Col2 Col3 Col4 Col5 —– —— —— —– —— 1 abc def ghi jkl At first I thougt [...]

Answer Question   |  February 19, 2009  11:37 PM
SQL Mulitple Rows

RPGLE Stored Proc to Reporting Services
Have SQLRPGLE program set-up to use cursor to return result set, want to use this to return table to MS Reporting Services get error message “low-order nibble of byte array offset 2451 is not valid. Byte Value OO. What does this mean and why not data back to client?

Answer Question   |  July 3, 2009  10:21 PM
Reporting Services 2005, RPGLE, SQL stored procedures, SQLRPGLE

two dimentional output
I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes [...]

Answer Question   |  February 3, 2010  5:53 PM
SQL Query, SQL tables, Two-dimensional Output

SQL Restore takes 6-10 minutes to come up in Enterprise Manager
SQL Restore takes 6-10 minutes to come up in Enterprise Manager. We have a customer with hundreds of sites, and all their servers do the same thing. We had to roll back after an upgrade and we find that when just selecting “Restore Database” it will seem like Enterprise Manager is hung, but eventually it [...]

Answer Question   |  February 17, 2009  2:52 PM
MySQL Restore, SQL 2000, SQL Enterprise Manager, SQL performance, SQL Restore, SQL Restore Performance, Windows 2000 Server

My CL program is running CPYTOIMPF cmd & causes an SQL error
Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error code is 10. When I F1 on the line in the job log and then F9 for details, I see this: From program QSQCLI in QSYS, module SQLSEA, procedure SQLSetEnvAttr at stmt 5793 and To program QCPEXPRT [...]

Answer Question   |  February 17, 2009  4:35 PM
CL programs, CPYTOIMPF, SQ999999, SQL error messages

Oracle SQL-Pagination Help
Hi, The below inner SELECT returns huge amount of rows (1000000+) and the outer SELECTs(alpha BETWEEN #startRec# AND #endRec#) is used for PAGINATION to display data with 25 in each page. Issue is:-This PAGINATION done below is very slow and slows the entire display of data.So could all please help me on doing this below [...]

Answer Question   |  January 2, 2010  4:24 PM
Oracle SQL, Oracle SQL Pagination, Pagination, SELECT statement

How to move the msdb database to sql 2005
I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I’m getting a compatability error message. Any suggestions greatly appreciated.

Answer Question   |  February 17, 2009  2:30 PM
SQL 2005, SQL 7, SQL database replication, SQL Server MSDB Database

SQL Server does not exist or Access Denied Error
I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use [...]

Answer Question   |  February 17, 2009  12:23 PM
Database connectivity, Error: Access Denied, SQL Server, VB.NET, Visual Basic .NET

What are basic differences between SQL Server 2000 and 2005
What is the Basic difference between SQL 2000 and 2005, thanks

Answer Question   |  February 23, 2009  11:35 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005

SQL Server 2005 backup
how to take backup of live site

Answer Question   |  February 16, 2009  11:32 AM
Backup, SQL Server 2005 backup, SQL Server backup

Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?
hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver… i believe every thing should be fine. I have check the access permission for that user. that is not the [...]

Answer Question   |  February 16, 2009  7:09 PM
Database connectivity, DSN connection, Microsoft Access, Microsoft Excel, SQL Server connectivity, SQL Server import/export

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  February 18, 2009  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures

How do I populate an SQL table created on the fly in RPGLE?
I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and [...]

Answer Question   |  February 16, 2009  4:20 AM
Dynamic SQL, Microsoft Excel, RPG, RPGLE, RPGSQL, SQL, SQL2JXL

SQL Server Agent job Failures
I would like to know if there is any way to get Agent jobs such as backups, Update Stats jobs to write to the error log on failure. I have written a monitoring program that looks in the errorlog and alerts on pertinent errors. I would like to be able to use this solution for [...]

Answer Question   |  February 13, 2009  7:33 PM
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Agent, SQL Server Agent Jobs

SQL Server 2000 performance issues
Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database application is a manufacturing information [...]

Answer Question   |  February 16, 2009  7:05 PM
iSCSI, perfmon, SAN, SQL Server 2000, SQL Server performance, SQL Server performance tuning