thank you Paul and Bhuvnesh.

The results for this are same when executed from any database. So sp_msforeachdb may not be the choice for me

Actually this was what I was...

Thank You George, but I was using this because it also restores logs that follow the full backups. but the problem was that if the folder had older full backups...

actually, i was using this script to restore a full backup and getting the results to a table. however it restores only latest full backup from a folder. so if...

in that case I would like to try creating warm standby database. Please help with the script to restore logs in sequence.

Just fyi - there are breaks for the...

there might have been a reason for that requirement, I was told once but I dont recollect. Sorry for that. Will try to find out.

Regarding "without writing or designing it...

yes George, this is part of DR, and its for restoring logs and also full backups. Regarding restoring the full backup part, I'm not too sure why.

Thank You Steve, but...

sure, the reason for the custom log shipping is that theres no two way trust between domains. So we pull files by ftp from our domain which is trusted by...

hi Bhuvnesh. Thank you.. I also need to apply the transaction logs that follow the full backup too. i.e after 8pm full backup I may need another job to restore...

yes custom log shipping, has to be that way

thank you for the help guys. Also the article was informative

I'm getting it now. I had doubts regarding this.

But still, one more clarification - when it is said that when clustered index is traversed to the leaf level, the...

yes now Windows uses HTTP.SYS and we could do without IIS. I checked the virtual directory names they havent been used by IIS. So I was wondering if there might...

This is what i was trying. sorry if im wrong. I wanted to use a cursor and add the stored procedures in between.

Declare cursor_fetchrevlogin cursor

For

select name, * from syslogins

where isntgroup=0

and...

sorry for not being clear enough. i need to automate the sp_help_revlogin and get the output into a folder all through a job(s). That includes getting just sql logins as...

Thank you, but how do i get just the sql logins in the output? i dont need the other logins in the output because i need to automate it