I am in the same boat with similar questions. Please let me know if you found any answers? Or if some one has any answers.

Thanks!

missed the screen caps with last reply. please find them attached with this reply

Thanks for your replies...

Vinoth - In simple english the requirement is to update the chqValue column with NULL for chqId 403. The way it works is, a webservice sends a...

All the DBA's or SQL gurus,

Can anyone give me an industry standard transaction error handling template. I know most of the syntax discussed till now works, but I want something...

Thanks Rozema. Really helps. But I am little confused now.

In your script you have

IF xact_state() > 0

-- Undo the named transaction.

...

Using all your inputs and from what I have read on BOL, I have come up with the below code. Please see my questions below. Appreciate your help.

BEGIN TRY

BEGIN TRAN

--...

Thats a really good article. I dint know about this at all.

Apart from that, what I would like to see if some points that a new DBA/developer needs to...

Thats a manual way of doing it on demand. I would like to know if we can automate it?

I checked the reports and found the tables that make use of the most disk space. After speaking to application team, they said that those tables are the mostly used...

Thanks all for your wonderful post and explanations. Really helpful.

Figured it out. One of developers changed the time on the server to 2012 which caused the issue! These developers! :w00t:

Both the SQL server and SQL agent are running under my local domain account which is part of Administrators group.

What I found is that Copy and restore jobs show the...

How can I check that?

Thanks for your reply.

All the logs are being copied appropriately. Its only the restore job is not able to restore the logs and skips. I dont have any maintainence plans...

Thanks for your reply. It was just a part of my testing that I deleted the full backup. I was surprised to see that errors got fixed all of a...