I am going to set up SQL Server 2005 evaluation (enterprise version) to test
an application that uses 2005 standard version. Will I be able to export my
data from the enterprise evaluation and import it into the standard version
when my purchase order goes through?

I installed SQL Server Experess edition initially. After I uninstalled
Express I tried to install the Developer edition. The install is failing for
Notification Services, Integration Services and Client Components (or
Workstation Components). Each fails with the message:

What I'd like to do is download Enterprise Manager or something close, to
access and maniplate a remote SQL Server 2000 database.
I'm familiar with those tools. but for the life of me I can't figure out
what to download. I don't need to install a database on my PC. It seems like

Why is it MS SQL Server does not have a feature to backup a database
including data to a SQL script? All other major databases can do this.
Can someone reccommend a third party tool to do this?
Thanks in advance.

Is it mandatory to install SQL Server under domain user, I can't install
under local system account? When I tried to install under local system it
gave me access error but I installed under a user which has administrative
privileged it installed perfectly, now the question is if ...

Can anyone provide me Step by Setp SQL Server 2005 installation url
Thanks

we have a MS SQL Server Express database that runs on a remote computer.
When i try to create a backup the backup file is written to the remote
computer.
Is it possible to create a backup and write the file to my local computer? I

Hi experts,
I am working on SQL server 2005 reporting services and i am getting a
problem in writting a query.
Situation is given below.

just tried to install the SQL Server Developer Edition on my PC.
But I coulnd't install the Tools on CD2, because the setup says:
"None of the selected features can be installed or upgraded. Setup cannot
proceed since no effective change is being made to the machine. To continue,

I have a .Net 2.0 windows app that connects to a SQL Express
DB.
I have 2 Clients using it fine. It accesses stored procs to
update data.

In the statement(s) below I'm trying query out 'amount' values that are less
than zero (amount > 0) but I can't actually use 'amount' as it isn't
actually a column. So, how would I go about it?
select

I am installing SQL Server 2005 side by side installation, I already have
SQL Server 2000, it gave me an error when it reached to SQL Server Database
Services.
Here is the error

I am trying to create multiple endpoints for mutiple database that has
service broker enabled. It allows me to create only one endpoint for
service broker then i get the following error:
Msg 7862, Level 16, State 1, Line 1

Dear Experts.
I have a SQL Server 2000 on my production machine and contains 31 databases,
one of the database contain most critical information, now our organization
wants that database should be encrypted, just because of that I am going to

In Symmetric Keys which ALGORITHM is more secure like TRIPLE_DES.....
Thanks