But it still causes an issue when trying to use them in their full 21+ character format when adding to SQL services and when adding to SQL security...right? That is...

Not really buying that since we can create objects with long names and SQL Server is the only place where it's limited in length. I mean we're not asking for...

Perry Whittle (9/25/2014)

---

SQLJocky (9/24/2014)

---

Does anyone know definitely what the maximum usable character length is for AD objects (users and security groups) to be added as Logins for SQL Server? ...

Thank you for the response. Though this is interesting, I'm not worried about the ability to pack items efficiently, rather reducing the man power required to pick items. So...

This is actually for a client I help support. They have a system that they enter downtime entries in but it doesn't allow for individual entries to be bulk...

Ahhh, okay I see. Thank you all for your help!

Yes, all of the _dta_ listings are showing as hypothetical.

It just came back with:

Command(s) completed successfully.

No error messages.

I get the following errors:

Msg 3701, Level 11, State 7, Line 1

Cannot drop the statistics 'ABCTable._dta_index_ABCTable_c_7_745806881__K2', because it does not exist or you do not have permission.

Msg 3739, Level 11,...

Yes, they are actual stats...they show up as named in sys.stats. I thought it was weird for them to be there without a corresponding index too.

Table:

ABCTable

Indexes:

IX_ABCTable

IX_ABCTable_1

Statistics:

_dta_index_ABCTable_7_745806881__K2

_dta_index_ABCTable_7_745806881__K2_5

_dta_index_ABCTable_7_745806881__K2_K1

_dta_index_ABCTable_7_745806881__K5

_dta_index_ABCTable_7_745806881__K5_K2

_dta_index_ABCTable_c_7_745806881__K1_K2

_dta_index_ABCTable_c_7_745806881__K10

_dta_index_ABCTable_c_7_745806881__K2

_dta_stat_745806881_2_1

_dta_stat_745806881_5_2

_WA_Sys_00000003_2C741C21

_WA_Sys_EmailID_2C741C21

_WA_Sys_PK_2C741C21

_WA_Sys_TransactionID_2C741C21

IX_ABCTable

IX_ABCTable_1

Actually after a bit more digging I was able to find the answer here:

Thanks for the response. Yes, the company has a DR site already setup with VMWare infrastructure and are planning for everything. We just need to determine what the...

Yes. I passed on the recommendation with an example to the developer and told him to test it out. 🙂

Thanks Jeff...that makes a lot of sense! 😀

Thank you all. This has been very informative. This was all to help answer a question on shrinking log files in 2008. The real issue is that...