Query Analyser can only open my tables in read-only mode :(

6 Feb 2006 8:11 AM

Steve Terepin

I've got a database on my local machine whose tables come up as 'read-only'
when I open them using Query Analyser - although when I open these same
tables in Visual Studio or Enterprise Manager, they are NOT flagged as
'read-only'. The database is a copy of one from another server, created
using backup/restore. I've made sure to give myself appropriate permissions
- at least, I think I've got this right because I can certainly edit the
data in Visual Studio. It's just Query Analyser that's causing problems. Any
ideas about what's going on ?

Thanks,

Steve.

6 Feb 2006 11:33 PM

Erland Sommarskog

Steve Terepin (steve.terepin@accuratesoftwareNoSpam.com) writes:

> I've got a database on my local machine whose tables come up as
> 'read-only' when I open them using Query Analyser - although when I open
> these same tables in Visual Studio or Enterprise Manager, they are NOT
> flagged as 'read-only'. The database is a copy of one from another
> server, created using backup/restore. I've made sure to give myself
> appropriate permissions - at least, I think I've got this right because
> I can certainly edit the data in Visual Studio. It's just Query Analyser
> that's causing problems. Any ideas about what's going on ?

Does the table have a primary key?

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx