Viewing 15 posts - 1 through 15 (of 50 total)
Hello Sachin, did you find out the issue and were you able to fix it ?
March 20, 2014 at 4:56 pm
Thanks for the reply Matt.
I was testing about, how can I verify the same and I tried -
INSERT INTO ....
SELECT 10/0, 1
SELECT @@ROWCOUNT
As we know, 10/0 , divide by...
July 24, 2012 at 4:09 pm
Thanks Lynn :). I totally get it!
I read on the link below that even if I restart server, I can take up the differential backup without taking full back up....
June 29, 2012 at 4:09 pm
Should it be ok, to stop the job now during business hours ?
June 29, 2012 at 3:55 pm
The status of the job is 'RUNNABLE'.
CPUTime = 16
DiskIO = 16
May I know, what in specific are you looking for ?
June 29, 2012 at 3:49 pm
Thank you Lynn.
The error is (after few files are generated):
Msg 50000, Level 16, State 1, Procedure dbo.WriteFiles, Line 51
Error whilst opening the File System Object
The line has a declaration,...
October 27, 2011 at 9:29 pm
I appreciate your quick response along with reasons. Thank you very much!
June 8, 2011 at 2:04 pm
Ok. Yes, all these are related to single entity. The relationship is going to be 1:1. It doesn't matter if it is a single table of multiple tables, as in,...
June 8, 2011 at 1:33 pm
Solution is kind of similar to that of Nate.
DECLARE @STR VARCHAR(50)
SET @STR = ' Monday' -- 2 spaces here
SET @STR = ', Tuesday,...
February 7, 2011 at 4:12 pm
I appreciate your help Jeff.
I am sorry, I realize that I have mentioned Excel (in my other posts) which I have posted after the first one.
I managed loading the...
January 8, 2011 at 8:21 pm
Mr Cozyroc, I accepted that I can't code -> NET, JAVA, PERL... etc. If you call it laziness in your language, you are most welcome.
I do not have the code....
January 7, 2011 at 7:21 am
Phil, I never meant to offend you. People agree and disagree with many things.
But kindly, do not post any reply if your reply discourages others. People post here when they...
January 6, 2011 at 8:10 pm
Hello everyone,
I agree with Craig and disagree with Phil.
I succeeded in loading the file. Yes, it seems impossible but I succeeded in loading the file dynamically without using any third...
January 4, 2011 at 7:13 pm
Thanks for the response. I am really wondering, there must be some setting in SSMS for sure.
I ran the following queries in order to check if RTRIM is working and...
December 7, 2010 at 9:48 am
Viewing 15 posts - 1 through 15 (of 50 total)