How about something like:

CREATE TABLE table1 (

Field1 varchar(255),

Field2 datetime DEFAULT (GETDATE())

)

remove the GETDATE() from your xyz.txt file and run the bulk insert query

BULK INSERT table1 FROM '\xyz.txt' WITH (ROWTERMINATOR =...

So what was your solution?

(BTW-please don't double post....you have another post with the exact same question.)

-SQLBill

What OS are you installing it on?

-SQLBill

Check to see if your database properties got changed to AUTOCLOSE (Enterprise Manager, right click on the database, select Properties, go to the Options tab).

-SQLBill

Ben,

I don't know why that poster added that link as it had nothing to do with the question.

Lumigent makes a product called Log Explorer. This product is supposedly (I've...

It has to be after checkpoints. In SIMPLE recovery mode you can not do Transaction Log backups.

-SQLBill

Make sure you first restore the full backup using the WITH NORECOVERY option.

-SQLBill

Why not ask your firewall admins what port they would prefer you to use for the TCP connection? That will keep you on their good side as you are including...

1. Where did you get the .mdf file from?

2. Was it copied while the database was still attached?

You cannot copy a mdf file while the database is in use. It...

Wow....a 300GB database with TempDB up to 1 GB. My 250+ GB database and my TempDB frequently grows to 4 GB or more.

I say put the TempDB on another...

Also, where is your log file located? And what is the size of the drive or partition that it is on?

-SQLBill

Why would anyone ruin a good Tequila with a beer? I say chase a shot of Tequila with another shot of Tequila. (and my wife wonders why my Tequila...

Tequila!!!!!!!!!!

And I might need one after today...started work at 0800 (EST US) and hope to leave work by 2300 (EST US).

-SQLBill

Here's another insight....I did a paper for one of my college courses where I had to interview someone from another career that I might be interested in. I interviewed...

I used to scuba dive. Now I kayak, ride a 'bent, golf, or just relax reading.

For those of you who don't know.... a 'bent is the short name for...