Still no answers on desired Collation of returned VARCHAR types...no answer to answer potential substitution issues if no E/ASCII code point is found...no answer on how exactly to strip apart...

+1 for Service Broker (SB)...the use-case described might be the most common of all. And no, no concerns about reliability, Microsoft uses SB within the SQL Server Database Mail subsystem,...

MisLead (4/26/2012)

---

opc.three (4/26/2012)

---

I think MisLead (ironic name given the conversation, no? :-D) wants to store the data as NVARCHAR, but wants to provide an interface for this legacy app to...

I think you will need to do all of this in a Script Task using the Excel Object Model to inspect each Excel Workbook to iterate over the Worksheet collection,...

Here is a video on how to do the same...sometimes with SSIS it helps to see someone develop it realtime:

Looping Through and Loading Files with SSIS

If it is not causing you trouble in terms of disk space, then there is no harm in leaving it as is. Backups will only write the actual data, so...

Peter Lavelle-397610 (4/25/2012)

---

Hi pandionk1977,

What you have is a recursive trigger.

After an Insert or Update to table Blanco_B2 you are running another 3 Updates to table Blanco_B2 which will each fire...

durai nagarajan (4/26/2012)

---

can i add individual accounts in sql and block there access will this work.

Tthe query you have given is not giving the administatrors name but still they have...

I think MisLead (ironic name given the conversation, no? :-D) wants to store the data as NVARCHAR, but wants to provide an interface for this legacy app to get that...

Also, can you please provide the version, edition and bitness of your OS and SQL Server instance?

And the results of this query:

-- memory overview

SELECT CAST(physical_memory_in_bytes / (1024.0 * 1024.0...

I have not tried any third-party solutions for SQL Server HA. I'll just throw this out there, if you're thinking of buying into a third-party product the as part of...

That design is pure evil! Dynamic SQL has it limits in terms of how much you should do before the codebase becomes unmaintainable...and I fear you would be pressing to...

There is no way to completely prevent...

Very cool. I have considered plan guides to help with issues brought in by third-party apps, but have never had to implement one as a different path to resolve the...

Lynn Pettis (4/25/2012)

---

I am still waiting to here the reason for all this work? What is the case for doing it? What other alternatives are there that would...