Hmm, the image doesn't show up.

Can you post your report sql + table definitions & some sample data?

*calling a stored procedure from asp

http://support.microsoft.com/kb/q164485/

*creating a stored procedure

CREATE PRODECURE dbo.USP_MY_PROCEDURE

(@Param1 as...

server: =mssql10.oneandone.co.uk

login id = dbo152591563

password= dbo152591563's password

Can you verify through the admintool that the user dbo152591563 can login?

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)?