How big is the result set?

How does the SSIS package operate on the result set as it is received (as a set or row by row)?

In SSMS set results to text and run (replace DOMAIN\login_name with appropriate values):

select 'USE ' + name + '

GO

CREATE USER [DOMAIN\login_name] FOR LOGIN [DOMAIN\login_name]

GO

EXEC sp_addrolemember N''db_datareader'', N''DOMAIN\login_name''

GO

'

from master.sys.databases

where database_id...

For more info on BULK_LOGGED recovery and index rebuilds please see:

http://sqlblog.com/blogs/kalen_delaney/archive/2011/03/08/what-gets-logged-for-index-rebuilds.aspx

The default race is always running, unless it was stopped.

Look at the .trc files in the MSSQL\Log folder.

If the files cover the period(s) in question, the answer is in...

Object drop and create events are noted in the default trace.

You can see in there what process/user causes the drop/recreate, if in fact that is happening.

How much space are you leaving in the datafiles?

You also have to leave room in the data files for the index rebuilds.

The transaction log will need to be at least as large as your largest table.

David.Poole (12/4/2013)

---

For me the annual review process is where two adults are forced together in a mutually embarrassing situation where both could be doing something more productive and all to...

In general performance reviews are a charade.

Before the results of the review process are known, it has already been decided how much will be allotted to merit raises and...

You might want to consider table/index compression.

Edit: Sorry did not notice it was standard edition. Data compression not available

Have you typed the password out in a text editor and then copied and pasted it into the login window?

Are the SSMS the same version on both servers?

Same OS patch...

How are you trying to connect from the local machine to the SQL server?

SSMS or is it a application?

What is in the SQL server error logs for these failed login attempts?

If you want to brute force users out and then drop it, you can run:

USE [master]

GO

ALTER DATABASE [db_name] SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

GO

DROP DATABASE [db_name]

GO

Do you see Async network IO waits on all of the publishers or only the upgraded ones?

Have they checked the network interfaces on the new servers (full duplex?)?

What do round...