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

truncate table #tablename

Your problem now may still be permissions, but share permissions, not file permissions.  We had an issue with a new hire accessing our VSS.  He had permissions to the file,...

Is it me, or does it appear that you haven't found someone that truely fits with this company?

Using 2005, you could also use per-to-peer replication to keep both databases in sync.

The problem may not be the table, but the query you are running.  If you could post the DDL for the table, some sample data, and your query; we could...

If you are trying to restore a database from SQL Server 2005 Express to SQL Server 2000, you are trying to restore from a newer version of SQL to an...

Try this:

dateadd (DW,2-Datepart(dw,getdate()),getdate())

Also you can use SET DATEFIRST 1 to set Monday as the first day of the week, and then your function would work.

Only time I have had an 'Ambiguous column error' was when I forgot to specify the table name or use a table alias in the query.  When ever I have...

I have set the default locations on both SQL 2000 and SQL 2005 that way, and any databases I create through EM or SSMS have been created accordingly.  The only...

Pull up the properties for your database.  Go to the Database Settings tab.  There you will find a section: Database default locations.  That is where you set the default locations...

Opps.  I meant the propereties for your server, not your database.

First, I would rewrite the query using the ANSI standard join syntax:

SELECT name

FROM

    sysobjects

    inner join OurSysTables

        on (name = Name)

Second, I would also rewrite the query as such:

SQL 2000...

Try update shop set TasksCompleted = isnull(TasksCompleted,'')+'3,' where ShopNo = '25'

I'm sure there are other ways to do this as well.

Also, what is the data type for q.question?