October 9, 2002 at 7:29 am
I have a table with 50 fields in it. Most of
the fields are check boxes flags and details info about a transaction, the problem is that for some reason I can't open the table,
select or even truncate it. does anyone know what might be the problem, the application works and query fines form those tables
October 9, 2002 at 7:33 am
What do you mean you can't open the table? What is the specific error you get when you try to truncate the table? If a select, insert, and update commands, seem to work, but you can't issue a truncate, possibly you don't have the necessary rights. Are you in any of these roles sysadmin ,db_owner or db_ddladmin. If not this might be why you can't truncate the table.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
October 9, 2002 at 7:51 am
Are you logged on as the same user that your application uses? Maybe you don't have permissions to it.
Who is the owner of the table?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply