update...

Here is what i found. I tried starting maangement studio using the service account which is the one that has problem and it could pretty much do every thing...

I am use my own id asa a sysadmin i can do this without any problems but this problem is only for service account id which is also a sysadmin...

I checked everything mentined above but it is still not working for me. Its not just one server but it is reacting the same for 3 2008 servers, very weired,...

I still could not solve this problem, this is happening only on SQL 2008 servers, any reason?

SELECT IS_SRVROLEMEMBER('sysadmin');--this query gives nothing to me

SELECT * FROM fn_my_permissions(NULL, 'SERVER');--this query returns 0

I...

yes, i can run the script but can not make same changes using GUI.

This sounds like an issue with MS which persists when i checked one of ther site.

Actually i have a question here.

1. can i do union all of 2 tables and left join to 3rd table in the same query?

2. When i am doing a...

can some one help me with the code, i want make it work 1st then i can look ofr better performance.

you are correct the code didnt work for me but i just wanted to through out the logic that union of 2 tables should have left join with 3rd table...

ok ,good. that what i needed so that it uses disk equally on 3 disks but i have a concern here, i always keep 20% of free space on each...

ok never mind, i think it works.

it gives "1" I am an admin for sure because i do all kinds of admin stuff . any further help?

But i i am doing the same on SQL 2005 from the past 3 years without any issues, why only in SQL 2008

yes, ia m on the right server and i am sysadmin on that machine, this is killing me.

everything looks normal in the error logs except this message which i think is informational.

SQL Server has encountered 2 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of...

i works fien when i restore from qry analyser but the script if i run from the job it says "Processes could not be ended:" and says pages processed. but...