Can you post more details on the error that you are receiving.

sigh, I can only agree with what Gail has said, you need to put the database in single user, run dbcc checkdb with the option that gail specified and see...

Thought the issue might be...

The commands you can use for dependencies are

sp_depends

sys.dm_sql_referencing_entities

sys.dm_sql_referenced_entities

If you look these up in BOL, it will give you more information

yeah, i couldnt see anything wrong with it either

litu deb (10/1/2009)

---

If i use dbcc shirinkfile(<file id>,truncateonly) in production hour

Would it affect on any performance..If yes tell me any other way so that i can shrink data...

krypto69 (9/30/2009)

---

This is for ad-hoc reporting and is one big 'flat table'.

So, I never know what fields they could pick, they could pick any or all of the 400 columns.

Long...

krypto69 (9/30/2009)

---

I have a report table I need indexes on (non clustered) already have clustered.

My problem is that this table has over 400 fields, I really don't want to manually...

could be a number of reasons,...

As mentioned before, I would create the document yourself, better that way if you have the time.

What version of report builder are you using

http://msdn.microsoft.com/en-us/library/aa337239(SQL.90).aspx

Apart from the usual microsoft help. in your case I would create your own, just create a few reports and screen shot it,...

Not entirely sure I agree with generalisations being made. That is like saying. Every man is a potential rapist.

Sterotyping by generation is still making judgements about groups of people. I...

Maybe the table didnt exist at the time that the backup was taken.

hmm interesting,

I had a sql login called test, added it as a user to msdb, added it to the sqlagentoperator role and it can view the jobs and edit the...

Take the query out of the job and run it manually using an elevated account that has permissions to where the file is located.