change home and data directories

I'm planning to establish a recovery plan for my SQLServer 2000
databases. How to change home and data directories?I'm not sure I understand what you mean by 'home and data directories'.
Usually, a DR recovery step includes either restoring the entire OS onto
identical hardware or reinstalling SQL Server. In the latter case, you can
specify the SQL Server installation and file paths.

You can restore from SQL Server database and transaction log backups to the
location of you choice after the server is prepared.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"hazly" <s_hazly@.oritech.com.my> wrote in message
news:1136944906.075848.37120@.z14g2000cwz.googlegro ups.com...
> I'm planning to establish a recovery plan for my SQLServer 2000
> databases. How to change home and data directories?|||The default one can be changed within:

HKLM\Software\microsoft\MSSQLServer\Setup\SQLDataR oot

Is it that what you meant ?

Other location can be obtained here:

http://www.sqldev.net/misc/SQLLocationFunctions.htm

HTH, Jens Suessmeyer.|||Thank you for your reply

change formula thru SQLServer

Hello

how can i adjust formula thru SQLServer?? for example --the computation Gross Salary less Deduction then the total will be for computing of witholdingTax..

thanks pipz..I didn't understand your formula.
Can you give me an example of what you have and what you are trying to get.

change db from sql server 2000 to sqlserver 2005.

how we can change db from sql server 2000 to sqlserver 2005.Jes M George.

Look athttp://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

andhttp://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

With the SQL2005 Standard and Developer installation disks, there is an upgrade advisor package which you should run. This package should be available as a separate download.

sql

Century date conversions

Hi,
I'm trying to load date fields into SQLServer using DTS, but the
format of the raw data is the number of days since 1 Jan 1900. How do
I convert this to a useful format, is there a standard conversion
routine?

Thanks
Timtim.philbrook@.cazenove.com (Helsop) wrote in message news:<1609a822.0408180233.9fbed33@.posting.google.com>...
> Hi,
> I'm trying to load date fields into SQLServer using DTS, but the
> format of the raw data is the number of days since 1 Jan 1900. How do
> I convert this to a useful format, is there a standard conversion
> routine?
> Thanks
> Tim

There are (at least) two possible solutions. First, load the data into
a staging table and clean it up with TSQL, before an INSERT into the
final table:

insert into dbo.Destination
(col1, datetime_column, ...)
select col1, dateadd(dd, numdays_column, '19000101'), ...
from dbo.Staging

Alternatively, if you want to do the transformation in DTS, then you
could use the VBScript DateAdd() function in an ActiveX column
transformation to achieve the same thing.

Simon|||--> use DATEADD(dd,@.OffsetDays,'1 Jan 1900')

DECLARE @.OffsetDays BIGINT
SET @.OffSetDays = 38217
select DATEADD(dd,@.OffsetDays,'1 Jan 1900')

Tx