Should I run DBCC Checkdb before that?

This database is used for BI purpose.

Thanks for the help. I will test it.

I am doing the rebuild process once only.

If I don't drop the views and indexes which are schema bound to table,

Will that affect my insert statements on table?

I got the point that while insert we should drop and recreate the indexes.

But we are not rebuilding indexes on "table".

Here the schema bound views and its indexes are rebuild...

you can set at database level by right clicking-->Options-->Ansi Warning

Check the status in select * from sys.databases.

Thanks for the quick help.

🙂

Thanks For the reply.

But when I remove compression how much space it will consume.

Anyway to calculate the space?

Thanks.

I am going to create missing indexes on the server.

ok. Thanks for the reply.

Will do the same as there is no other option.

Thanks Steve

I have granted sa rights and it worked. 🙂

Issue resolved after changing the reporting service account to domain account

http://support.microsoft.com/?kbid=842423

Getting same sort of issue. Below is the error.

Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.”

Scott,

Going for the same version from enterprise to standard.

Yes , I will check the enterprise features used in current databases.

Correct. I faced the same issues. Also increase the size of dbname variable.

Hi please find attachement.

In picture Part.1 shows result of your query. & Part.2 shows result of my query