Besides NOLOCK being a bad idea in general, as it can lead to bad thinks like missing data, duplicate data and more, the NOLOCKS on a temp table are pointless.

if...

because my Google-Foo is strong, I Gave "mysql send email" a try.

That lead me to a link on the MySQL forums, and a subsequent link to a Visual Studio project...

Sean Lange (6/3/2013)

---

You lost me a bit in here. There is no MERGE statement in what I posted. There is no delete. It is simply an insert statement with an...

that's the point... there is no need to use the exact same screen to add administrators that you saw during the initial installation; that screen is just for convenience, and...

glad i could help; if there were more than just two...

If the Data ALWAYS contains the @ symbol, you could use some of the SubString functions:

;With MySampleData([val])

AS

(

SELECT '1596424@DAR'

)

SELECT *,

LEFT(val,CHARINDEX('@',val) -1) as OneWay,

SUBSTRING(val,1,CHARINDEX('@',val) -1) As AnotherWay,

SUBSTRING(val,CHARINDEX('@',val) +1,30) As RightSideWay

FROM MySampleData

WHERE...

Minnu (6/3/2013)

---

Hi Team,

Can u please tell me that the msg "UPDATE' is not recognized as an internal or external command,"

is coming from the SQL exec call or from the batch...

Also Logon Triggers are per server, and not at the database level, so i can login, and then access multiple databases with multiple commands, and a Logon trigger would not...

well, I've got two suggestions:

first, you should be using the INSERTED table so you only get the rows that were touched in this INSERT.

The second, is just to review the...

Ed Wagner (6/3/2013)

---

WOW! That's an intense nested CTE.

It ran fine until the year 2808, so I figured you must be bumping up against a converted numeric somewhere that was...

it's the order of operations.

create table StudentAccount references table Instructor,

so the script has to create table Instructor before it can

create table StudentAccount;

i reordered that one table...

I've got an HP G71, and bought one of thosse SSD/HD replacement Caddy to replace the DVD in the Side Bay with an SSD caddy.

it was really easy to do...

pretty sure all you need to do is toggle this option:

it's in place to prevent someone from making accidental changes:

after that, you will be able to modify the column in...

here's a few different ways to recover access by adding yourself as a sysadmin:

via powershell, which supports impersonation by a local admin:

http://sqlblog.com/blogs/argenis_fernandez/archive/2011/07/10/think-your-windows-administrators-don-t-have-access-to-sql-server-2008-by-default-think-again.aspx

via A Scheduled Task, which supports impersonation by a...

GrassHopper (5/31/2013)

---

I have a comments field that has certain values I want to extract into it's own field(new must be created). What is the syntax for doing this?

the data...