Viewing 15 posts - 31 through 45 (of 48 total)
Hmmm, David, here's how I run BCP:
DECLARE @SQL NVARCHAR(2000)
SET @SQL = 'BCP Work.dbo.tblAccount_Raw IN "C:\DataFiles\AccountFile129814978600644674.txt" -c -t"|" -F"2" -T'
EXEC xp_cmdshell @SQL
Am I missing something?
Sean,
SSIS would be the alternative and...
May 25, 2012 at 3:01 pm
Thanks, that is great to have. The SQL Server is at a co-lo but they are being very dodgy about the level of service--which is at the lowest level they...
May 25, 2012 at 11:12 am
Hey, guys, the fun of flying is still there. Aeronca Chiefs are a bargain. If you do this kind of work, it should be accessible to you. Life is short:...
May 25, 2012 at 8:12 am
Alas, no. I've been learning about Team Foundation Server, Workspaces, Solutions, Branches, and Projects. I was sitting here this morning feeling all twitchy about that an other administration tasks that...
May 25, 2012 at 8:09 am
The first plane I 'owned' was technically a 1/5 share in an Aeronca Champ. There is still a very soft spot in my heart for Aeroncas--even if the cars on...
May 24, 2012 at 4:34 pm
The Bücker is a load of fun. There is pretty much nothing practical you can do in it: it sucks for transportation (2 hrs of fuel max, little cross wind...
May 24, 2012 at 2:47 pm
And we have a winner!!!! 8kb is scoring high on the psychic developer scale.
It appears that the problem was due to the procedure being called in the exec into,...
May 24, 2012 at 7:54 am
Thanks, guys.
And first to the important stuff: sturner... Does this mean you are trying to slow down or that you are trying to see what's in front of you?...
May 24, 2012 at 7:44 am
An excellent term, accidental dba. An accident for me but not a surprise. There is no one on this team that I can functionally discuss the difference between a database...
May 22, 2012 at 9:37 am
Ah, yes, the imperfect world thing. No where on my resume do I call myself a DBA, I market only as a SQL Server TSQL Developer, and it was a...
May 21, 2012 at 8:15 am
Yes, of course this Dynamic SQL is just garbage. Joins (unfiltered) 5 tables and a view and then adds in two cross applys to the output. All that is part...
May 15, 2012 at 1:51 pm
Thanks for the filters. I had the columns I wanted in the trace but needed to restrict it. Initially running it drug down the server to the point of having...
May 15, 2012 at 11:28 am
Ah, that was a great way to start the morning. Thanks, Ken.
It's a small, small company and everyone who works here regularly (unlike me, the glorious contractor!) is highly...
May 15, 2012 at 8:02 am
Ken,
Thanks! I had to explain why I was laughing to my husband when I was reading this.
When I tried to add transaction log backups to the maintenance plan...
May 11, 2012 at 6:05 pm
Viewing 15 posts - 31 through 45 (of 48 total)