Viewing 15 posts - 6,136 through 6,150 (of 7,168 total)
Maybe I am just being closed-minded here, but I would not choose to kick off any file manipulation tasks directly from T-SQL. I understand the need however so for discussion...
June 10, 2011 at 12:53 pm
PS he script is for PowerShell 2.0. It may work in PowerShell 1.0 but no promises.
June 10, 2011 at 12:38 pm
Crispin Proctor (6/10/2011)
You could use a pretty simple command line delete via xp_cmdshell.
xp_cmdshell is disabled on all systems by default since SQL 2005 for a reason. Can it be properly...
June 10, 2011 at 12:37 pm
Craig Farrell (6/10/2011)
It's...
June 10, 2011 at 11:50 am
JAYANTH KURUP gave you a solution but might I suggest you use MERGE instead. It looks strange at first but once you learn the syntax it becomes easy, plus it...
June 10, 2011 at 11:42 am
Phil Parkin (6/10/2011)
I'm interested to know how you avoided getting a meta-data error as a result of the expected columns being missing on the dodgy row?
Guessing a little but it...
June 10, 2011 at 11:16 am
Craig Farrell (6/9/2011)
In SSIS, It's not detecting the {CR}{LF} properly,...
June 10, 2011 at 11:14 am
carsten.jorgensen (6/10/2011)
June 10, 2011 at 10:55 am
Jnrstevej (6/10/2011)
Thanks for the post it worked perfectly
Double happiness 😀
June 10, 2011 at 9:25 am
John, Consider asking for a change to a typed input parameter. A lot of the validation logic will then vanish (Edit: as was previously stated, wasn't trying to be a...
June 10, 2011 at 9:10 am
carsten.jorgensen (6/10/2011)
Yes - The synonym in db DBX is in a schema owned/authorized by dbo.
And I do understand why you are suggesting that even DBX should...
June 10, 2011 at 8:29 am
Crispin Proctor (6/10/2011)
can I add, bcp looks cooler when in full screen. More so if you star at it intently and mutter when strangers walk by :hehe:I win 😉
I...
June 10, 2011 at 7:49 am
My normal approach is to split the file with winrar into 100MB chunks and repair volumes. Makes it easy to copy the file and if there is a problem, winrar...
June 10, 2011 at 7:21 am
Crispin Proctor (6/10/2011)
What you are doing is telling 10000 people to step forward, checking to see you've not spoken...
June 10, 2011 at 6:26 am
carsten.jorgensen (6/9/2011)
We did some changes to our production SQL server instance a couple of days ago.
After the changes were applied, it turned out that a specific application failed and...
June 9, 2011 at 4:50 pm
Viewing 15 posts - 6,136 through 6,150 (of 7,168 total)