Viewing 15 posts - 46 through 60 (of 179 total)
Yes, I tried John's response and did much more quicker. Thank You all.
December 13, 2010 at 11:04 am
I got your point John, let me give that a try first
December 9, 2010 at 1:00 pm
John Rowan (12/9/2010)
It would help if you could post the table DDL (full DDL w/ index...
December 9, 2010 at 12:47 pm
Hi John,
I did include column Status into clusterd Index for both table A & B.
The Status column in table A has many duplicates, thats the reason for the distinct
December 9, 2010 at 11:54 am
Hi Lowell, Apologies for the late response, I got cought up with some Prod issues.Here is the result from the execution script
Invalid drive specification
0 File(s) copied
NULL
Here is the current...
November 4, 2010 at 2:51 pm
Thanks Lowell,
It executed without any errors but nothing got copied over
November 2, 2010 at 2:23 pm
Thank you so much WayneS :-D.
The [] did the trick
November 2, 2010 at 10:13 am
I have changed my code a little as well and now I get different error message
DECLARE @cmd1 nvarchar(2000)
SET @cmd1 = 'IF ''?'' NOT IN(''master'', ''model'', ''tempdb'', ''msdb'')' + 'BEGIN...
November 2, 2010 at 9:02 am
I tried Use [?] and also Use ''?'' both returned the same error msg as below
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'Use'.
Msg...
November 2, 2010 at 7:40 am
They are only 11 rows in tableA that specify the date condition, I'll check on Casting the dates and update, Thanks
July 15, 2010 at 11:53 am
Thank You Ninja, I had tried as per your suggestion.I have opted to do it in another way.Adding it as a hyperlink to an ssrs report that has the data
Thank...
April 15, 2010 at 3:22 pm
Still getting 1 attachment
SET @s-2 = '\\xx.xx.xx.xx/d$/DailyErrorLog/DailyErrorLog.txt;\\xx.xx.xx.xx/d$/DailyErrorLog/DailyErrorLog.txt'
@file_attachments= @s-2
April 15, 2010 at 12:57 pm
I have tried the following, but no luck
[@file_attachments =@2PATH;@1PATH];
@[file_attachments] =@2PATH;@1PATH;
[@file_attachments] =[@2PATH;@1PATH];
Anything Im missing
April 14, 2010 at 2:23 pm
Viewing 15 posts - 46 through 60 (of 179 total)