Hi,

or I think at any moment the constraint related to the primary key, has been disabled and an update has been done, then PK constraint has been enabled .

--...

Hi,

I found an interesting articleb, you can determine whether you want to shrink or not.

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Regards,

Ahmed

Thanks a lot.

Hi Lynn,

Considering this article in sql server magazine, you need 1 licence for 1 quad-core processor.

http://www.sqlmag.com/Articles/ArticleID/95622/95622.html?Ad=1

I am sorry for the mistake

Thanks,

Ahmed

Hi,

Thanks do you have any microsoft reference, just in case please.

Ahmed

Hi,

It's me again, considering the following article http://news.zdnet.com/2100-9584_22-6038148.html

a quad-core is considered as eight-processor servers (so if you want to use all processors for 2005, in the future, you...

Hi,

For SQL Server 2000 Standard edition there a limitation, you can just use 4 processors (http://www.mssqlcity.com/FAQ/General/sql_server_2000_editions.htm).

Check this article, I think it will be the same for 2000...

Hi timothyawiseman ,

Check this link you have the solution http://www.sql-server-helper.com/tips/read-import-excel-file-p02.aspx

Your query will be

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;DATABASE=c:\exceltemp\xlsfile.xls;IMEX=1', 'Select * from [xlsfile$]')

Regards,

Ahmed

Hi,

I tried to make abulk insert with a file of 90 MB and which contains about 500000 rows, I had no problems, all row were inserted.

I used

Bulk insert test1 from...

Sorry

http://msdn2.microsoft.com/en-us/library/ms188267.aspx

Check the following, may be it could help

Do you have any error displayed

I think you have to use ROWTERMINATOR = '|'

Check the Microsoft sample

A. Using pipes to import data from a file

This example imports order detail information into the AdventureWorks.Sales.SalesOrderDetail table...

I am not sure about ROWTERMINATOR

Sory or an extra one like Rajesh Patavardhan said