Thanks for your response carl and Adrian.

Thanks,

SR

Please somebody help me with this.

Thanks,

SR

Thanks a lot for such a quick response Chuck.

Could you please also let me know how do I specify that particular index needs to be created in particular file group...

Hi Melissa,

What is the location of this job requirement?

Thanks,

SR

You can Kill Proccess from QA using KILL method.

KILL SPID(SPID of the proccess)

Thanks,

SR

Hi Adam,

Check if you have owner for all you objects.It prompts this error if you have don't have owner for particualr object .

Thanks,

SR

To script  all jobs in particular server got to enterprise manager ->Management -> sql server agent -> Jobs.

right click on the jobs and go to All tasks->Generate sql script.

Hope this...

Execute the following sql statement in query analyzer

select 'grant select on ' + name + ' To login_name' from sysobjects where xtype='U' or xtype ='V'

Copy ,paste and execute the result...

Thanks a lot for you response.Its very helpful.

Thanks,

SR

You can use following query to get the owner of database.

select name,suser_sname(sid) from Master..sysdatabases

Thanks,

SR

you can use  storeprocedure sp_helprotect to get object and object owner .

Thanks,

SR

Are you using UNC path while specifying the path for a file?

Thanks,

SR

Sorry ,I am not very clear with you question Suresh.You mean to say when you are executing as a sql agent job its failing where as manually from your local...

You can create SQL agent job to run sql file and schedule it to run daily.

Thanks,

SR

I got it.

Thanks a lot John.This is really helpful.

Thanks,

SR