That's perfect sir...Thanks a lot for your timely help 🙂

Thanks you.

I will try to find/write out the tool/script.

Once again thanks to all for the valuable suggestions and help.

Thanks again. I echo with your words, developing queries for the above criteria is complex and time consuming at the same time there are no permission to use the tools...

Thanks you for the suggestion. However any other alternate way like script.

My requirement is for first column values only. No problem if other columns having duplicate data.

Thank You.

Just FYI,

Restore database was successful after fix.

Thank you so much once again.

Regards,

Dropped and re-created the default constraint for the table and ran the CHECKCATALOG command successfully.

Taken the backup and restoring the db.

Hope this will work fine.

Thanks a lot for all the...

When ran DBCC CHECKDB there was no error messages.

But when ran DBCC CHECKCATALOG reported the following error.

Server: Msg 2513, Level 16, State 5, Line 1

Table error: Object ID 1412200081 (object...

Thank you sooo much for simple and awesome query.....

Any more alternates?

Thanks,

Bagath (5/13/2008)

---

Hi All,

Please excuse me for asking this question in this forum.

I need some help regarding my career plan

Presently i am working as SQL Server DBA and recently...

Yes i do have 4 gb RAM..

Ok i won't go for that..Could you tell me what will happen if i do? any specific reason?

Thanks,

Thanks a lot for the information.

I would try to implement the steps.

Bagath

Could any one help me on this....Still i am unable to find the solution...

Your suggestion would be very helpful to me...

Thanks,

i asking about the date when the dst patch was updated...

I wanted to get that date from T-sql using a query so that there will be no manual check for...

Could any one help me on this?

Any suggestions would be very helpful to me....

Thanks in advance,