Hi , I got this error on one of my database maintaince plan .i found this error in job history User does not have permission to perform this action....
Hi, I used this script for shrinking database ,but i read somewhere that dont use shrink command if its bigger than 5gb and i dont know what the use...
Hi , DBA's i just want to know that one of our customer want to add services like ssis,ssrs and ssas .but i want to know that on which server they...
Thaxx Luis but will u plz tell me what this stored procedure does .Bcuase i m new in sql server bcuase we cant run again and again this query to...
Hi, How can we see blocked process on sql 2000i have this query but plz tell me is it working fine or not bcuase i am confuse bcuase when ever try to...
Hi, Really thaxx for ur help but i want to see like which is long running query .like we can see in sql 2005 which queries running long bcuase is...
Hi, Can anybody tell how can we see long running queries with tsql i have query for sql 2005 but it doesnt work with 2000. so plz help me Regards...
Hi, How to see all maintainance plan with t-sql thaxxx
Thaxx , Rohit u are right i am want to see last column like u said but i am have tried ur query still there is error come outMsg 156, Level 15, State...
hi, My query is working fine but I just want to know how to change the result like eg,5,4,6 GB i want to see in this format how can we use alias name...
Hi, will u plz tell when i try to run this query in sql 2000 its not working .Because in sql 2000 there is no dmv of sys.processes so will u plz tell...
Hi, can anyone help me to find out which process are idle for more that 20 min with a tsql . Regards
Hi, will u plz tell me in which DMV i can find this in sql 2000 select * from sys.dm_exec_sessions select * from sys.dm_exec_query_statsselect *...
Hi, Hello how can we see the result of this query in single table . I am new with this and i dont know how to use join and all syntax. SELECT...
Hi, can anybody help me that how can we see sql server Health check with t-sql.Because i am trying to make script for this Basically i need these...
Hi , will u plz tell me that how can we see all this details from query or just tell me in which table i can go for these details current Date...
hi, will u plz tell me is there is any query for sql server like in oracle we use statspack to see database stats .plz tell me how can we see...
Hi, I have seen these error on my database will u plz tell me what is this actully i dont know this errors .I am not certain at this stage what has...
problem is that is running nicely on sql 2005 but it cant work with sql 2000 .so plz just solve the prob ???
Separate names with a comma.
