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

VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000
I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005 Management Studio my [...]

Answer Question   |  February 13, 2009  10:22 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server connectivity, VB.NET, Visual Basic, Visual Basic .NET

Multiple language support in SSRS 2005
I have to display my report in diffrent language viz French, German. SSRS 2005 Can support Multiple language? Thanks, NRoy

Answer Question   |  February 16, 2009  9:51 AM
Multilingual support, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS 2005

Running .NET Code to manipulate sql tables
is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

Answer Question   |  February 12, 2009  8:52 PM
.NET, SQL Server 2005, SQL tables