Ctrl + Alt + G

Brings up registered servers, add and remove as you like.

You need to create a reference for each sheet that SQL Server understands.

You do this through Names:

Insert > Name > Define

To clarify:

Windows authentication is ALWAYS enabled.

The authentcation mode options are whether you allow SQL authentication or not.

AS above.

Grant the DBA group sysadmin access, drop Builtin\Administrators.

This is the MS advised process, it does not cause problems.

Be aware that your database is then only secure from casual misuse....

whats the procedure, what parameters does it need and when do you want it to fire?

If you provide this information I can provide a more comprehensive answer.

Surely if you just want a list of values SELECT DISTINCT would be better.

PIVOT allows you to manipulate the data to give it in effectively another format.

So assuming other columns of itemid and shape

--A table something like this

CREATE TABLE objects (itemid int,...

This could be anything from the disabled network libraries to the user account used to login.

Can anyone login? What's the exact error message?

The best way to migrate data is...

Use the Integration Services (SSIS) Import and Export Wizard to copy data between multiple instances of SQL Server. For more information, see Creating Packages Using the SQL Server Import and...

Yes, you'll be fine.

You need to determine which features are important to you in particular with regards to availability - basically why are you upgrading? Otherwise there is nothing special...

Nooooooooooooo!

ON DELETE CASCADE

Sure, use the service broker - whats the procedure, what parameters does it need and when do you want it to fire?

Not really. It prevents SQLs new memory management system from handling it dynamically. I believe Oracle does things the same way.

In SQL Server 2005 users are not able to list objects that they do not have permissions on. I'd check the group memberships of this user.

Master is now an interface...

Ooh, that's cheating! Now we'll never know what the problem was