You either have to use openrowset or create a linked server to the other server. I prefer creating a linked server because with openrowset, you have to create the connection...

Do you have any account that works and has SA privelages?

Just in case there's some incompatibility that we haven't thought of, I would suggest logging into the SQL Server and recreating the package from scratch and seeing how that works.

Otherwise,...

Actually, there is a shortlink in Enterprise Manager.

If you're already in the db you want to be in, click "Tools" on the menu at the top of the console window...

Use Query Analyzer to run your sp's. It's listed under the SQL Server tools.

Just type in the same SQL command that you would pass in from the ASP page.

Query Analyzer...

The example I did above should return it. It does when I tested it on my server.

Post your sp and let's see.

@@identity would only return the identity for the last record inserted, not for the whol recordset. To do this for a single record:

Create Procedure dbo.TestGuid AS

Declare @MyId int

Insert Into TestTable...

So what are the differences between the two cubes?

We had a similar performance problem caused by excessive locking. Our performance improved 4-fold when we added the with(nolock) optimizer hint to all of our select queries in our sp's.

This...

Perhaps your permissions have changed somehow recently?

Make sure that the owner of the job has SA permissions.

With SP3, they changed the level of permissions required to run xp_cmdshell.

Are you on the same machine as the SQL Server? If not, you need to install SP3 on your...

When SQL Server creates a temp table, it determines what the field sizes and data types should be based on the results of the recordset, not on the fields that...

Yeah using complex dynamic tables will do that to a query.

I think you would see a huge difference if you separated out the dynamic tables into separate queries that you...

Have your sp check for that specific error using @@error and if that error occurs, have it return 0 (success).

There are a lot of little differences between the SQL that Access uses and T-SQL. For example, T-SQL only has RTrim and LTrim, so you will get an error if...