MisLead (4/24/2012)

---

....

Oh Ok. I don't think that serves the purpose then.Let me try to explain you better of the requirement because I think you know this thing well.

Input

???(JAPANESE)--------------------SQL FUNCTION/CODE---------------- ...

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you...

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you cannot store...

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

What is the data encoded in to start with? If they are truly multi-byte characters, i.e. Unicode on something other than plane-0, then you cannot store those in...

MisLead (4/24/2012)

---

opc.three (4/24/2012)

---

MisLead (4/23/2012)

---

I have no knowledge on c#. However i have the following code below that converts double byte to unicode. My requirement is reverse engineering i.e convert unicode...

Someone may have changed the configuration to 20, then changed it back. It does not require a restart. That action would be logged. Keep looking through the sql server error...

Ismael Aguilera Camacho (4/24/2012)

---

This is the log to sql server agent

2012-03-24 14:11:47 - ? [100] Microsoft SQLServerAgent version 10.0.5500.0 ((Unknown) unicode retail build) : Process ID 3732

2012-03-24 14:11:47 - ?...

What does this return:

SELECT name,

value,

value_in_use

FROM sys.configurations

WHERE name =...

Sounds like you have it setup correctly...but problems nonetheless. Attach your SSIS package to this thread, or send me a PM with the package and I'll be happy to have...

Gabriel P (4/24/2012)

---

Hello, I have a situation in where I have one db user (let's call it webuser) that has access to multiple schemas in a database. So far everytime...

I was going down the road of forcing schema-qualification in all queries, for example forcing all queries, say, within a stored procedure or script, to follow a form like this:

SELECT...

Geoff A (4/24/2012)

---

opc.three (4/24/2012)

---

Geoff A (4/24/2012)

---

if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not...

I alert for sev 17 or higher, plus a handful of specific numbers including 825.

Database Engine Error Severities

Geoff A (4/24/2012)

---

if you have a high use server with multiple databases in full backup mode with trans logs getting backed up alot, and you do not rotate the logs...

Heh, went and looked it up...not much more to say 😛