DavidB (2/13/2009)

---

My guess is that this is due to the way the sp_MSForeachdb actually works in that it runs the statement in the database then moves on with each statement...

Please find attachments to see outputs

hi,

i m doing things as follows...

1 open MS excel sheet

2 Go to Data > new database query > selecting edit query > adding my query over there

3 Save sheet.

By doing...

thanks a lot dude it worked.

Also 1 login details needed plz help me out if you can..

plz see

http://www.sqlservercentral.com/Forums/Topic652710-146-1.aspx

actually i am not so good at writing queries having cursors or multiple joins..

i will appreciate if any1 can write for me and help me out.

thanks !!!!

Greg Charles (2/9/2009)

---

I don't have a script, but I can tell you that you'll find most, if not all, the data you want in two views in msdb: backupfile and...

thanks!!!!!!

but i want to gather information in single shot in order to import in excel sheet..

those views and system tables as well as spz,give me all d details but its...

Does this Logs remote locations also??

hey thanks a lotttttttt yar..

i was searching for long for such kind of system table

Please do reply over here..that after changing model to...

You can use stopat clause..

you can see syntax and details in help

type restore database and press cntrl+shift+f2

you can see details over there.

is RPC In and RPC Out options checked in advanced option??

If Parameter sniffing is the real problem then go through following link and do understand it...

it will help u to take out of it...

http://omnibuzz-sql.blogspot.com/2006/11/parameter-sniffing-stored-procedures.html

thanks philip ur query worked

thanks all...

yes this is d Q. from one vague client...

i almost beacame bald after thinking .....