Hello,

Sorry for asking, but just to be sure, is the data in the first ”column” of the import file too wide to fit in the target table’s column?

Regards,

John Marsh

Hello,

May be take a look at these articles:-

http://www.codeproject.com/KB/database/migrate-mysql-to-mssql.aspx

http://www.microsoft.com/downloads/details.aspx?FamilyID=3f0f2a3f-dff9-49cd-8ea7-581aa7a303a4&displaylang=en

Regards,

John Marsh

Hello,

This might be an issue with SQL Server. Take a look at the following link:-

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=274313

Regards,

John Marsh

Hello again,

(Sort of) yes - you can consider getting rid of them, but be careful because the counters are reset every time SQL Server is restarted. If that happens very...

Hello,

To quote BOL "The user_updates counter indicates the level of maintenance on the index caused by insert, update, or delete operations on the underlying table or view“.

i.e. this is normal...

Hello,

If the issue is related to a lack of system resources, then you could consider setting the SQL Services to auto start in sequential order i.e. to automatically do what...

Hello again,

I had one more thought: If the Error with State 16 is related, then may be another Maintenance Job is (sometimes) taking the user’s default DB offline. This would...

Hello Christophe,

We only have two types of weather in Luxembourg - either “sunshine with showers” or “showers with sunshine” 😉

Bonne journée,

John

Hello again,

I asked because the SQL Server Agent is not included in the Express edition of SQL Server 2005. I hope you have one of the other Editions.

Regards,

John Marsh

Hello again,

The message at 23:34:04 could be related.

To quote MS:-

“State=16 means that the incoming user does not have permissions to log into the target database. So for example...

Hello again,

Is there any Login Failure message or similar in the SQL Server Log around the time that the Step Fails?

Regards,

John Marsh

Hello,

Do you have the full message, particularly the Error Number and State? These are very useful when trying to diagnose connection issues.

Regards,

John Marsh

Hello,

I suspect it is a SQL Server Agent Job that you need.

Please see the SQL Server Books Online Topic “Implementing Jobs”.

BTW - Which edition of SQL Server do you have?

Regards,

John...

Hello,

If you only want to copy data from certain Tables, then may be Replication is what you need.

Regards,

John Marsh

Hello Christophe,

An interesting point from Carl Federl, though it should not put you off using the Money Data Types for storing Euro values. You just need to be careful what...