By default, named instances listen on a dynamic port.

You can change that from the Configuration Manager.

Here's an article on the subject: http://blogs.msdn.com/b/arvindsh/archive/2012/09/08/how-to-assign-a-static-port-to-a-sql-server-named-instance-and-avoid-a-common-pitfall.aspx

Once you configure the static port, open incoming...

Looks standard SQL-92 to me.

Please note that the UNION could be a cheaper UNION ALL (doesn't perform a DISTINCT).

Thanks for correcting me, Grant.

Sorry for posting incorrect information.

The profiler trace can only capture the estimated execution plan. The actual execution plan is available only when you run the query.

Does anything interesting turn up in the connectivity ring buffer?

See this article for reference:

http://www.johnsansom.com/using-sys-dm_os_ring_buffers-troubleshoot-connectivity-issues/

File is not opening where? Doing what?

Are you trying to attach the mdf file from SSMS?

Are you restoring a backup?

100 tables is too many? Really?

I'm sorry, but I don't seem...

Did you look for errors in the event viewer?

Is there anything interesting in the MSDTC log?

What do you mean "corrupted"?

In which state is the database now?

How did you check it? DBCC CHECKDB? Can you post the output?

What do you mean "too large"?

It already asks for a password whenever you connect using SQL Server authentication.

When you connect using Windows authentication, it asks for a password at logon.

Isn't it secure enough for...

Lots of limitations apply: it's not a simple "switch" or "move to the in-memory filegroup".

Here's a "getting started" article: http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/26/getting-started-with-sql-server-2014-in-memory-oltp.aspx

These forums are packed with gentle people that could try to help you, but please consider joining an Oracle site if you want guidance on Oracle technologies: this is a...

Please don't.

If you switch to SIMPLE recovery, you'll lose the ability to perform point-in-time recovery. You can do it temporarily, for instance during ETL loads, but right after switching back...

If the tables you want to look up are in the destination SQL Server, I would insert the rows to a staging table at the destination and perform the lookups...

Transfer the schema ownership to another user first:

ALTER AUTHORIZATION ON SCHEMA::someSchema TO anotherUser;

You can use developer edition in this case. What you are doing with other softwares in the same machine has no impact on the licensing model for SQL Server.

Remember that...