Right,

Because in sql server 2000 the jobs are "attached" to a servername to allow multiple instances.

You can script out all jobs, or you can adjust originating_server in msdb.dbo.sysjobs

rewrite as

docmd.setwarnings false

docmd.openquery "xxx"

docmd.openquery "xxx"

docmd.setwarnings true

Welcome.

I'm having trouble seeing your pictures.

If the sql server is the default instance, the servername is likely to be your hostname.

What connectionstring are you using?

Is this using the Access upsizing...

Have a look at

*sql 2000

http://msdn2.microsoft.com/en-us/library/6ksc0a82.aspx

*sql 2005

http://msdn2.microsoft.com/en-us/library/s0fk6z6e.aspx

you better rename the sql server also

Renaming:

sp_dropserver 'old_name'

go

sp_addserver 'new_name', 'local'

go  

+ restart sql server

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B303774

Is this using an Oracle stored procedure?

I'm curious as well.

*I have to try this one out

http://objectsharp.com/blogs/matt/archive/2005/06/13/2221.aspx

The wizard has an option keep existing indexes.

You may set it to off and view the changes/proposals.

Can you elaborate

I get a good resultset but the problem is 'm databinding using a datalist.After binding i don't get the fields k_seas_avail.DescID,seas_id,season,twin set correcty i only the values for...

Indexes are only uses when the time using the index + looking up the linked records takes less time than a table scan (where one can read bigger chunks).

One decisive...

This site has a tutorial for sql server administration;

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=177

Do you plan to use a gui (SQL server enterprise manager)  to manage the database/users or via T-SQL statements (query analyzer ...)

*adding users/roles

http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp

*The books...

You could install sql server express 2005 http://msdn.microsoft.com/sql/express/

The documentation you can download at

http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

With this tool you can manage the express database

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

if you need to test specific...

*One way could be with setting permission based on an application role

in query analyzer they will need

to execute sp_setapprole on the connection

*you have the

APP_NAME ( )  function  that...

Are there any char/varchar columns in the table?

If you generate the create table scripts for both tables, it is an exact match (except for the indexes)?

The cost% is to be taken with a grain of salt.

Table scan, index scan... generally give a better indication.Usually the query with the fewest reads will be faster.

What was the...

Welcome.

Have a look at

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

Performance is mostly based on the amount of reads (I/O) and then cpu/duration.

If possible avoid the use of cursors(very important),record by record based solutions and use...