Stephanie,

I figured this can be done by passing only the column value as a parameter to the sub-report and in the sub-report, modify the default values of the row parameter...

Thanks for the info, Is there an easier way to transfer the Server logins ? Also, im not sure about the compatibility of my application databases with SQL 2008. So...

Hi,

When i changed it to hours, It does not delete files older than that. For example. I set the files to get deleted after 51 hours. I wanted only 2...

Thanks Jeffrey for such a detailed explanantion. I got it now.

One last thing. I would like to know the exact duration of my backups or how long the...

Hi,

Why would it not qualify if the job runs for a short time ? How do I check how long the job took to run ? Sorry for...

Hi Jamie

Thanks for your reply. Sorry for being so dumb but why 72+6 ?

Thank you all for your views. They are of a great help to my understanding.

Thanks.

ok. is there a way to see the queries for those transactions? Like the textdata column while running a trace in sql server profiler ?

Thanks

Thank you all for your inputs.

I managed to get a file by querying the default trace. But, I find that the default trace contains only the transaction ids and...

thanks for all your replies. I was able to get it from the default trace. But, i did a restart of SQL server after the emergency occured. So, the default...

ok i think i got that part. thanks ..

my d/b is currently in simple recovery mode and we have a full backup every night. 10 MB is the size of...

Thank You all for your help. Based on all your views, I see that my current transaction log is 10 MB. So, would that mean, one transactional log backup would...

Thanks Jack

Hi Could you please elaborate on CU's and service packs?

Thanks

Shruti

Thanks Micheal for the help.

I understood how setting permissions work in Report Manager. I was right till setting specific roles to people from Properties->Security->Edit Item Security->New Role Assignment. But...