Try using BCP In from the command line using code similar to this.

bcp tblMyTable IN myfile.bcp -S MyServer -f MyFormatFile.XML -h "TABLOCK"

Hi Karl,

My apologies, you are correct, PRIMARY <> DEFAULT.

Can you try this?

use [MyDB]

GO

DENY INSERT ON [dbo].[MyTable] TO [MyTestLogin]

GO

DENY DELETE ON [dbo].[ MyTable] TO [MyTestLogin]

GO

DENY UPDATE ON [dbo].[ MyTable] TO [MyTestLogin]

GO

The...

I am pretty sure you can create a new filegroup and set it as the default filegroup. This will then allow you to set the original filegroup to read only.

After...

Moving the log table to a new filegroup and set the others to read only is probably the easiest option. The other way is to create a view for each...

It will be helpful if you can send me some t-sql code. Also, is there any foreign keys defined on this table? Or is there any views based on this...

Are you adding the primary key to an existing column in the table?

What took 25% longer to implement? Adding a non-clustered primary key with nockeck? This is not possible. WITH NOCHECK skips the checking of data before the primary key is created....

You can use the "WITH NOCHECK" option when creating the Primary key.

Example:

ALTER TABLE test WITH NOCHECK

ADD CONSTRAINT PK_test PRIMARY KEY (Id)

The above statement will create a new unique...

Will you be creating a clustered index as part of the primary key? If so, drop all nonclustered indexes first, add the clustered primary key index and then recreate the...

Sp_updatestate is a Microsoft system stored procedure and it uses UPDATE STATISTICS to update the stats. However, sp_updatestats only updates the statistics that requires updating. This is determined in the...

I have turned off autostats before I did the fullscan.

rowmodctr is not updated for partitioned tables...that is part of my problem.

See this link for more info: http://msdn.microsoft.com/en-us/library/ms190283.aspx

I also have several Microsoft certifications under my belt. I sit these exams to get closure. As soon as I pass the exam, I can start with a new one.

Try dropping or disabling your indexes before the insert.

http://stackoverflow.com/questions/751039/slow-bulk-insert-for-table-with-many-indexes