I installed SQL server 2014 enterprise along with SSAS. I forgot to add server admins for SSAS, now it is not letting me make any changes...
Charandeep, but why is it running fine when i run it in query analyzer manually, it fails only when run in SQL Job.
Sorry guys, I was on vacation for a week.
Shehap, I tried that but no use, same error and the same code works fine when run in query analyzer. there...
The job failed again with the same error.
Thank you for the prompt reply. I made the changes but the job is still failing with the same error -
Executed as user: sss\sssss....
I need help with my index rebuild job and update_stats job. they are behavings trangely on a particular server.
The update_stats job...
I have an index rebuilding job (stored proc) that always fails in 2 instances but works fine on all other servers. That too it fails only...
There are many methods available, backup-restore, attach-detach,copy db etc.. go through BOL or msdn sites..
Hi, why don't you use SSIS, it will give you the flexibility of writing a script to map data to columns in different tables...
can anyone please help me to write the query to find the
1)size of a table.
2)no.of users logged in a database at a time.
3)the memory being...
Separate names with a comma.