ANYONE????

Is that really necessary if the new server is getting the same name as the old one?  There are hundreds of Access databases we have.

Okay, I think that fixed it.  I didn't realize that was a separate task.

I'm using v 2005, SP2.  And, why doesn't "Backup Set will expire after 2 days" mean "Backup set will expire after 2 days?"  The screen shot shows there is no...

I have two files, a data and a log file.  What do you mean by "cut and paste" the files?  And why would moving files around hurt things?

The database is...

Does detatching hurt the database on the production server in any way?  I saw the idea about detach/attach, and it sounds like a great way to switch over the system when...

If the seek would be looking for the key, would it not only return one row?

Anyone??  I need assistance and I'm trying to learn SQL Server administration at the same time.  I can't believe that the SQL Server looks at an index, queries the same...

Not sure how to check the connection string; it's a JDBC connected app using the JSQLConnect 4.0 trial version of JDBC.  Is there a setting there I need to check?

I...

It looks to me like the most intensive part of the query plan is this:

exec sp_execute 7, N'001', N'01', N'007207BK         S'

When I go back and look at the prepared SQL...

I used Profiler on both systems and ran the same screen, with the same parameters, on both.  When I sent the vendor the traces and he noticed that for the...

The Collation name is the same for the app databases and master databases in both systems.  For the record, they are:

SQL_Latin1_General_CP1_CI_AS

The screen in question is not using stored procedures in this...

Another question.  On the existing server, the RAID-5 array is the E: drive, and the database is located on E:\Microsoft SQL Server\MSSQL\Data (both trans log and data file)

On the new...

SQL Server is now at 2187.  No difference.

I noticed an index I had created on the existing server that seems to be useless that the execution plan is scanning instead...

MAXDOP didn't help like I thought it would.  Trace still shows index scans against the non-primary key.  The good news is the rowset returned isn't out of order any more.

I didn't...