Yes, There is a constraint which partioned the data into two tables.

There are two tables Live and Archive, I keep only five years of data in Live table and all...

Thank you all for the reply.

I created lots of partition tables and filegroups and assigned inital size to the filegroups but now all the filegroups are not 100% full...

Thanks for all the reply.

Let me explain again. I have created a partitioned table and the data is stored in the file groups based on the range. Some of the...

Yes, Shrinking the whole database file will be very intensive. Can we shrink particular file group ?

Thanks

Yes, I am going through testing phase. I am doing the same thing what you have mentioned. One more question.

If you noticed that in my last filegroup [FILEGROUP_BTC14] stores...

Yes, You can do that by using following function.

SELECT * FROM fn_my_permissions(null, 'database');

Here what I did.

-- First use database you are looking for.Then run as below

SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0

-- For each returning table name that has the...

This issue is fixed.

It's working if I create a SQL login and give dba access.

I have checked the instance of the Mgmt studio and query analyzer, it's same.

It's really weird. I think users have access but some how management studio is not recognizing...

I gave ddlAdmin access but no help.

User is in the AD group and also have an individual account. do you know which gets the preference. ?

thanks for your quick response.

Access Denied. But when he uses Alter command on query analyzer, he is not getting that error.

Sure, I will try this saturday and see how it goes. Do you think, I should drop to maxdop to 6 or 1.

Thanks for your help.

by the way, I...

Sure, I will consider your advise in future. I think it's not a bad idea to start some kind of web site and help people by charging some money.

It did not say anything other than blocking. Let's say if you cannot connect sql server then how should we trouble shoot the issue. where to look for the issue....