Ok, can you post the results of sp_spaceused for this table? And... Are you setting updateusage = TRUE?

Thanks,

Jared

Ok, and I assume that this is partitioned on month with the date field? (you mentioned a total of 12 file groups) Also, for my knowledge, where exactly are you...

With tens of millions of rows... What is the data type for the column of your clustered index? Is it identity insert?

Thanks,

Jared

Hehehe... Good luck! You'll get faster and more accurate help here 🙂

Jared

Are these tables located on the PRIMARY partition? Also, what is the autogrowth set at for the file? Lastly, what recovery model? And, just for S&G... Collation?

Thanks,

Jared

Just to clarify... The securables for dbo are missing on the production server?

Thanks,

Jared

How were your databases put onto the dev machine? Were any of the system databases restored from production?

Thanks,

Jared

Also take a look at this:

http://stackoverflow.com/questions/1709150/permission-required-to-view-list-of-tables-in-management-studio

The main point of this article is that DENY will always override a GRANT...

Thanks,

Jared

Try this link to see if it helps you:

http://www.techrepublic.com/blog/datacenter/reviewing-sql-server-permissions/466

Thanks,

Jared

Open the Security -> Server Roles folder and double-click on public. The default is "Grant" for "Connect" on all securables. That is it (1 box checked for each securable)....

george sibbald (9/26/2011)

---

definitely get rid of one of the log files after the restore, having two is of no use at all.

And as perry said, 1 terrabyte log, wow!

And you...

What exactly is a "normal user?" Can you please provide exact permissions for the user he tried to set up? Don't forget there is a public server role and a...

Hi,

I'm not sure what you mean by "set up as dbo on msdb" as there are specific permissions associated with the user that need to be adjusted. My guess...

So I think part of this "take home message" from both of you is that the following:

CREATE TABLE #TEMP (id INT, fruit VARCHAR(20))

INSERT INTO #TEMP

SELECT 3 AS id,'apple' AS fruit

UNION...

Maybe a better way for me to phrase the question is this: "Is the ORDER BY clause ignored in the ORDER of the result set of a view and only...