Yes on a clustered index an index scan is a table scan as it is scan of the leaf level which is the table data. i.e it does not traverse...

Sorry think i miss read your question.

The index would be traversed using the values of using the values of ID1 & ID2 and when it reached the leaf level it...

IN SQL Server the table data is stored at the leaf level of the clustered index. So scenario 1 would be correct.

hth

David

ps from BOL a better description

In SQL Server, indexes...

There are few things you need to be aware of with SSIS before applying service pack 1. The way dates are treated has changed and the service mat not start applying...

A lot these options can be set when the connection to the database is created and will overide the deafult options set on the database

You want to check the connection...

If you check your database options you'll probably find you've got quoted identifiers on try this

CREATE

PROCEDURE [dbo].[DeleteWord]

(

@WordLength...

I was at the site today and ran the query on the actual box and it worked so am really not sure whats going on but heh life's no fun...

Thanks for the reply I thought they were but I don't use distributed transactions much.

Its just strange because the same query will run fine locally and if i take out...

My company uses apex's sql doc which is OK depending on what you want

http://apexsql.com/sql_tools_doc.asp

hth

David

Are you trying to open the dts packages in sql server management studio and its throwing an error? If so have you installed the Microsoft SQL Server 2000 DTS Designer...

Try this

Alter Database [BD Prueba HYD]

Modify File (name=Apodaca_HYD_Data, NEWNAME=BD_Prueba_HYD_Data)

I doubt it likes the spaces in the database name

hth

David

Personally I'd use the undocumented stored procedure sp_msforeachdb

this is a link which explains it use http://www.transactsql.com/html/sp_MSforeachdb.html

there are also procedure called sp_msforeachtable which can be very useful

hth

David

I'm making a few assumptions here but i assume you are using integrated authentication and the data source you are trying to connect to is remote from from the server...

I have been using domain logins with no admin privilges at all on my sql server 2005 development box and this seems to have no draw backs at all. It...

If you are using the developer, express or evaluation editions you have to enable network access it is not enabled by default on those editions anymore. You can do this...