Perfect meaning all accounts or servers are registered, port numbers are spot-on, and even fully-qualified names are registered in case you used that, e.g. you could have registered servername.domainname.extension but...

Finding them in one of the tables referenced by sys.server_principals was just a hunch. They could be somewhere else too. Have you tried adding the Login and then dropping it...

I don't typically scrutinize the performance of DDL operations like an IF EXISTS...DROP block but calls to OBJECT_ID and OBJECT_SCHEMA_NAME will likely be equally slow. Joining to sys.schemas will likely...

When I have issues like this I run setspn /L and scrutinize the results. All SPNs have to be perfect for things to work.

You can select from those system tables only when logged in using the DAC.

It might be the table referred to by sys.server_principals. It's likely not documented.

I am assuming it is stored in a system table the first time it is resolved so it does not have to reach out to Active Directory every time you...

In that case you might try creating a Login from the Windows Account and then immediately dropping it.

http://blogs.msdn.com/b/vsto/archive/2013/03/06/office-developer-tools-for-visual-studio-2012-now-available.aspx

Chances are you need to issue ALTER LOGIN [DOMAIN\OLD.NAME] SET NAME = [DOMAIN\NEW.NAME]; to rename the SQL Server Login to have the same name as the Active Directory Account. This...

Sounds like double hop issue. What accounts are the SQL Server services on the prod servers running as? Depending on the answer, either check for an SPN registered to the...

Here is the script-form I use:

IF EXISTS ( SELECT *

FROM sys.objects

...

This could be solved using the Excel Object Model in a Script Task, bit it would be quite involved to program such a thing and really wouldn't require SSIS at...

The SqlBulkCopy class is the fastest way to load an ADO.NET DataTable to a SQL Server table.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

Sean Grebey (7/2/2013)

---

I was asking because from what I understand if there is a clustered index non-clustered indexes use the clustered key, otherwise it uses the rowID (file number, page...