Disk Partitioning w/SQL Server 2000/2005/2008
I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am referring to [...]

Answer Question   |  September 28, 2008  3:51 PM
Partitioning, SQL Server 2000, SQL Server 2005, SQL Server 2008

Is there a built-in stored procedure in SQL Server 2000 that returns the sql table structure of XML format
i have a xml file.i want to insert the contents of the xml file into a table in sql server 2005.

Answer Question   |  September 8, 2008  5:33 AM
SQL Server 2000, SQL Server import/export, XML

query of query errors
I have a runtime query of a query error as below. java.lang.String cannot be cast to java.util.Date But the output format is correct and is in date. This application was developed in coldfusion 6.1 and sqlserver2000. But now we get this error when it was migrated to coldfusion 8 and sql server 2005. Below is [...]

Answer Question   |  September 9, 2008  5:11 PM
ColdFusion, ColdFusion 6.x, ColdFusion 8.x, Java, Java applications, SQL Server 2000, SQL Server 2005

SQL Server Upgrade and Server Move
I have an old Windows 2000 server running SQL 2000 and need to retire the server and move my SQL databases to a new server. The new server is a fresh install of Windows Server 2003 and SQL Server 2005. I am having a hard time finding a procedure for this complex conversion. Is this [...]

Answer Question   |  September 11, 2008  3:23 PM
SQL Database, SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows 2000 Server, Windows Server 2003

Windows 2003 server hangs after reboot
Hi All, We have a Windows 2003 server ( Model: HP Proliant DL385 ) running SQL Server 2000, in which we always experience issues. The issue is that Windows Server 2003 hangs after every reboot. Sometimes, it has also bluescreened and has created a memory dump. First time, when it bluescreened, the memory dump points [...]

Answer Question   |  September 6, 2008  7:36 PM
Event ID 5719, Event ID 5783, Event ID 770, HP ProLiant DL385, SQL Server 2000, Windows Server 2003

sql 2008 system tray icon
how can i add a system tray icon for sql 2008 just like sql 2000?

Answer Question   |  September 28, 2009  8:31 PM
SQL Server 2000, SQL Server 2008

What are the benefits of SQL Server 2005 over SQL Server 2000?
If i am satisfied with SQL 2000 then why I should go for SQL 2005

Answer Question   |  August 27, 2008  8:20 AM
SQL Server 2000, SQL Server 2005, SQL Server migration, SQL Server upgrades

Application compatibility with SQL Server 2005
We would like to upgrade from SQL Server 2000 to SQL Server 2005, but we are currently also using PowerBuilder version 6.0. How can we determine if our version of PowerBuilder is compatible with SQL Server 2005?

Answer Question   |  June 21, 2011  4:18 PM
PowerBuilder, SQL Server 2000, SQL Server 2005

Extracting information with a DTS package from a database in SQL Server 2000
We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we [...]

Answer Question   |  August 31, 2008  3:52 PM
DTS packages, SQL Server 2000, XML

SQL Server 2000 Log File Size is increasing
I have a sql server 2000 where log file is increasing very fast. My mdb file is 600 MB and Log file 6GB. How can i reduce the size of the file. Shrinking the file is not working.

Answer Question   |  August 21, 2008  7:42 AM
SQL Server 2000

how to Configure mail profile in MS SQL 2000 ?
I have a requirment to recieve mail from my SQL server 2000 when ever a JOB in my SQL SERVER Agent fails ,I have my MAPI configured and SMPT too but in the SQL SERVER AGENT Properties window , the Mail profile is not enabled , how do i configure this , I want it [...]

Answer Question   |  August 20, 2008  5:05 AM
SQL Server 2000, SQL Server Agent, SQL Server alerts

Upgrading Microsoft SQL 2000 to SQL 2005
I have one server running SQL Server 2005 and about five servers running SQL 2000. Does anyone know what is entailed as far as upgrading from SQL 2000 to SQL 2005? The majority of the servers are running Win2k Server.

Answer Question   |  May 14, 2009  6:04 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows 2000 Server

Export XML from SQL Server 2000
We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us [...]

Answer Question   |  August 19, 2008  6:36 PM
DTS packages, SQL Server 2000, XML

Reindex DBF file from Ms-SQL 2000
Is it possible to reindex an extenal dbf file via linked server ?

Answer Question   |  August 18, 2008  9:51 PM
DBF file, Linked servers, SQL Server 2000

Access databases
I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

Answer Question   |  August 29, 2008  2:26 PM
Access Database, Microsoft Access, SQL, SQL Server 2000

Can’t Upgrade to SQL Server 2005
I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it cannot be [...]

Answer Question   |  August 13, 2008  9:41 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades, Windows Server 2003 x64 Edition

Copying a database from SQL Server 2000 to SQL Server 2005
I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package (“Access to the path ‘SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLDatactyis_before_migrate_data.mdf’ [...]

Answer Question   |  August 11, 2008  4:03 PM
SQL Server 2000, SQL Server 2005, SQL Server database

Database hanged due to concurrence
Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration issue? What should we check [...]

Answer Question   |  August 11, 2008  5:40 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003

Advantages of SQL Server 2005 over SQL Server 2000
What are the benefits of upgrading to SQL Server 2005 from SQL Server 2000?

Answer Question   |  December 11, 2010  4:14 PM
SQL Server 2000, SQL Server 2005, SQL Server upgrades

Error accessing Oracle data using SQL job
I have a DTS package that use the MS OLE DB provider for Oracle. The DTS package executes stand alone; but when placed in a schedule job, it won’t run. This was working; but quit after I had detached some databases to copy them. After re-attaching them, the jobs would no longer run. I have [...]

Answer Question   |  September 9, 2008  4:11 PM
DTS Package Scheduled Task, OLE DB, Oracle 7, SQL Server 2000