Thanks Gail. Is it necessary to run integrity checks on the databases which are marked read-only? I may be wrong but since the data won't change, I'm assuming DBCC CheckDB...

I believe I could use sp_spaceused but I'm not sure how to put the results in 3 different columns.

Hmmm.. I'm not sure if I could do that since I just have read permissions to the database.

Michael Valentine Jones (8/10/2011)

---

Is it possible that your database is actually a database snapshot?

http://msdn.microsoft.com/en-us/library/ms189940.aspx

"A SELECT statement that is executed on a database snapshot must not specify a FILESTREAM column; otherwise,...

This database had been in read only mode for the last 6 months, so nothing would have changed since then. Not sure, why am I still getting this error.

Yep. it worked. Thanks George.

Thanks Gail.

"Can someone please answer?"--Is it really demanding?? lol...

Anyways, I still love these forums because people are very approachable. Thanks for your answer though.

Hey Ninja, dont get mad or offended for silly things. I just replied to my post because I was hoping it gets noticed by "gurus" like you. "We don't work...

Can someone please reply?

Can someone please help? It's urgent..

So, whenver I've to do Update stats, can I just do 50% sampling instead of fullscan?

Gail, don't you think it becomes really tough to write a query to update statistics if there are 200 columns.

For example: I need to specify 197 columns in the update...

Sorry, I'm not sure...

The server on which the SSIS job runs as well as the server on which the SSIS package was deployed, both are 64-bit servers.

If I find a 32 bit...