Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

Answer Question   |  March 26, 2013  10:13 PM
SQL Server 2003, SQL Server 2008 R2

Crystal 8.5 export trouble
My Application is developed in Vb6,Sqlserver2003 and crystal report 8.5.this application is well run on windows XP,Server2003 etc. but now we are Shift our OS to Server 2008 R2 32 bit. application running well but when I trying to export reprot(i.e click on export button of the crystal report) suddenly application going to crash.I cant [...]

Answer Question   |  June 5, 2012  9:48 AM
Crystal Reports 8.5, SQL Server 2003

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

Can I transfer a SQL license/install to a new server
We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008.  We will need to have a full working test environment before rolling out live with it. Can we transfer our “test” [...]

Answer Question   |  January 26, 2011  7:27 PM
License management, Licensing restrictions, SQL Server, SQL Server 2003, SQL Server 2008, SQL Server licensing, Windows Licenses, Windows Server 2003

Remove double qoutes from text file using SED in SQL 2003
This goes along with my previous question “How to remove specific lines from a text files using either vbs or bat.” I am having issues removing the double quotes our app uses in its export as a separator for some fields. The command I use in ssed is ========CODE=================== “s/”//g” =========END OF CODE============ But it [...]

Answer Question   |  November 10, 2010  9:20 PM
SQL Server, SQL Server 2003, Text manipulation, Windows XP Professional SP3

Disaster recovery for SQL 2005
How can we setup a disaster recovery sql server? We are running SQL 2005 on a 2003 box. We need a real time exact replica we can switch to?

Answer Question   |  October 7, 2010  4:58 PM
Disaster Recovery, Replicating databases, SQL Backup, SQL Security, SQL Server 2003, SQL Server 2005, SQL Server 2005 security

SQL Server 2008 Restore error message
I get this error when trying to restore a 30 mg database “Callback:SQL Server 2008: Out of memory on restore” and then get the error “”There is insufficient system memory in resource pool ‘internal’” Anyone have any ideas?

Answer Question   |  August 27, 2010  2:25 AM
SQL Server, SQL Server 2003, SQL Server 2005, SQL Server 2008 error messages, SQL Server restore

My DTS package runs normally, but hangs when run as a SQL Job
Hi, I’m trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I’ve designed a DTS local package as follows: ‘********************************************************************** ‘ Visual Basic ActiveX Script ‘************************************************************************ [...]

Answer Question   |  April 29, 2009  6:01 PM
ActiveX, DTS Local Package, DTS package, Job scheduling, Microsoft Access, SQL, SQL Jobs, SQL Server 2003

Can you replicate SQL 2003/8 to SQL 2000
I am upgrading a server running SBS w/SQL2000. New server will be 2003 or 2008. Would like to use old server for backup off site. Can I replicate, or would I need a new 2003/2008 license to accomplish this?

Answer Question   |  February 12, 2009  1:40 PM
SBS, SQL Server 2000, SQL Server 2003, SQL Server 2008, SQL Server replication

Copy old database as new
Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

Answer Question   |  October 3, 2008  5:44 AM
Database replication, SQL Server 2003, SQL Server replication

Can SQL Server 2003 provide CPU usage information by application?
I have a Windows Server 2003 Service Pack 1 (SP1) machine and need to find out how much of the central processing unit (CPU) each application is using. I am familiar with task list for Windows XP, but the only task list I see on the Windows 2003 machine is a command line tool and [...]

Answer Question   |  March 23, 2008  8:39 PM
CPU usage, SQL Server 2003, SQL Server performance

Moving from single server to multiple servers
Hi all, We have a Single Windows 2000 server (Back office edition, configured as a Primary domain controller). It has SQL server 2000 running, which serves a bespoke database application. The server is also used as a simple fileserver for documents, etc… We do not use Exchange Server. I need to have a way to [...]

Answer Question   |  August 22, 2008  11:41 AM
Backup & recovery, Backup servers, NAS, SDSL, Server migration, Server upgrades, SQL Server 2000, SQL Server 2003, Windows 2000 Server, Windows Server 2003

RAID 1 or RAID 5
I have 1 file server and 1 email server. both are Win2k3….one with exchange 2003 one with SQL 2000 but only 4 people using a small accounting program on it. Both are Dual XEON 2Ghz processors 1 Gb RAM 15K rpm hard drives. Ultra SCSI 160 controllers File server has software RAID 1, Exchange Server [...]

Answer Question   |  August 28, 2008  2:37 PM
Exchange 2003, RAID, RAID 1, RAID 5, SQL 2000, SQL Server 2003