Check the properties on the user databases, specifically on the Options page, under Stat: Restrict Access.  If this is set to RESTRICTED_USER, that will explain why he can't access the...

Index tuning is an art, not a science.  A cursory look at your example indexes, however, would have me dropping the single column index on column a has you have...

I double checked the properties on the server, it specificially says: SQL Server 2005 Embedded Edition.  Has anyone else installed the 64-bit version of Windows SharePoint Services using the provided...

Not necessarily.  The difference is that the first query has a function being used on the left side of the >= where as the second doesn't.  The query engine is...

Actually, problem with the screen I was using.  On my computer I can see it all.  Looks like I need to replace some hardware at home.

While installing SQL Server 2005 Developer Edition on one of our development servers, I ran into issues applying SP 1.  SSIS would not start after applying the service pack.  In...

Based on your test table, there both queries will do a table scan.  There are no indexes defined on dbo.TestPerformance, so SQL will have no choice but to scan the...

I don't see any problem with recertifying periodically.  It ensures that individuals still have the necessary and relevent skills for the certification.

As both a USSF and HSSO certified Referee, I...

Congrats to SSC for reaching the 400,000 members mark!  It is a tribute to support and guidance that its members provide to each other.  I have found answers to many...

I have found the problem and have corrected it.  Turns out SSIS was trying to phone home due to changes in the Cyrpto providers (or something to that effect) and...

Just for the heck of it, change the LEFT OUTER JOIN's to INNER JOIN's in the query Lowell gave you.

The following is based on the original post, give it a try:

create table dbo.Part (

    PartId char(2),

    QtyBreak smallint,

    Price money

)

go

insert into dbo.Part (PartId, QtyBreak, Price) values ('p1',100, 5.00)

insert into...

I have a possible suggestion for a change in your process, but I need to have one question answered first: Is it possible for a CLOSED invoice to be REOPENED?

Sounds like a permissions issue with the directory or the share.

Have you tried dropping the the distinct from the derived table?