Bouke Bruinsma (11/25/2013)

---

I have come across a practical situation where a table does not have statistics because they are disabled. This table is used to temporary store ids of objects...

Are you inputting the right server/instance name?

Is the service for SSIS run?

Under which account it is running? check the account permissions.

Regards

IgorMi

You have an option "Keep index online while reindexing" in the Rebuild Index Task element in SSIS. Pressing button "View T-SQL" will script the indexes with the ONLINE=ON.

You can also...

Then it is may be not your problem?

Did you try, for a disabled login which you enabled, to drop the user and the recreate it...

If this query does not return...

Try only for one user which login was disabled.

(1) drop the user and then (2) recreate the user

and see how it's going to be.

Regards

IgorMi

Hi RBarryYoung,

Your script is useful. I tested it and it failed on an offline database. You can update the code so that only online databases are taken in consideration.

Thanks and...

CDC (change data capture) is aimed for that. I think it's the best option for you.

Regards,

IgorMi

What do you mean by "SQL Paging"?

Try to help yourself with this site

http://www.connectionstrings.com/

Regards,

IgorMi

When you run cliconfg.exe, do you find an alias for your sql server there?

Regards,

IgorMi

Did you check this

select sp.name,sp.[type],sp.type_desc,sp.is_disabled, sp.default_database_name,sp.modify_date

from sys.server_principals sp

and then

ALTER LOGIN [login_name] ENABLE

GO

Regards,

IgorMi

In general, having indexes on foreign keys is good.

Once, I have created a bunch of supporting missing indexes for FKs and the performance gain came. The goal then was...

Is it possible some code somewhere to make some mess, like CHECKPOINT, or change the recovery model and get it back. I don't think option auto shrink is turned on...

Strange...