247 reputation
310
bio website thingsthatgobleep.com
location New Zealand
age 33
visits member for 2 years, 11 months
seen Sep 8 at 4:44

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


2d
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
Aug
22
comment Unable to alter authorization on an mirroring endpoint to a login with a slash in the name
Bingo! Yatsi! I usually use the square brackets for weird db or column names like 1234-abc, but didn't think it would apply here. Worked like a charm. Thanks Shark.
Aug
22
asked Unable to alter authorization on an mirroring endpoint to a login with a slash in the name