I suspect this might be to do with SET QUOTED IDENTIFIER.  Have a look at that topic in Books Online, then try altering your procedure so as to remove the...

Please post your query, some DDL, sample data and expected results.  It's much easier for us to solve if you do that than it is if we have to try...

Do you have the /3GB and /PAE switches in your boot.ini file?  Is your reporting server a dedicated SQL Server, or does it also do anything else?

John

Before you use locking hints or change the transaction isolation level, make sure you understand the implications of what you are doing.

Another road you may want to go down is...

I think I'm right in saying that this was true in SQL Server 7.0, but not 2000.  You can now use Enterprise Manager or the SQL Server Service Manager to...

Jeff

The dtsrun command is what you need for the first point.  It's a command-line utility so you don't need to call it from a stored procedure - you can use...

George

You can use the OPENROWSET function to run a query against the Excel sheet, and then dump the results in the temp table.  The syntax for using the Jet OLE...

Michael

You use the Jet OLE DB driver.  See the topic "OLE DB Provider for Jet" in Books Online.

John

OPENROWSET is indeed what I meant.  You're right, the syntax is messy, and that's why it's best to use linked servers if you have sufficient access to add one.  From...

I'm sure the 16GB /3GB issue is documented in lots of other places, but this is the first one I found:

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

John

Hemant

Happy to help.  As for table variables, they do have a slightly different behaviour on the surface, but underneath they do the same thing: they are created in memory but moved...

USE master

SELECT name FROM syslogins WHERE sysadmin = 1

John

Hemant

OK, thanks.  I was correct in my supposition, as you have clarified in point 2.

Just one piece of advice: go with what works the best.  Don't discount temp tables just...

Mo

It stands for Data Definition language.  Please read the following two articles, which are useful to first-time posters:

http://www.sqlservercentral.com/columnists/siyer/2645.asp, which contains a link to http://www.aspfaq.com/etiquette.asp?id=5006

John

Mo

This is just a guess because you haven't provided any table DDL.  Why are there separate tables for customers and addresses?

SELECT c.custname, a.address1, a.address2, a.address, a.postcode

FROM waddressses a JOIN wcustomers...