Dear Chandru

Thank you for the response.

The Random Id are unique identifier.

Actually, I have a parent item with an unique identifier.

When the parent is revised then the child will have the...

Dear Mark,

Thank you a lot it is working fine.

🙂

Dear Gints,

Thanks for your information.

Dear Friend,

The link is broken and unable to get into the site.

We are in the computer world and telling that it is a bad luck, really this is a bug in your mind.

Either delete it or comment it.

Dear Suresh,

Thanks for your reply.

I will try it.

Best Regards,

M. J. Jaya Chitra

Dear Suresh,

Thanks a lot for your information.

Ok I will try with the enterprise edition.

But is there any other methods available to perform the same through script?

Dear Friend,

Thanks a lot for your information.

I have one more clarification:

Is the enterprise edition of SQL 2005 will support the task scheduling?

Or which edition of SQL 2005 with which service...

Hi Gila,

I have checked the DB and ti was in "Full" recovery modal.

Actually this happens in the production DB in the client place.

Usually we will run the DBCC SHRINKDATABASE script.

Can...

Hi Gila,

Actually, I don't know how to view the recovery mode as I am new to this application.

How and I view whether the log backup is done or not?

Actually I...

Dear Neelakandan,

Thanks a lot.

I have solved the issue by using the case in the select query.

Thank you Jay.

It is working this is what I need it.

Dear Chirag,

Thanks a lot.

It is working now.

Hi,

When the query / stored procedure is executed along with the DBCC INPUTBUFFER(SPID), it is giving the query or the stored procedure.

Is there any method to get the last executed...