An alternative is to grant the permissions in the model database - each new database will inherit permissions going forward. As far as existing stored procedures, views, etc you can...

Does BUILTEN\Administrators still have access? If the service starts up OK under the service account can you RDP into the box under this account and connect?

NP

K - other things you might also want to check, memory configuration (awe), max degree of parallelism, etc.

If your using MSSQL 2005 - use database mail; sp_send_dbmail (msdn2.microsoft.com/en-us/library/ms190307.aspx).

Hi Lynn - meant to say - confirm by issuing a DBCC SHOW_STATISTICS ('tablename','indexname'). The rows should match the rows sampled - if not update statistics with a fullscan (UPDATE...

Hi Lynn - are you running an update statistics with fullscan? sp_updatestats only performs a sampling....You can confirm by executing a DBCC SHOWCONTIG('tablename').

NP

There are a number of options available with respect to DR. Clusters are more commonly used for HA within the same site although I've seen implementations for DR as well...

You can use SSIS - i.e. launch SQL Management Studio, expand databases, right-click database, go to tasks, select export data.

Have you attempted to connect to MSSQL in single user mode? i.e. sqlservr -smssqlserver -c -f -m -T3608

I'm assuming the variable is scoped to the package? Are you using the SSIS package job step to set the variable? Have you tried the /SET option with DTEXEC.EXE to pass...

Have you attempted to connect to MSSQL in single user mode? i.e. sqlservr -smssqlserver -c -f -m -T3608

You can then get an ADM connection via SQLCmd and shrink/move data files...

What version of Idera are you running? Have you installed the extended stored procedures? I use an SP to invoke Idera using the extendend stored procedures and it works very...

You can always cluster SSIS -

http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx

Tommy