247 reputation
311
bio website thingsthatgobleep.com
location New Zealand
age 33
visits member for 3 years, 5 months
seen Feb 17 at 23:31

I am a gamer, programmer, and a wannabe linguist who is fluent in English and Mandarin, and proficient in French.

I am an achievement hunter. Come and visit me on trueachievements.com

I am also an administrator on Wiktionary and have been for over 3 years. I edit mostly in French, Dutch, English and Mandarin, but I also dabble in Italian, Japanese, Maori and Swedish. We are constantly looking for competent volunteers/lexicographers to contribute to this wonderful multilingual dictionary website.

profile for James Jiao on Stack Exchange, a network of free, community-driven Q&A sites


Feb
17
awarded  Critic
Feb
17
comment Outer join with blank spaces to accomodate both sides
Might be good to show your own attempt first. This is a very basic SQL join question.
Sep
15
awarded  Notable Question
Jul
2
awarded  Curious
Feb
27
accepted What is the MS_PerfDashboard schema in msdb?
Feb
26
asked What is the MS_PerfDashboard schema in msdb?
Oct
17
accepted What happens when the mirroring server goes offline (for a short while)?
Oct
17
asked What happens if you accidentally insert data into a replication target table?
Jun
7
awarded  Popular Question
May
20
awarded  Caucus
May
20
awarded  Constituent
Apr
5
comment Cannot start SQL Server service on SQL Server cluster
What does the cluster log say and what does the Windows log say exactly? Did you accidentally cut off the error message after error code 259?
Nov
27
comment Denied access sending dbmail while impersonated under a login with sysadmin privilege
That did turn out to be what went wrong. There is, however, another way, that is, to use certificates. It's much more secure than turning on TRUSTWORTHY.
Nov
27
accepted Denied access sending dbmail while impersonated under a login with sysadmin privilege
Nov
25
revised Denied access sending dbmail while impersonated under a login with sysadmin privilege
added 208 characters in body
Nov
25
asked Denied access sending dbmail while impersonated under a login with sysadmin privilege
Oct
13
awarded  Yearling
Aug
24
comment What happens when the mirroring server goes offline (for a short while)?
Sounds reasonable. Should I also disable trans log backup on the principal while the mirror is down?
Aug
24
asked What happens when the mirroring server goes offline (for a short while)?
Aug
22
accepted Unable to alter authorization on an mirroring endpoint to a login with a slash in the name