Viewing 15 posts - 1 through 15 (of 17 total)
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!
January 29, 2015 at 12:02 pm
missed the screen caps with last reply. please find them attached with this reply
January 25, 2012 at 2:11 pm
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...
January 25, 2012 at 12:34 pm
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...
November 30, 2011 at 8:58 am
Thanks Rozema. Really helps. But I am little confused now.
In your script you have
IF xact_state() > 0
-- Undo the named transaction.
...
October 18, 2011 at 12:35 pm
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
--...
October 10, 2011 at 9:42 am
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...
October 3, 2011 at 9:32 am
Thats a manual way of doing it on demand. I would like to know if we can automate it?
October 3, 2011 at 9:31 am
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...
September 28, 2011 at 9:31 am
Thanks all for your wonderful post and explanations. Really helpful.
September 23, 2011 at 8:23 am
Figured it out. One of developers changed the time on the server to 2012 which caused the issue! These developers! :w00t:
September 20, 2011 at 9:51 am
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...
September 16, 2011 at 2:10 pm
How can I check that?
September 16, 2011 at 1:47 pm
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...
September 16, 2011 at 10:50 am
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...
September 8, 2011 at 9:52 am
Viewing 15 posts - 1 through 15 (of 17 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy