Hi scking,
quote:
I've recently created a SQL Server 2000 database which allows changes to some of the tables but not others. The public role is set to allow changes to all the tables. Any assistance would be appreciated.
just out of curiosity, what are you doing this for?
Are temporary tables an alternative?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]