dbcc checkdb

sql newb on the block, how can i run this checkdb command.
2. recently started experiencing a problem where we could add new records
but could not edit or update changes in the records. any help would be
greatly appreciated.Take a look at:
http://msdn.microsoft.com/library/d...
0gy.asp
Sounds like you have been granted permissions to perform INSERT but not
UPDATE or DELETE. I would check the permissions for the database user
account in Enterprise Manager for the table.
HTH
Jerry
"mmin18" <mmin18@.discussions.microsoft.com> wrote in message
news:60B0B94E-6F06-44C6-B8D6-B0C99137C286@.microsoft.com...
> sql newb on the block, how can i run this checkdb command.
> 2. recently started experiencing a problem where we could add new records
> but could not edit or update changes in the records. any help would be
> greatly appreciated.|||thanks for posting, i have seen that link, however it does not tell me
where or how to run that script.
I have checked the permisions on that table and they have update and delete.
"Jerry Spivey" wrote:

> Take a look at:
> http://msdn.microsoft.com/library/d...r />
_00gy.asp
> Sounds like you have been granted permissions to perform INSERT but not
> UPDATE or DELETE. I would check the permissions for the database user
> account in Enterprise Manager for the table.
> HTH
> Jerry
> "mmin18" <mmin18@.discussions.microsoft.com> wrote in message
> news:60B0B94E-6F06-44C6-B8D6-B0C99137C286@.microsoft.com...
>
>|||Hi,
(Send us the error you are getting while updating and deleting)
Try to create a new table and give the below prev.
GRANT ALL ON <newtable> to username
After that try insert, update and delete. Send us the error if you get any.
Thanks
Hari
SQL Server MVP
"mmin18" <mmin18@.discussions.microsoft.com> wrote in message
news:0517F3CD-AE10-450B-A4CB-3371B5B04638@.microsoft.com...
> thanks for posting, i have seen that link, however it does not tell me
> where or how to run that script.
> I have checked the permisions on that table and they have update and
> delete.
> "Jerry Spivey" wrote:
>|||To add on to my old post; execute a DBCC CHECKDB to ensure that your
database error free. Just execute
DBCC CHECKDB('dbname')
Thanks
hari
SQL Server MVP
"mmin18" <mmin18@.discussions.microsoft.com> wrote in message
news:60B0B94E-6F06-44C6-B8D6-B0C99137C286@.microsoft.com...
> sql newb on the block, how can i run this checkdb command.
> 2. recently started experiencing a problem where we could add new records
> but could not edit or update changes in the records. any help would be
> greatly appreciated.|||once the new table is entered, how can i test the insert?
"Hari Pra" wrote:

> Hi,
> (Send us the error you are getting while updating and deleting)
> Try to create a new table and give the below prev.
> GRANT ALL ON <newtable> to username
> After that try insert, update and delete. Send us the error if you get any
.
> Thanks
> Hari
> SQL Server MVP
> "mmin18" <mmin18@.discussions.microsoft.com> wrote in message
> news:0517F3CD-AE10-450B-A4CB-3371B5B04638@.microsoft.com...
>
>|||What application are you using to perform edits?
Also, is the inability to edit the new records only a sporatic problem;
perhaps it is an issue with locking?
Displaying Locking Information
http://msdn.microsoft.com/library/d... />
a_0uni.asp
Understanding Locking in SQL Server
http://msdn.microsoft.com/library/d... />
a_7xde.asp
"mmin18" <mmin18@.discussions.microsoft.com> wrote in message
news:60B0B94E-6F06-44C6-B8D6-B0C99137C286@.microsoft.com...
> sql newb on the block, how can i run this checkdb command.
> 2. recently started experiencing a problem where we could add new records
> but could not edit or update changes in the records. any help would be
> greatly appreciated.|||Just insert the data via Query Analyzer or Enterprise Manager. Also, with
respect to UPDATES and DELETES check to make sure the user account has not
been DENYied access (user or role membership) as a DENY will override a
GRANT.
HTH
Jerry
"mmin18" <mmin18@.discussions.microsoft.com> wrote in message
news:27B693E0-8EF9-4478-A97C-6755FFB930B8@.microsoft.com...
> once the new table is entered, how can i test the insert?
> "Hari Pra" wrote:
>