which edition of SQL server are you using?

I am using Enterprise edition.

I am using Sql Server 2005. So, before I start importing, change the recovery model to BULK and once I am done importing, change it back to FULL. I will...

So, in my case, it should look something like this then..

bcp mydb1.table1 in mydb2.table1 -T -c

In my case, the destination table does not exist. I have been following the import...

Hi SSCrazy,

Could you specify more on bcp?

Thanks!

After getting these errors, I will definitely dig into your solutions and cautions so the errors don't happen in the future.

Here is my scenario: I have this database which...

Hi P_DBA,

I was able to run everything fine this time. The import was successful and all the...

This time I don't how but I was able to get the data imported into new database mydb. Right now, I am in the process of running the stored procedures...

When I right click on the mydb database:

Files->

Logical Name : mydb

File Type: Data

FileGroup: PRIMARY

Initial Size(MB): 100

Autogrowth: By 1 MB, unrestricted growth

Path: to the C drive

FileName: mydb.mdf

When I go to change...

Since we were runnng out of the space in C drive, we got rid of some .mdf and .ldf files using Unlocker. So, I came into Sql Server 2005 and...

I ran this and I am coming up with 0.

Select log_reuse_wait from sys.databases where name='mydatabase'

This is what I tried to truncate the log file.

USE mydatabase

GO

DBCC Shrinkfile ('mydatabase_log', 1)

BACKUP LOG mydatabase...

Hi P_DBA,

I know how to switch to a full recovery model but how would I do...

I didn't get it when you said i can change the dbf to a flat file. Could you please specify what do you mean when you said change that to...