not much load,there ar elot of temp tables and truncate tables.

delete statements

Hi,

this is good article, my problem is both the servers are having same configuration ,why is it taking

more time on production server,there are no other database exist there

the same...

Hi,

this is good article, my problem is both the servers are having same configuration ,why is it taking

more time on production server,there are no other database exist there

the same...

here what i did is i created an ssis package and it will do backup and tsm,till backup it is working ,tsm part is working manualy executing .what i want...

hi,

could you please let me know how to do that ,i have not worked on that

please give me the code some guidence

whil3 executing manulay all the backusp are moving to tape.when i execute the job ,it take only the backup to harddisk,but not moving the backed up db to tape.code is...

yes,this account is running with admin rights,login is having sys admin rights

thank you,it worked

sorry,didnt get you .

my login name is tech12

how do we give access

hi,

thanks,my code is getting me the result in coupel of instances,onely few instances ,sys.files filename location is stored as case sensitive,that is why it is giving error messge,

is there...

hi,

i need to display which database is not following the correct path,

as per the code i have written it should be that location,what iw ant is it should display if...

hi,

It shows error message,not avilable this SP

thanks,still i ahev soem issues,i think i can correct it

hi,this is working but iam not sure the exact result is coming up.

HI,

I am not getting what i am looking for

What i need is if i execute a qurery in one instance it should display the Database Name and the Cpu...