Viewing 15 posts - 196 through 210 (of 371 total)
Wow, very elaborated question.
It made my brain hurt for a second.
I've got 3/4 options right.
I only missed one which should have been basic knowledge to me:
"The amount of space used...
November 9, 2011 at 5:10 am
jshahan (11/8/2011)
Lastly, you reach a point in either case where the work just begins to make sense and you get that wonderful (and deeply needed) feeling of control.
Well...
November 8, 2011 at 2:43 pm
Ninja's_RGR'us (11/8/2011)
Back to step 0.DELETE the cursor and rewrite to set based.
Post the code if you need help doing that.
😀 Of course, my friend. That will be arranged one day.
The...
November 8, 2011 at 7:50 am
GSquared (11/8/2011)
November 8, 2011 at 6:50 am
Raw Materials always make me laugh hard in my office.
Keep up the good work.
Best regards,
November 8, 2011 at 3:45 am
Koen Verbeeck (11/8/2011)
It is always a good idea to run scripts from the internet on the master database of the production server 😀
:laugh: :laugh:
It crashes here are well and I'm...
November 8, 2011 at 3:13 am
If you can afford to wait 5 or 6 months, SQL Server 2012 is going to be released with what seems to be a great addition to the T-SQL commands:...
November 7, 2011 at 1:50 pm
Nice and easy question for a Monday morning.
Thank you.
Best regards,
November 7, 2011 at 3:08 am
I agree as well.
In a romance we're dealing with fictional or real characters (and they can curse and do whatever they want) so we're able to take some literary freedom,...
November 6, 2011 at 6:07 pm
Thank you for the link, Gail.
It's a very well written article about a very important subject.
Best regards,
November 5, 2011 at 12:34 pm
huslayer (11/5/2011)
wouldn't SSIS yell and gives an error for that?
Probably yes.
Have you tried to change the operation to "Copy File" instead of "Move File" and then have another File System...
November 5, 2011 at 11:01 am
r.dragoi-1095738 (11/4/2011)
I would select the rows first into a variable table and after that I would use the cursor (over the variable table)
I would advise that as well.
I may be...
November 4, 2011 at 11:41 pm
And another stupid question: maybe someone has the file opened or being used while your job is trying to delete it?
Best regards,
November 4, 2011 at 11:33 pm
Evil Kraig F (11/4/2011)
(these are the non-computer ones)
- Janitor
- Stock Broker
- Costume Shop manager
- Warehouse...
November 4, 2011 at 5:13 pm
AFAIK it's possible but you'll have to be careful with difference on features between Enterprise and Standard editions.
More info here:
Best regards,
November 4, 2011 at 4:46 pm
Viewing 15 posts - 196 through 210 (of 371 total)