Spam.

This thread and The Thread are killing my inbox!

An ANSI character set is a set of numbers that represent every letter in the alphabet and every number from 0-9. They also represent punctuation marks, spaces, tabs, line breaks,...

Glad we could help. And very glad it wasn't something worse.

chandan_jha18 (7/27/2011)

---

Lowell (7/27/2011)

---

based on this ms doc, where changing the server collation requires a rebuild:

http://msdn.microsoft.com/en-us/library/ms179254.aspx,

i'm guessing that the server collation is actually the collation of the resource database, regardless...

Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking for.

Green

- Win. (7/27/2011)

---

If you are on Win 2003 box, you can give a try ,

Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment...

Does the new account...

Is there a problem with restarting SQL Agent? (which is required when you change accounts).

You'll want to start posting in the Certification thread to get answers. But just an FYI: No SQL 2005 exams are open anymore. They all closed in June. The only...

Lowell (7/27/2011)

---

Riskworks (7/26/2011)

---

I have a SP that returns a table variable. It compiles and runs with no issues.

When I call it from another Proc I get an error saying...

Look into the Patindex and Charindex functions (you can find them in Books Online by searching for those keywords). You can use those to determine where the @ is, then...

Then take Chris's code and adjust it. Expand the temp table's column list, making sure the Name column is the first one, then do the insert as he says. Make...

Eugene Elutin (7/27/2011)

---

Why we should believe you but not B. Gates? Have you made a fortune writing SQL stored procs, so we can trust your words? 😀

....

If you are right,...

I'm almost scared to ask...

Why are you changing the registry setting for collation? And to a value that isn't even a proper collation value?