You mean aliasing?

The SQL Server Configuration manager does the functionality of the SQL Cient Networking utility as well as the SQL Server Networking Utility and Services manager.

It's an mmc snap-in...

Edit and run this:

CREATE DATABASE AdventureWorks

ON (FILENAME = 'c:\whateveryourpathishere\AdventureWorks.mdf')

FOR ATTACH

Exnted stored procedures are the old way - managed code and CLR integration is the new way.

If your old processes use xp_cmdshell you should instead write an assembly to do...

Basically you either need to format the data better before you try to import it or import it all and play with it afterwards.

I'd go with the first option -...

Sure - your confusion lies in that this diagram shows the foreign key relationships, they're not all primary keys.

There's a jumble of info in your post, perhaps by going through each issue you can get to a simple solution.

Your problem is that you want a simple procedure for...

Before it rolls back you should have the option to see the related issue.

Yes - Don't.

It's not supported by Microsoft, and your business should require that your solution is recommended and supportable by MS.

True, but how many times do people use the default - Primary Key, Clustered Indexed GUIDs are an extremely bad idea!

The new program is MCITP*: Database Developer

* Microsoft Certified IT Professional.

You need to pass exams 70-431, 70-441 and 70-442

The first exam is a generic test on SQL Server 2005, the...

Unlikely given the scenario. Even logged in interactively xp_cmdshell would execute under the context of the instance service.

Can you post the error message verbatim, and check the application and security...

You need to know versions.

Adventure works are a seperate installation.

SSIS is not available if you are using SQL Server Management Studio Express (SSMSE)

If it's a ful verison and you want...

THe attach code.

You've read the thread; so what are your auditing and security requirements?

If you think there's a piece of software that has the solution, you've failed to understand the problem.

The object can belong to any schema including dbo, the point is to include the EXECUTE AS dbo in the procedure, then grant execute on the procuedure to the batch...