Alex koranteng (11/15/2008)

---

Is it possible to import non fixed length CSV file into SQL server 2005 table. I have reading forums and have seen inconsistent reviews. I am a...

Heh... not unless you've ever had to pass an array from a GUI to the database....

I agree on both counts... storing numerics as varchar just doesn't sit well with me either. Neither does storing a large negative number as a default. You could...

If you have DTS or SSIS packages, they may be calling some of those jobs and they'll run when called whether they're disabled or not.

Cool... thanks, Steve...

Maybe I'm an old stick in the mud, but to me, it does matter.

For example, a lot of folks just flat refuse to work over 40 hours... can't...

You need to read the rest of my previous post... SQL Server CANNOT see your drive as...

Stupid question, but have you checked to make sure the object still exists? Someone may have dropped it or maybe a DBA renamed it to see who squawks to...

Ah..., sorry Brian. I was, in fact, missing your point. Now I understand what you meant and why. Thanks.

Just curious... do authors still get free copies? And, what was the cutoff for V6?

I got it right but this is a really bad question for people who are still stuck with SQL Server 2000. These types of questions should probably identify the...

Yet, the same company will break your horns for sending private emails from work or using the company telephone to make personal calls to an old flame in Australia.

Nah... mixing...

Good editorial, Steve. I noticed the following statement...

"On one hand I can understand that ethics and morals are becoming more important."

Heh... when were they ever not the most important...

I just ran the following on my server... only thing I changed was the file name to match a file I had.

DECLARE @hr int,@object int,@objfile int,@datecreated int,

@path varchar(200),@filename varchar(100)

set @filename='c:\Sample.txt'

EXEC...

You still miss the point... even if it's for one password, you shouldn't use RBAR to do it. Someone in a pinch will find the code and use it...