One of these should get you going down the right track.

if OBJECT_ID('tempdb..#Documents') IS NOT NULL DROP TABLE #Documents;

CREATE TABLE #Documents (document_id int PRIMARY KEY CLUSTERED);

INSERT INTO #Documents

SELECT 1 UNION ALL

SELECT...

This type of issue was recently solved on this forum. Please try this solution, and see if this solves it for you also.

Please let us know how this works for...

Donalith (10/13/2010)

---

Is there a faster way to get the Top 1000 rows sorted on

ORDER BY COALESCE(<possible null field>,1) DESC

The plan shows that this sort is taking up 86% of my...

Looks like you're making things more difficult than necessary Lowell! ;-):w00t:

You're welcome.

Does it solve your issue?

Did you try the things suggestion on this other post you made on this same issue?

Did you try running this code?

CREATE TABLE Test1(

empno int,

MatchingOff varchar(10),

atnDate datetime

)

SET IDENTITY_INSERT mytable ON

Insert into TestTable(empno,MatchingOff,atnDate)

There are 3 different tables referenced here... and it looks like the IDENTITY INSERT isn't...

I've never seen that happen.

If you can get desktop access to the computer that houses the Excel file, you can see who/what has the file open.

Sure, why wouldn't it? You might need to change your stored procedure/query around a bit to work with multiple values, but it wouldn't be a big deal.

I...

CozyRoc (10/13/2010)

---

This is the important part:

"The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need...

If you look at these two posts, especially the signature, and that these are the only posts ever from this poster, they feel more like spam for their kitchen cabinets.

harrifolfenced...

GilaMonster (10/14/2010)

---

WayneS (10/13/2010)

---

If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):

TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to...

Have you recently upgraded these databases from SQL 2000?

If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):

TechEd Demo: Using the...

The frequency of the transaction log should be dependent on your service agreement... how much data can you afford to lose, or have to re-enter? On our systems, we have...