Check in the data what ASCII numbers are for your characters.

Here is a VBscript sample of how I check. The script is not perfect, it just loops through first 30...

It does not look correct to me too, still says: "Correct answer: Windows Server 2008 Datacenter Edition x64, Windows Server 2008 Enterprise Edition x64 " and shows my...

I would use a server trace (Profiler trace):

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

How to: Create a Trace (Transact-SQL)

one of the answers is part of another answer

You should script the logins with the same SID for another server. There are Microsoft articles on How to move SQL Server logins

Hi,

what is the error message when you are trying to login?

also, to what server you can not login: the local one or the remote one?

Good luck!

I know how you feel: I don't know Oracle, Linux and Unix and one of my apps is Linux/Oracle so I am really trying to learn.

Ok, then the answer to you problems is a "junior DBA"who will re-create your plans. You don't really want Microsoft's "junior DBA" sittin' there and fixin' migration wizards :-)...

My SQL-DMO application Enterprise Manager refuses to work with SQL Server 2005. So I said NO and would like at least one point for that answer.

Can you just exclude Temdb?

Does not work this way. People requested their databases back 6 month after we moved them and did not move databases that we were told nobody was using.

SSIS is SQL Server Integration Services and it is a 2005 version of 2000 Data Transformation Services. It is a part of SQL Server.

If you don't know how to work...

Hi,

Saving query results in other formats is tricky! Somebody here on this forum answered to me, so I am not entitled to a credit. Here is how to do it...

It was my first question when I read the Question of the Day: what schema is referred to: table design or owner abstraction layer?

Schemabinding does refer to the design.

Hello,

This article explains how it works

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

please read it and then ask here if you need to know more details.

but basically the application takes care of the user authentication in any...