On your task that imports the file have you checked the column length for this column in advanced settings input and output columns? My guess is that in your...

You must have dual-core CPU's and SQL Server recognizes each core as a processor, while the max processors allowed is based on sockets not cores.

Normally in SQL Server settings 0...

I agree with Mark. SQL Server, even 7 and 2000, when accessed by well-written code should not need to be rebooted other than for server maintenance reasons.

Did Atif's solution work?

What is the error?

You could do an explicit convert to character(varchar) on the numeric columns.

The simplest way to manage security in your instance, and I know you said you did not want to use a role, is to create a role with these rights...

In SQL Server 2005 SQL passwords are set by default to have to meet domain password requirements. The odds are your sa password does not meet this requirements so...

Rejeev,

You want to do a command line install of SQL Server Express/MSDE. You can include the installers for MDAC and Express\MSDE in your install package. Then you can...

Sure you can select them all in BIDS and then paste them in the package. They will get a number added to the end of the name.

Did the service account for SQL Server get changed?

Have you logged into the server using the SQL Service account to verify that the Outlook Profile is still working?

I'm not sure but I think the CAST is being done BEFORE the filtering.

Also you may just have had an invalid value inserted into that column. you can use...

Is the network route the same between the dev server and oracle server and the prod server and oracle server?

Why are you using dynamic SQL?

You may not think code would help, but you haven't gotten much help without it either. Seeing the code may trigger someone's memory.

Have you compared all the database options?

Have...

Has it been disabled?

It would be easier to help if you posted some code. I can't think of any reason why creating a stored procedure would fail because of truncation.

You...

So your script is not waiting for the previous process to complete?

If you do go with 2 steps make sure you do the clustered index first as that key is...