both standard edition

Hi

I run sql server 2005 and ssms 2005.

Hope you can help!

Thanks

DBCC CHECKDB

WITH NO_INFOMSGS, ALL_ERRORMSGS.

This compelted with no issues reported. It simply states Command(s) completed successfully.

After running dbbc checkdb the following was displayed:

DBCC results for 'APOLLO'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker...

hi

The permission issue only arose when trying to open the table via right click.

I had no problem access the tables via queries but since recreating them with different names there...

Hi

The query will return the top 100 and also a select all query reports back data with no issue.

Out of interest, if it had not returned the top 100 rows...

Hello,

The table name is tbl_merchandising_profiles_merlive.

This has on average 1.2 to 1.3 miliion rows.

I open this table by right clicking on the table and selecting open table.

The table has 7 columns.

There...