When you're inserting a list of static values you use:

INSERT INTO {columns}

VALUES ( {ValuesList} )

When you're inserting values where some of them are generated from the database, you typically...

I'm currently learning & using Windows Powershell for some SQL admin/maintenance tasks.

Next version of SQL (2008) will supposedly have increased Powershell support.

In your original posting, this was the path:

'Data Source="C:\MyApps\Data_Complete.mdb

So, you'd want to ensure that your SQL Server service account has full read/write access to the folder "C:\MyApps".

You would do that...

CREATE NONCLUSTERED INDEX [IX_TableX_ClientID] ON [dbo].[TableX]

([ClientID], [ColA], [ColB], [ColC])

INCLUDE ([ColD], [ColE])

Might there be a good reason that ColA, ColB, and ColC are part of the index columns or...

>>Let's say the first column or columns of a nonclustered index is unique. Might there be reasons to add additional columns to the index list as opposed to the include...

The answer to this type of question is always "it depends".

For #1, yes, a covering index that includes additional columns may improve some query scenarios by preventing a bookmark lookup.

For...

See yesterday's reply from the OP:

It is "microsoft olap".

I recognize the query (the object name double quoting & old style joins) from having to deal with similar problems in queries...

True or False:

This query was captured as the SQL sent from MS Analysis Services ? As such you have no control over how the SQL is constructed and can't convert...

Why did you need to start a new thread for this ? All the context of your problem is on the original thread.

>>Does this business with permissions still apply with a local copy of SQL Server 2005?

Yep. When you installed SQL Server locally, you were prompted for a service account for...

>>I changed the options for me to "Allow" for all permissions

What about the account that the SQL instance is running under ?

When you run this query, the OpenDataSource() is not...

Next up: File and folder security/permissions.

Calling OpenDataSource() may require that the service account for the SQL instance needs to have access to the folder containing the MDB files. Make the...

Let's get the obvious question out of the way first: Have you verified that the MDB files can be opened by Access 97 after being FTP'ed ? FTP transfer mode...

An int datatype can be given the IDENTITY property and will auto-increment for you.

Is there a technical reason not to use an IDENTITY column in this application ?