I personally think developers need to learn about SQL Server security also. I've seen a lot of code fail due to lack of understanding of SQL authentication and how SQL...

It sounds like the default database that the login is associated to has been dropped.

Check the login properties. See what default database it is associated with. If the database no...

There are certain features that are not available during install and must be configured through the SQL Server Configuration Manager (you can find it in your Start -> Programs menu...

You're welcome. And FYI: I had to link through three entries to find it, so even if you had looked, you might not have seen it.

<snerk>. I was going to post...

Is that a chicken hawk?

Your English is fine. I understand you and you understand what you need to do.

Mesa don't think so. No, mesa don't.

It's all in the mapping. If you're using an actual SSIS package (as opposed to the Import/Export Wizard), you create a file connection manager with different names for the columns,...

Per Books Online:

BOL- debugging [SQL Server], Transact-SQL debugger (Breakpoints Window)

On the Debug menu, click Windows, and then click Breakpoints.

Breakpoints Window ColumnsBy default, the Breakpoints window...

I'm going to ask a stupid question.

Did you ensure that the hardware and OS you're installing is 64 bit?

EDIT: My bad. Googling the error indicates a language problem. What is...

There are a couple of possibilities....

Given Excels lack of true data types, I am not a big fan of the OPENROWSET approach to your problem. I've seen more than than enough problems with numbers being...

Miss U

If I've already announced this here, I apologize for the repost. I'm just so excited I can't remember where all I've shared the news already.

I am beyond thrilled today to...