I am considering moving a company's Access App to SQL Server.   I am
confused about what I need to accomplish this in the way of Server Software.
The pricing on the Microsoft website says,
Standard Edition: $2249 with 10 Cals.  The SQL Server would be running on

I am attempting to restore the master database in SQL Server 2000.  However,
I continually receive the message:
"You are attempting to overwrite an existing database.  Check the force
restore over existing database option to overwrite the existing database."

I'm using a Unicode sql script imported using OSQL.  One of the values
we are attempting to insert is a Registry Multi-String value by passing
a string to a stored procedure.  These Multi-String values appear to be
delimited by a Hex 06 (^F) character.  When I import this character,

How can I copy data from a varchar field into an integer field, obviously
copying only the values that can be an integer?
For instance, I have data in a field like this:
1

Hey, all...
Some time ago, I used a tool which I believe was available from Sun. It
was a java applet, as I recall, which sat between a SQL client and a
SQL server. It allowed the client to connect to it at any port, and

When calling multi select statements in a stored procedure how do you set
the namespace to each select statement?
Thanks
Chris

I am creating a plan to upgrade our SQL Serve r2000 servers from SP3 to SP4.  
Is there a service pack for the client as well?  Or do I run SP 4 on my
client installations as well?  Any guidance would be greatly appreciated.
Thanks in advance

I am having trouble with getting a networked computer to find an instance of
the SQL server on my network.

In a datetime field, my app forces users to use the 7/25/2005 10:58:39 AM
format.
If users end up typing in 24-hour times, will it break anything?

I am trying to import data to an SQL Database from Access.  I tried
importing using the Enterprise manager, importing into a project connected
to the Database, and using the Access upsizing wizard.  The Enterprise
Manager gives me this error:

Is Set RowCount @RowCount
More efficient than simply using TOP?
Thanks for any input.

When I declare a cursor,I use a variable to replace the sql statement:
DECLARE rs CURSOR LOCAL FAST_FORWARD FOR
@sqlPlan
But it is not true.Who can correct for me.

Does anyone know where I could find comprehensive information (on the net)
on how to intepret SQL server's execution plans?
For example:
Hatch Match/Left semi join - Cost: 41%;

We are using Month-year tables to keep the history of long transaction
of our application. For example:
We capture the details of a certain action in table
"TransDtls<CurrMonth><CurrYear>" (this month: TransDtls072005).

If the data type of field is "varchar",we can use "like" to query if it has
some substring.
Such as "where custom.valuevariant like '%Verizon%' ", it will query out all
records that contains string "Verizon".