SQL Server 2000

SQL Server 2000/2005 Transaction Logs

Quick Ques. Are transaction logs cummulative? If I have a database set to Full recovery mode; database being backed once a day and transaction logs being backed up hourly, if the database needs to be restored, can I just restore the last transaction log file? Will the last transaction log file...

Manually migrating databases from SQL Server 2000 to SQL Server 2005

I am manually migrating a large number of databases from SQL Server 2000 to SQL Server 2005. What kind of issues should I expect, and do you have any readily available solutions?

Installing SQL Server 2000 on Microsoft Windows XP

I am attempting to install SQL Server 2000 on Microsoft Windows XP, but I keep receiving this error message: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system." What steps can I take to get rid of this message?

Common User Interface SQL Serve Management Console

Does anyone know a way to standardize the SQL Serve Management Console so that all of the DBAs will see the same list of servers as we used to have in the SQL 2000 Enterprise Manager?

Backing up a SQL Server 2005 database on SQL Server 2000 EE

I have created a large database in SQL Server 2005 Developers Edition, and I intend to put my backup on SQL Server 2000 Enterprise Edition. Is there an easy way to go about this procedure?

Impact on TSM backups after an upgrade to SQL Server 2005

What would the impact be on TSM backups if I undertook a side by side upgrade of SQL Server 2000 SP4 to SQL Server 2005 SP2?

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...

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.

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...

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 something that...

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 ...

sql 2008 system tray icon

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

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

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?

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 proceed?

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.

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 in SQL SERVER 2000.

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.

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 guidance on how to proceed?

Reindex DBF file from Ms-SQL 2000

Is it possible to reindex an extenal dbf file via linked server ?