When exactly are you getting this warning..?

If yu just want to know how to create cursor, it's simple.

You can easily get...

Thank you all. Doubt is cleared.

Thank you very much.

Thank you all. Doubt is cleared.

Thank you very much.

Thank you all. Doubt is cleared.

Thank you very much.

Ok. By the way, why do we need to detach the DB for taking abckup.? What's the advantage.?

Not sure, I don't think so..

Add a maintenance plan. A job will be automatically created and you can schedule it.

Yeah... That was wot my doubt. I had heard abt cold backups long back. But in SQL server 2005 I have never come across it anywhere. Asked in an interview.

Hi,

Thanks for the quick response.

Yes..I had searched in google as well.

Thought someone will brief it here so that I can easily understand.

Thanks.

Good question. Though it's simple, was not sure if it's implicit or explicit.

Yes..use profiler. Probably you can collect the data for week's time. Save the files seperately for each day. Then you can create temporary table with the columns you had in...

Dear All,

Couldn't find many solution in Google. Went for a toss.

I solved the issue by reinstalling the Integration Services once again. It worked.

Thanks.

Thanks Gila.

There's no backup. Infact I had configured it day before only.

I reconfigured it again today. Now log shipping is working. Just wanted to know if there's any way to...

any other details given..? particular file name or something like that.?