Hum....

I rename the file with success but it is not what i was thinking....

Instead of renaming the original file this command creates a copy of the original with the new...

It had to be in a single line!

Problem solved with Lowel suggestion.

Thank you very much for the help.

"carriage return character" sorry, what's that? (My english is not very good)

I made as you told me to:

declare @cmd as varchar(8000)

...

When i run the t-sql, it gives me backup a table with a column named output.

This grid as two rows.

The firts says : The syntax of the command is incorrect.

The...

I need to do it in t-sql.

When you say that i can configure AWE, do you mean configure it at OS level or at SQL Server level? AWE is a parameter of the OS or...

Other possibility that i have is to change the OS of the server to windows 2k8 64 bits and install on it SQL Server 2005 64 bits, then , install...

Why don't you think that it's good ideia to install SQL Server 2000 32 bits on a Windows 2k3 64 bits?

I think that it's more secure to install w2k3 64 bits and SQL Server 2005 64 bits and SQL Server 2000 32 bits.

With w2k3 64 the Os will see the...

Ok, in that case i think that the better thing to do is install w2k3 64 bits and SQL Server 2005 64 bits and SQL Server 2000.

So, you are saying that i can install SQL Server 2000 (with sp4) on an windows 2k8 64 bits but, because SQL Server 2000 exists only in 32 bits version...

Ok.

So, for me to have SQL Server capable of using all memory available on the server i just need to change my OS (w2k3) from 32 bits to 64 bits...

hum...

Even if i install an 64 bits OS and SQL Server 2005 64 Bits, still i need to configure AWE?